Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012334Openbravo ERP09. Financial managementpublic2010-02-18 11:352010-03-12 22:40
Reporternetworkb 
Assigned Tosathiyan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version2.50MP14 
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
Summary0012334: General Ledger report shown an uncorrect "SALDO" when an organization is selected
DescriptionIf an organization diferent from *, is selected in the filter, always shows 0 in SALDO field.
However, if * is selected, it shows correctly SALDO.
Steps To ReproduceGo 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-18 11:35networkbNew Issue
2010-02-18 11:35networkbAssigned To => dalsasua
2010-02-18 11:35networkbOBNetwork customer => Yes
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 [^]