Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002891
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2008-04-17 09:592008-07-04 15:31
ReporterDowidView Statuspublic 
Assigned Topheenan 
PrioritynormalResolutionfixedFixed in Version2.40beta
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002891: The date filter in the Offers Report doesn't work correct

DescriptionGo to:
Warehouse Management->Analysis Tools->Offers Report

1.When entering correct date values, the report doesn't generate. The reason for this is that, the "From Date" and "To Date" are backwards. Whereas, "From Date" = "To date" and "To date" = "From date".


Enviroment:
OS: Windows XP SP2
DB: Oracle XE
Browser: FF2
Openbravo: 2.35
Language: English
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0003567)
Dowid (viewer)
2008-04-17 10:00
edited on: 2008-06-12 09:25

Logged In: YES
user_id=1630374
Originator: YES

The reason of this bug is logic error in ReportOffer_Data.xsql
in the Select method:


Part of code:

AND DATEFROM <= TO_DATE(?)
AND (DATETO IS NULL OR DATETO >= TO_DATE(?))

Should be:

AND DATEFROM >= TO_DATE(?)
AND (DATETO IS NULL OR DATETO <= TO_DATE(?))
(0003568)
Dowid (viewer)
2008-04-17 10:06
edited on: 2008-06-12 09:25

Logged In: YES
user_id=1630374
Originator: YES

There is one more problem that I've found in this report.
The Calendar popup is in Spanish when you login in English.
(0003569)
pheenan (viewer)
2008-04-23 12:23
edited on: 2008-06-12 09:25

Logged In: YES
user_id=1883435
Originator: NO

Fixed date filtering. Committed in revision 3728 in trunk. Backported in revision 3729 in branch 2.3x
(0006480)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1944705 [^]

- Issue History
Date Modified Username Field Change
2008-07-04 15:31 plujan Status resolved => closed
2008-07-04 15:31 plujan Fixed in Version 2.40alpha-r2 => 2.40beta


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker