Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0019903Openbravo ERP09. Financial managementpublic2012-02-13 17:562012-03-07 18:56
malsasua 
jecharri 
normalmajoralways
closedfixed 
20Community Appliance
2.50MP39 
2.50MP402.50MP40 
Google Chrome
Core
No
0019903: in general ledger report, the subtotals are not transported correctly
In general ledger report, in html format, the subtotal is not transported from the page to the next page, when the business partner is void.
. create new g/l journal:
 schema: F&B International Group US/A/Euro
 accounting date: 10/02/2012
 new line:
   accounting combination 0-11400
   debit 300
 new line:
   accounting combination 0-10000
   credit 300
 process and post

. create new g/l journal:
 schema: F&B International Group US/A/Euro
 accounting date: 11/02/2012
 new line:
   accounting combination 0-11400
   debit 25
 new line:
   accounting combination 0-10000
   credit 25
 process and post


. create new g/l journal:
 schema: F&B International Group US/A/Euro
 accounting date: 13/02/2012
 new line:
   accounting combination 0-10000
   debit 100
 new line:
   accounting combination 0-11400
   credit 100
 process and post


. go to session preferences window:
 . records range: 2

. go to general ledger report:
 . date from: 01/01/2012
 . date to: 31/12/2012
 . organization: *
 . accounting schema: F&B International Group US/A/Euro
 . from account: capital social
 . to account: capital social
 . group by: business partner
 
run report:
Business Partner:
Account No.: 10000 Name: Capital social
DATE DEBIT CREDIT BALANCE DESCRIPTION
PREVIOUS 0.00 0.00 0.00
10-02-2012 0.00 300.00 -300.00 1008 # 10 (test)
11-02-2012 0.00 25.00 -325.00 1009 # 10 (test)
SUBTOTAL 0.00 325.00 -325.00
TOTAL 0.00 0.00 0.00
 
. click in arrow button to go to the next page
Business Partner:
Account No.: 10000 Name: Capital social
DATE DEBIT CREDIT BALANCE DESCRIPTION
PREVIOUS 0.00 0.00 0.00
13-02-2012 100.00 0.00 100.00 1007 # 10 (test)
SUBTOTAL 100.00 0.00 100.00
TOTAL 0.00 0.00 0.00

I have attached 2 screenshots
    
No tags attached.
blocks defect 00197503.0MP10 closed jecharri in general ledger report, the subtotals are not transported correctly 
Issue History
2012-02-28 13:46malsasuaTypedefect => backport
2012-02-28 13:46malsasuafix_in_branch => 2.50
2012-02-29 10:19jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2012-02-29 10:19jonalegriaesarteversion => 2.50MP39
2012-02-29 10:19jonalegriaesarteTarget Version3.0MP9 => 2.50MP40
2012-03-05 17:36jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-03-07 17:35hgbotCheckin
2012-03-07 17:35hgbotNote Added: 0046145
2012-03-07 17:35hgbotStatusscheduled => resolved
2012-03-07 17:35hgbotResolutionopen => fixed
2012-03-07 17:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/6168cd048961222b165b6eb6863f2de0ef1a553e [^]
2012-03-07 17:35jecharriNote Added: 0046146
2012-03-07 18:56dalsasuaNote Added: 0046154
2012-03-07 18:56dalsasuaStatusresolved => closed
2012-03-07 18:56dalsasuaFixed in Version => 2.50MP40

Notes
(0046145)
hgbot   
2012-03-07 17:35   
Repository: erp/stable/2.50
Changeset: 6168cd048961222b165b6eb6863f2de0ef1a553e
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 07 17:35:12 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/6168cd048961222b165b6eb6863f2de0ef1a553e [^]

Fixes issue 19903: in general ledger report,
the subtotals are not transported correctly.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0046146)
jecharri   
2012-03-07 17:35   
Test Cases:

-reproduce the steps to reproduce.
-reproduce the steps to reproduce without any Group by.
-reproduce the first steps to reproduce and execute the report with:
  +group by BP and select cero or more BP
  +group by Product and select cero or more Product
  +group by Project and select cero or more Project
(0046154)
dalsasua   
2012-03-07 18:56   
Code reviewed