Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010409Openbravo ERP09. Financial managementpublic2009-08-26 13:142009-10-06 11:23
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target Version2.50MP6Fixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010409: Trial Balance does not show all accounts
DescriptionThis reports does not work properly because the recursive method that calculates accounting tree (AppsOpenbravo/src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java -> calculateTree), does not scan all accounting tree.

As a result, before executing this method, only few accounts are shown in the report.
Steps To ReproduceIt is really important, to not use Spanish csv or other done by Openbravo team for accounting tree.

Go to Financial Management > Accounting > Analysis tools > Trial Balance.
Execute it. It does not show all accounting entries (notice that those with amount, 0 must not appear).



Proposed SolutionIn ReportTrialBalance.java, calculateTree method, comment:

} //else if (encontrado)
        //break;

In ReportTrialBalance_data.xsql, select method:

SELECT MAX(PARENT_ID) AS PARENT_ID,
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-26 13:14networkbNew Issue
2009-08-26 13:14networkbAssigned To => rafaroda
2009-08-26 13:19rafarodaNote Added: 0019235
2009-08-26 13:19rafarodaAssigned Torafaroda => dalsasua
2009-08-26 13:19rafarodaStatusnew => acknowledged
2009-08-31 08:03rafarodaNote Added: 0019294
2009-09-01 08:19dalsasuaNote Added: 0019359
2009-09-01 08:20dalsasuaStatusacknowledged => scheduled
2009-09-01 08:20dalsasuafix_in_branch => pi
2009-09-01 09:14nsalehIssue Monitored: nsaleh
2009-09-01 09:22rafarodaPriorityimmediate => urgent
2009-09-01 09:22rafarodafix_in_branchpi =>
2009-09-03 15:27networkbNote Added: 0019451
2009-09-03 16:53networkbTarget Version2.50MP5 => 2.50MP6
2009-09-15 16:19rafarodaPriorityurgent => immediate
2009-09-15 16:22rafarodaNote Added: 0020075
2009-09-15 17:54hgbotCheckin
2009-09-15 17:54hgbotNote Added: 0020083
2009-09-15 17:54hgbotStatusscheduled => resolved
2009-09-15 17:54hgbotResolutionopen => fixed
2009-09-15 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]
2009-09-15 18:24hgbotCheckin
2009-09-15 18:24hgbotNote Added: 0020085
2009-09-15 18:24hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^] => http://code.openbravo.com/erp/devel/pi/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]
2009-09-21 13:38psarobeStatusresolved => closed
2009-09-21 13:38psarobeNote Added: 0020241
2009-09-21 13:38psarobeFixed in Version => 2.50MP6
2009-09-22 00:00anonymoussf_bug_id0 => 2863839
2009-09-29 14:11hgbotCheckin
2009-09-29 14:11hgbotNote Added: 0020464
2009-09-29 14:11hgbotStatusclosed => resolved
2009-09-29 14:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]
2009-09-29 14:11hgbotCheckin
2009-09-29 14:11hgbotNote Added: 0020466
2009-09-29 14:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]
2009-10-06 11:23psarobeStatusresolved => closed
2009-10-06 11:23psarobeNote Added: 0020754

Notes
(0019235)
rafaroda   
2009-08-26 13:19   
David,

Can you please comment on this issue?

Thanks.
(0019294)
rafaroda   
2009-08-31 08:03   
Reminder sent to: dalsasua

Hi David,

This seems a very important issue. Can you please provide feedback on it?

Thanks.
(0019359)
dalsasua   
2009-09-01 08:19   
Hi Rafa,

I'm back from vacations, and start today to have a look to this issue.

Regards.
(0019451)
networkb   
2009-09-03 15:27   
The proposed solution has been tested for the partner, and it is correct
(0020075)
rafaroda   
2009-09-15 16:22   
Priority upgraded to Immediate since 2.50 MP6 freezing is happening on Friday 18/09.
(0020083)
hgbot   
2009-09-15 17:54   
Repository: erp/devel/pi
Changeset: 983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Sep 15 17:54:37 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]

Fixes issue 10409: Trial Balance does not show all accounts

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0020085)
hgbot   
2009-09-15 18:24   
Repository: erp/devel/pi
Changeset: 6f9b318e148308f40c4286960431061ed7bc3c22
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Sep 15 18:24:26 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]

Fixes issue 10409: Trial Balance does not show all accounts

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0020241)
psarobe   
2009-09-21 13:38   
With those steps and description is impossible to verify the bug
(0020464)
hgbot   
2009-09-29 14:11   
Repository: erp/devel/pi-pageddatagrid
Changeset: 983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Sep 15 17:54:37 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]

Fixes issue 10409: Trial Balance does not show all accounts

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0020466)
hgbot   
2009-09-29 14:11   
Repository: erp/devel/pi-pageddatagrid
Changeset: 6f9b318e148308f40c4286960431061ed7bc3c22
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Sep 15 18:24:26 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]

Fixes issue 10409: Trial Balance does not show all accounts

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0020754)
psarobe   
2009-10-06 11:23   
Closed again because hudson has reopened without no reason