Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011200Openbravo ERP09. Financial managementpublic2009-10-30 18:432009-11-06 00:00
networkb 
vmromanos 
urgentmajoralways
closedfixed 
5
2.40MP10 
2.40MP112.50MP9 
Core
No
0011200: ReportBankJR doesn't group data properly
If you have two bankstatements with different name but with same statementdate they are not properly grouped, because lines of same bankstatement are not grouped.

In an application with BigBazaar data:

1. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : search for bankstatement with name "18-10-2006"
2. Modify the name of the bankstatement with ending balance=241.41
3. Check that it has 4 lines
4. Execute Financial Management || Receivables & Payables || Analysis Tools || Bank Report || Bank Report with dates= 18-10-2006
5. Check that lines from same bankstatement are not grouped
No tags attached.
depends on backport 00112242.40MP11 closed vmromanos ReportBankJR doesn't group data properly 
png bankreport18.png (83,301) 2009-10-30 18:43
https://issues.openbravo.com/file_download.php?file_id=1905&type=bug
png
Issue History
2009-10-30 18:43networkbNew Issue
2009-10-30 18:43networkbAssigned To => rafaroda
2009-10-30 18:43networkbFile Added: bankreport18.png
2009-11-02 06:04rafarodaNote Added: 0021498
2009-11-02 06:04rafarodaAssigned Torafaroda => dalsasua
2009-11-02 06:04rafarodaStatusnew => acknowledged
2009-11-02 17:00vmromanosNote Added: 0021515
2009-11-03 08:25rafarodaAssigned Todalsasua => vmromanos
2009-11-03 08:25rafarodaPriorityimmediate => urgent
2009-11-03 08:25rafarodaStatusacknowledged => scheduled
2009-11-03 08:25rafarodaStatusscheduled => feedback
2009-11-03 08:25rafarodaStatusfeedback => scheduled
2009-11-03 08:25rafarodafix_in_branch => pi
2009-11-03 13:59hgbotCheckin
2009-11-03 13:59hgbotNote Added: 0021534
2009-11-03 13:59hgbotStatusscheduled => resolved
2009-11-03 13:59hgbotResolutionopen => fixed
2009-11-03 13:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0eecec749cf4d1f974d7fa41cc534ba0f84861e [^]
2009-11-05 09:36arunkumarStatusresolved => closed
2009-11-05 09:36arunkumarNote Added: 0021583
2009-11-05 09:36arunkumarFixed in Version => 2.50MP9
2009-11-06 00:00anonymoussf_bug_id0 => 2892915

Notes
(0021498)
rafaroda   
2009-11-02 06:04   
David,

Can you please comment on this issue?

Thanks.
(0021515)
vmromanos   
2009-11-02 17:00   
Rafa,
David is on holidays...

The issue is a bug: the bank statement lines should be grouped.
(0021534)
hgbot   
2009-11-03 13:59   
Repository: erp/devel/pi
Changeset: e0eecec749cf4d1f974d7fa41cc534ba0f84861e
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Nov 03 14:00:56 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e0eecec749cf4d1f974d7fa41cc534ba0f84861e [^]

Fixed bug 11200: ReportBankJR does not group data properly

---
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR_data.xsql
---
(0021583)
arunkumar   
2009-11-05 09:36   
Tested & Working fine.