0019631: Payment report is not working when filtering by dates

Description

Payment report crashes when filtering by dates.

Steps To Reproduce

Open 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]

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0044807) hgbot (developer) 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 (manager) 2012-02-02 17:08	Fix correct. Now works fine

(0045731) hudsonbot (developer) 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

Issue History
Date Modified	Username	Field	Change
2012-02-02 13:02	eduardo_Argal	New Issue
2012-02-02 13:02	eduardo_Argal	Assigned To	=> jonalegriaesarte
2012-02-02 13:02	eduardo_Argal	Modules	=> Core
2012-02-02 13:04	eduardo_Argal	Status	new => scheduled
2012-02-02 13:04	eduardo_Argal	Assigned To	jonalegriaesarte => eduardo_Argal
2012-02-02 13:04	eduardo_Argal	fix_in_branch	=> pi
2012-02-02 13:07	hgbot	Checkin
2012-02-02 13:07	hgbot	Note Added: 0044807
2012-02-02 13:07	hgbot	Status	scheduled => resolved
2012-02-02 13:07	hgbot	Resolution	open => fixed
2012-02-02 13:07	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/f757e34def526858225b3229f1c83b3b4fa909ce [^]
2012-02-02 17:08	psarobe	Note Added: 0044825
2012-02-02 17:08	psarobe	Status	resolved => closed
2012-02-02 17:08	psarobe	Fixed in Version	=> pi
2012-03-02 15:34	hudsonbot	Checkin
2012-03-02 15:34	hudsonbot	Note Added: 0045731