Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012334Openbravo ERP09. Financial managementpublic2010-02-18 11:352010-03-12 22:40
networkb 
sathiyan 
urgentmajoralways
closedfixed 
5
2.50MP11 
2.50MP142.50MP14 
Core
No
0012334: General Ledger report shown an uncorrect "SALDO" when an organization is selected
If an organization diferent from *, is selected in the filter, always shows 0 in SALDO field.
However, if * is selected, it shows correctly SALDO.
Go to Financial Management > Accounting > Analysis Tools > General Ledger Report.
Search from 01-03-2006 to 01-01-2010.
Select Main, and Smallbazaar USA/Eur.
From Account, 572 (if Spanish COA) to account 572.
See that there is transactions in April.
Modify From date, 01-08-2006.
SALDO shows 0, although there are previous transactions.
No tags attached.
Issue History
2010-02-18 11:35networkbNew Issue
2010-02-18 11:35networkbAssigned To => dalsasua
2010-02-18 17:09dalsasuaStatusnew => scheduled
2010-02-18 17:09dalsasuaNote Added: 0024605
2010-02-18 17:09dalsasuafix_in_branch => pi
2010-02-18 17:27dalsasuaNote Added: 0024607
2010-02-26 08:35dalsasuaAssigned Todalsasua => sathiyan
2010-03-01 10:12hgbotCheckin
2010-03-01 10:12hgbotNote Added: 0024891
2010-03-01 10:12hgbotStatusscheduled => resolved
2010-03-01 10:12hgbotResolutionopen => fixed
2010-03-01 10:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/39934462fbecab0dad4010470a3dfbfb6dee4593 [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-09 09:23arunkumarNote Added: 0025165
2010-03-09 09:23arunkumarStatusresolved => closed
2010-03-09 09:23arunkumarFixed in Version => 2.50MP13
2010-03-10 17:24anonymoussf_bug_id0 =>
2010-03-10 18:30anonymoussf_bug_id => 2968086
2010-03-11 10:29jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-12 22:40hudsonbotCheckin
2010-03-12 22:40hudsonbotNote Added: 0025362

Notes
(0024605)
dalsasua   
2010-02-18 17:09   
Furthermore, * shouldn't be an available organization for this report.
(0024607)
dalsasua   
2010-02-18 17:27   
It seems that in ReportGeneralLedger.java, line 240 says
String strOrgFamily = getFamily(strTreeOrg, strOrg);
getFamily is retrieving organizations from
return Tree.getMembers(this, strTree, strChild);
and it seems that Tree.getMembers with strChild=MainOrgId is returning a set of organizations where MainOrgId is not present... ¿?¿?
(0024891)
hgbot   
2010-03-01 10:12   
Repository: erp/devel/pi
Changeset: 39934462fbecab0dad4010470a3dfbfb6dee4593
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Mon Mar 01 14:46:02 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/39934462fbecab0dad4010470a3dfbfb6dee4593 [^]

Fixes Issue 12334: General Ledger report shown an uncorrect SALDO

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0025165)
arunkumar   
2010-03-09 09:23   
Tested & working fine.
(0025362)
hudsonbot   
2010-03-12 22:40   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/39934462fbec [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]