Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010409
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-08-26 13:142009-10-06 11:23
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP6
StatusclosedFix in branchFixed in SCM revision6f9b318e1483
ProjectionnoneETAnoneTarget Version2.50MP6
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010409: 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,
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

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

 David,

Can you please comment on this issue?

Thanks.
(0019294)
rafaroda (viewer)
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 (viewer)
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 (viewer)
2009-09-03 15:27

 The proposed solution has been tested for the partner, and it is correct
(0020075)
rafaroda (viewer)
2009-09-15 16:22

 Priority upgraded to Immediate since 2.50 MP6 freezing is happening on Friday 18/09.
(0020083)
hgbot (developer)
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 (developer)
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 (viewer)
2009-09-21 13:38

 With those steps and description is impossible to verify the bug
(0020464)
hgbot (developer)
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 (developer)
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 (viewer)
2009-10-06 11:23

 Closed again because hudson has reopened without no reason

- Issue History
Date Modified Username Field Change
2009-08-26 13:14 networkb New Issue
2009-08-26 13:14 networkb Assigned To => rafaroda
2009-08-26 13:14 networkb OBNetwork customer => Yes
2009-08-26 13:19 rafaroda Note Added: 0019235
2009-08-26 13:19 rafaroda Assigned To rafaroda => dalsasua
2009-08-26 13:19 rafaroda Status new => acknowledged
2009-08-31 08:03 rafaroda Note Added: 0019294
2009-09-01 08:19 dalsasua Note Added: 0019359
2009-09-01 08:20 dalsasua Status acknowledged => scheduled
2009-09-01 08:20 dalsasua fix_in_branch => pi
2009-09-01 09:14 nsaleh Issue Monitored: nsaleh
2009-09-01 09:22 rafaroda Priority immediate => urgent
2009-09-01 09:22 rafaroda fix_in_branch pi =>
2009-09-03 15:27 networkb Note Added: 0019451
2009-09-03 16:53 networkb Target Version 2.50MP5 => 2.50MP6
2009-09-15 16:19 rafaroda Priority urgent => immediate
2009-09-15 16:22 rafaroda Note Added: 0020075
2009-09-15 17:54 hgbot Checkin
2009-09-15 17:54 hgbot Note Added: 0020083
2009-09-15 17:54 hgbot Status scheduled => resolved
2009-09-15 17:54 hgbot Resolution open => fixed
2009-09-15 17:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]
2009-09-15 18:24 hgbot Checkin
2009-09-15 18:24 hgbot Note Added: 0020085
2009-09-15 18:24 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^] => http://code.openbravo.com/erp/devel/pi/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]
2009-09-21 13:38 psarobe Status resolved => closed
2009-09-21 13:38 psarobe Note Added: 0020241
2009-09-21 13:38 psarobe Fixed in Version => 2.50MP6
2009-09-22 00:00 anonymous sf_bug_id 0 => 2863839
2009-09-29 14:11 hgbot Checkin
2009-09-29 14:11 hgbot Note Added: 0020464
2009-09-29 14:11 hgbot Status closed => resolved
2009-09-29 14:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^]
2009-09-29 14:11 hgbot Checkin
2009-09-29 14:11 hgbot Note Added: 0020466
2009-09-29 14:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/983cbb91ddd9c2bc313ba442fd01cfdf8c4367c0 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/6f9b318e148308f40c4286960431061ed7bc3c22 [^]
2009-10-06 11:23 psarobe Status resolved => closed
2009-10-06 11:23 psarobe Note Added: 0020754

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker