Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019631Openbravo ERP09. Financial managementpublic2012-02-02 13:022012-03-02 15:34
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019631: Payment report is not working when filtering by dates
DescriptionPayment report crashes when filtering by dates.
Steps To ReproduceOpen payment report.
Enter date filters such as due date from, and run it
Mind that report launches an error:
    
Error: Error
org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [] [select fpsd.id, (select a.sequenceNumber from ADList a where a.reference.id = '575BCB88A4694C27BC013DE9C73E6FE7' and a.searchKey = coalesce(pay.status, 'RPAP')) as a from FIN_Payment_ScheduleDetail as fpsd left outer join fpsd.paymentDetails.finPayment pay left outer join pay.businessPartner paybp left outer join paybp.businessPartnerCategory paybpc left outer join fpsd.invoicePaymentSchedule invps left outer join invps.invoice inv left outer join inv.businessPartner invbp left outer join invbp.businessPartnerCategory invbpc left outer join fpsd.paymentDetails.finPayment.currency paycur left outer join fpsd.invoicePaymentSchedule.invoice.currency invcur left outer join pay.project paypro left outer join inv.project invpro where (fpsd.paymentDetails is not null or invps is not null ) and fpsd.organization.id in ('4F68EB1C1B734E79B27DE9D2DF56089F', '0', '0D8E225ADA6E425E98EAA0F34E5912D7', 'B9C7088AB859483A9B1FB342AC2BE17A', '90A1F59849E84AFABD04814B3D15A691', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and invps.dueDate >= ? and invps.dueDate <= ? order by a, coalesce(pay.status, 'RPAP'), fpsd.invoicePaymentSchedule.id]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-02 13:02eduardo_ArgalNew Issue
2012-02-02 13:02eduardo_ArgalAssigned To => jonalegriaesarte
2012-02-02 13:02eduardo_ArgalModules => Core
2012-02-02 13:04eduardo_ArgalStatusnew => scheduled
2012-02-02 13:04eduardo_ArgalAssigned Tojonalegriaesarte => eduardo_Argal
2012-02-02 13:04eduardo_Argalfix_in_branch => pi
2012-02-02 13:07hgbotCheckin
2012-02-02 13:07hgbotNote Added: 0044807
2012-02-02 13:07hgbotStatusscheduled => resolved
2012-02-02 13:07hgbotResolutionopen => fixed
2012-02-02 13:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f757e34def526858225b3229f1c83b3b4fa909ce [^]
2012-02-02 17:08psarobeNote Added: 0044825
2012-02-02 17:08psarobeStatusresolved => closed
2012-02-02 17:08psarobeFixed in Version => pi
2012-03-02 15:34hudsonbotCheckin
2012-03-02 15:34hudsonbotNote Added: 0045731

Notes
(0044807)
hgbot   
2012-02-02 13:07   
Repository: erp/devel/pi
Changeset: f757e34def526858225b3229f1c83b3b4fa909ce
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Feb 02 13:04:52 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f757e34def526858225b3229f1c83b3b4fa909ce [^]

Fixes bug 19631: Payment report is not working when filtering by dates

---
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportDao.java
---
(0044825)
psarobe   
2012-02-02 17:08   
Fix correct. Now works fine
(0045731)
hudsonbot   
2012-03-02 15:34   
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/544d64e0c159 [^]

Maturity status: Test