Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017995Openbravo ERP09. Financial managementpublic2011-07-15 12:532011-08-17 09:38
Reporterxabiermerino 
Assigned ToioritzCia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesPayment Report
Support ticket12125
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017995: The Payment Report does not filter properly by Due Date
DescriptionYou have an invoice with due date 28-08-2010

With this criteria: Due Date From:28-08-2010 Due Date To:28-08-2010, the invoice does not appear.

With this criteria: Due Date From:27-08-2010 Due Date To:29-08-2010, the invoice appears
Steps To Reproduce- As Admin go to Payment Record.
- Launch the report:
     -Due Date From: 25-08-2010
     -Due Date To: 27-08-2010
- Realize that some invoices appear
- Launch the report:
     -Due Date From: 26-08-2010
     -Due Date To: 26-08-2010
- Realize that the report does not show any data
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0018193 closed ioritzCia The Payment Report does not filter properly by Due Date 
related to defect 0017568 closed ioritzCia Amount and date ranges excluding limit values (> and <) and NPE when data not found 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-15 12:53xabiermerinoNew Issue
2011-07-15 12:53xabiermerinoAssigned To => dalsasua
2011-07-15 12:53xabiermerinoModules => Payment Report
2011-07-15 12:53xabiermerinoOBNetwork customer => Yes
2011-07-15 12:53xabiermerinoSupport ticket => 12125
2011-07-15 12:53xabiermerinoResolution time => 1313618400
2011-07-15 13:02xabiermerinoIssue Monitored: networkb
2011-07-15 13:29xabiermerinoRelationship addedrelated to 0017568
2011-07-20 18:08dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-08-02 18:01jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2011-08-04 10:53ioritzCiaStatusnew => scheduled
2011-08-04 10:53ioritzCiafix_in_branch => pi
2011-08-10 12:27hgbotCheckin
2011-08-10 12:27hgbotNote Added: 0040069
2011-08-10 12:27hgbotStatusscheduled => resolved
2011-08-10 12:27hgbotResolutionopen => fixed
2011-08-10 12:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0d9d11f4ab722ea1e1ac8e7ff8bcd69aa7d6c12f [^]
2011-08-11 09:40hgbotCheckin
2011-08-11 09:40hgbotNote Added: 0040104
2011-08-11 09:40hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/0d9d11f4ab722ea1e1ac8e7ff8bcd69aa7d6c12f [^] => http://code.openbravo.com/erp/mods/org.openbravo.financial.paymentreport/rev/11f1d46a4ebb0ab35291968ef6d8e2cf0db2eaf1 [^]
2011-08-11 09:43ioritzCiaNote Added: 0040105
2011-08-11 09:43ioritzCiaStatusresolved => new
2011-08-11 09:43ioritzCiaResolutionfixed => open
2011-08-11 09:43ioritzCiaStatusnew => scheduled
2011-08-11 09:44ioritzCiaStatusscheduled => resolved
2011-08-11 09:44ioritzCiaFixed in SCM revisionhttp://code.openbravo.com/erp/mods/org.openbravo.financial.paymentreport/rev/11f1d46a4ebb0ab35291968ef6d8e2cf0db2eaf1 [^] => http://code.openbravo.com/erp/devel/pi/rev/0d9d11f4ab722ea1e1ac8e7ff8bcd69aa7d6c12f [^]
2011-08-11 09:44ioritzCiaResolutionopen => fixed
2011-08-16 13:24hudsonbotCheckin
2011-08-16 13:24hudsonbotNote Added: 0040214
2011-08-17 09:38xabiermerinoNote Added: 0040243
2011-08-17 09:38xabiermerinoStatusresolved => closed

Notes
(0040069)
hgbot   
2011-08-10 12:27   
Repository: erp/devel/pi
Changeset: 0d9d11f4ab722ea1e1ac8e7ff8bcd69aa7d6c12f
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Aug 10 11:48:32 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0d9d11f4ab722ea1e1ac8e7ff8bcd69aa7d6c12f [^]

Fixes issue 17995: The Payment Report does not filter properly by Due Date.

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0040104)
hgbot   
2011-08-11 09:40   
Repository: erp/mods/org.openbravo.financial.paymentreport
Changeset: 11f1d46a4ebb0ab35291968ef6d8e2cf0db2eaf1
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Aug 11 09:15:54 2011 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.financial.paymentreport/rev/11f1d46a4ebb0ab35291968ef6d8e2cf0db2eaf1 [^]

Fixes issue 17995: The Payment Report does not filter properly by Due Date.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0040105)
ioritzCia   
2011-08-11 09:43   
The second changeset is for the backport 18193.
(0040214)
hudsonbot   
2011-08-16 13:24   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c1dc221b8cb3 [^]

Maturity status: Test
(0040243)
xabiermerino   
2011-08-17 09:38   
verified