Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0019631 | Openbravo ERP | 09. Financial management | public | 2012-02-02 13:02 | 2012-03-02 15:34 |
| Reporter | eduardo_Argal | ||||
| Assigned To | eduardo_Argal | ||||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | pi | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 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] | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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:02 | eduardo_Argal | OBNetwork customer | => No | ||
| 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 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||