Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019979Openbravo ERP09. Financial managementpublic2012-03-07 18:402012-04-01 20:39
Reportermalsasua 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
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
Summary0019979: in general ledger report, the balance is wrong calculated
Descriptionin html format, the balance is wrong calculated, when page previous exists.
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: void
 . to account: void
 . group by: business partner
 
run report:
the third page (you should click twice in right row )
Business Partner:
Account No.: 10000 Name: Reservas para acciones o participaciones de... DATE DEBIT CREDIT BALANCE DESCRIPTION
PREVIOUS 300.00 0.00 300.00
10-02-2012 25.00 0.00 325.00 1007 # 10 (test)
11-02-2012 0.00 100.00 -75.00 1008 # 20 (test)
SUBTOTAL 325.00 100.00 -225.00
TOTAL 325.00 100.00 -225.00
and it should be
ccount No.: 10000 Name: Reservas para acciones o participaciones de... DATE DEBIT CREDIT BALANCE DESCRIPTION
PREVIOUS 300.00 0.00 300.00
10-02-2012 25.00 0.00 325.00 1007 # 10 (test)
11-02-2012 0.00 100.00 -225.00 1008 # 20 (test)
SUBTOTAL 325.00 100.00 -225.00
TOTAL 325.00 100.00 -225.00

I have attached 1 screenshots
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesjpg pantallazo.jpg (82,120) 2012-03-07 18:42
https://issues.openbravo.com/file_download.php?file_id=5068&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2012-03-07 18:40malsasuaNew Issue
2012-03-07 18:40malsasuaAssigned To => vmromanos
2012-03-07 18:40malsasuaWeb browser => Google Chrome
2012-03-07 18:40malsasuaModules => Core
2012-03-07 18:40malsasuaIssue Monitored: networkb
2012-03-07 18:42malsasuaFile Added: pantallazo.jpg
2012-03-09 10:55vmromanosStatusnew => scheduled
2012-03-09 10:55vmromanosfix_in_branch => pi
2012-03-12 09:12vmromanosNote Added: 0046241
2012-03-12 09:15hgbotCheckin
2012-03-12 09:15hgbotNote Added: 0046242
2012-03-12 09:15hgbotStatusscheduled => resolved
2012-03-12 09:15hgbotResolutionopen => fixed
2012-03-12 09:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f1b052808dd33de2f628cfd3fbde8961b2b193ff [^]
2012-03-21 17:52eduardo_ArgalNote Added: 0046610
2012-03-21 17:52eduardo_ArgalStatusresolved => closed
2012-04-01 20:39hudsonbotCheckin
2012-04-01 20:39hudsonbotNote Added: 0047080

Notes
(0046241)
vmromanos   
2012-03-12 09:12   
No regression risk:

Test plan I:
1. Follow steps to reproduce and check the bug is not reproducible anymore

Test plan II:
1. Launch the HTML report without selecting any Group By criteria. Ensure the data is the same we had before the fix.

Test plan III:
1. Repeat test plan II for different filters: dates, amounts, etc.
(0046242)
hgbot   
2012-03-12 09:15   
Repository: erp/devel/pi
Changeset: f1b052808dd33de2f628cfd3fbde8961b2b193ff
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Mar 12 09:15:01 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f1b052808dd33de2f628cfd3fbde8961b2b193ff [^]

Fixed bug 19979: wrong balance in general ledger report
The sum of the accumulated balance is not added for each row

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
---
(0046610)
eduardo_Argal   
2012-03-21 17:52   
Tested and working
(0047080)
hudsonbot   
2012-04-01 20:39   
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