Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019903Openbravo ERP09. Financial managementpublic2012-02-13 17:562012-03-07 18:56
Reportermalsasua 
Assigned Tojecharri 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP39 
Target Version2.50MP40Fixed in Version2.50MP40 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket14217
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019903: in general ledger report, the subtotals are not transported correctly
DescriptionIn general ledger report, in html format, the subtotal is not transported from the page to the next page, when the business partner is void.
Steps To Reproduce. 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
    
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00197503.0MP10 closed jecharri in general ledger report, the subtotals are not transported correctly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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