Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019750Openbravo ERP09. Financial managementpublic2012-02-13 17:562012-04-01 20:38
Reportermalsasua 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target Version3.0MP10Fixed in Version3.0MP10 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019750: 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
depends on backport 00199032.50MP40 closed jecharri in general ledger report, the subtotals are not transported correctly 
Attached Filesjpg pantallazo1.jpg (75,087) 2012-02-13 17:59
https://issues.openbravo.com/file_download.php?file_id=4993&type=bug
jpg

jpg pantallazo2.jpg (77,053) 2012-02-13 17:59
https://issues.openbravo.com/file_download.php?file_id=4994&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2012-02-13 17:56malsasuaNew Issue
2012-02-13 17:56malsasuaAssigned To => jonalegriaesarte
2012-02-13 17:56malsasuaWeb browser => Google Chrome
2012-02-13 17:56malsasuaModules => Core
2012-02-13 17:56malsasuaResolution time => 1331679600
2012-02-13 17:59malsasuaFile Added: pantallazo1.jpg
2012-02-13 17:59malsasuaFile Added: pantallazo2.jpg
2012-02-13 17:59malsasuaIssue Monitored: networkb
2012-02-28 13:46malsasuaStatusnew => scheduled
2012-02-28 13:46malsasuafix_in_branch => pi
2012-02-28 15:40malsasuaWeb browserGoogle Chrome => Google Chrome
2012-02-28 15:40malsasuaPrioritynormal => urgent
2012-02-28 15:40malsasuafix_in_branchpi =>
2012-02-29 11:40jonalegriaesarteWeb browserGoogle Chrome => Google Chrome
2012-02-29 11:40jonalegriaesarteNote Added: 0045575
2012-02-29 11:40jonalegriaesarteTarget Version3.0MP9 => 3.0MP10
2012-03-05 17:25jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-03-07 10:04hgbotCheckin
2012-03-07 10:04hgbotNote Added: 0046114
2012-03-07 10:04hgbotStatusscheduled => resolved
2012-03-07 10:04hgbotResolutionopen => fixed
2012-03-07 10:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/314b594fdc445c3af56bf9f08753c3f78dc31c8d [^]
2012-03-07 10:40jecharriNote Added: 0046116
2012-03-07 16:18hgbotCheckin
2012-03-07 16:18hgbotNote Added: 0046141
2012-03-07 18:47malsasuaNote Added: 0046151
2012-03-07 18:56dalsasuaNote Added: 0046155
2012-03-07 18:56dalsasuaStatusresolved => closed
2012-03-07 18:56dalsasuaFixed in Version => 3.0MP10
2012-04-01 20:37hudsonbotCheckin
2012-04-01 20:37hudsonbotNote Added: 0047052
2012-04-01 20:38hudsonbotCheckin
2012-04-01 20:38hudsonbotNote Added: 0047055

Notes
(0045575)
jonalegriaesarte   
2012-02-29 11:40   
Needs to be tested better, so moved to next MP.
(0046114)
hgbot   
2012-03-07 10:04   
Repository: erp/devel/pi
Changeset: 314b594fdc445c3af56bf9f08753c3f78dc31c8d
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 07 10:02:43 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/314b594fdc445c3af56bf9f08753c3f78dc31c8d [^]

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

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
---
(0046116)
jecharri   
2012-03-07 10:40   
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
(0046141)
hgbot   
2012-03-07 16:18   
Repository: erp/devel/pi
Changeset: b08eca418104f9b530f9d8f71c59e8fb96305b35
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 07 16:17:16 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b08eca418104f9b530f9d8f71c59e8fb96305b35 [^]

issue 19750: 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
---
(0046151)
malsasua   
2012-03-07 18:47   
close ticket:
version:3.0.15680
functionality:
 test plan:
  steps to reproduce -> ok
  check without group business partner -> ok
  check with group by product / project -> ok
(0046155)
dalsasua   
2012-03-07 18:56   
Code reviewed
(0047052)
hudsonbot   
2012-04-01 20:37   
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/640de9acc2d5 [^]

Maturity status: Test
(0047055)
hudsonbot   
2012-04-01 20:38   
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/640de9acc2d5 [^]

Maturity status: Test