Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011689Openbravo ERP09. Financial managementpublic2009-12-09 07:462010-04-16 00:00
vanphuc 
mirurita 
urgentmajoralways
closedfixed 
20Community Appliance
2.50MP5 
2.50MP12pi 
Core
No
0011689: Error in Trial Balance Report
First of all, I check account 17000 in General Ledger Reports
Time filter from 01-12-2003 to 31-12-2009
I saw that system have already some transactions in Jan, Feb, March, …. of 2006
Then, I checked again with trial balance report. Date filter from 01-03-2006 to 31-12-2009
I thought that it must exist one Initial balance value. But, the report, this account obtains 0 at Initial Balance. Please check again this report on the demo database
No tags attached.
related to backport 00135642.40MP13 closed balamurugan Error in Trial Balance Report 
related to defect 00134902.40MP13 closed dalsasua Error in Trial Balance Report 
docx Error in Trial Balance Report.docx (416,529) 2009-12-09 07:46
https://issues.openbravo.com/file_download.php?file_id=2037&type=bug
png trial1.PNG (65,793) 2010-01-14 21:19
https://issues.openbravo.com/file_download.php?file_id=2130&type=bug
png

png trial2.PNG (57,945) 2010-01-14 21:19
https://issues.openbravo.com/file_download.php?file_id=2131&type=bug
png

png trial3.PNG (19,588) 2010-01-14 21:19
https://issues.openbravo.com/file_download.php?file_id=2132&type=bug
png
Issue History
2009-12-09 07:46vanphucNew Issue
2009-12-09 07:46vanphucAssigned To => rafaroda
2009-12-09 07:46vanphucFile Added: Error in Trial Balance Report.docx
2010-01-14 21:15carboneteIssue Monitored: carbonete
2010-01-14 21:18carboneteNote Added: 0023459
2010-01-14 21:19carboneteFile Added: trial1.PNG
2010-01-14 21:19carboneteFile Added: trial2.PNG
2010-01-14 21:19carboneteFile Added: trial3.PNG
2010-01-21 17:30psarobeAssigned Torafaroda => eduardo_Argal
2010-01-21 17:30psarobeSeveritycritical => major
2010-01-21 17:30psarobeStatusnew => feedback
2010-01-22 11:23eduardo_ArgalNote Added: 0023737
2010-01-22 11:34eduardo_ArgalNote Added: 0023738
2010-01-22 12:25eduardo_ArgalNote Added: 0023740
2010-01-22 14:00carboneteNote Added: 0023744
2010-01-25 13:38psarobeStatusfeedback => scheduled
2010-01-25 13:38psarobeTarget Version => 2.50MP12
2010-01-25 13:39psarobePrioritynormal => urgent
2010-01-25 18:15eduardo_ArgalNote Added: 0023795
2010-03-15 12:01miruritaAssigned Toeduardo_Argal => mirurita
2010-03-15 12:02miruritaNote Added: 0025469
2010-03-15 12:02miruritaStatusscheduled => resolved
2010-03-15 12:02miruritaFixed in Version => pi
2010-03-15 12:02miruritaFixed in SCM revision => c72b2f028c8f
2010-03-15 12:02miruritaResolutionopen => fixed
2010-04-15 14:53psarobeStatusresolved => closed
2010-04-16 00:00anonymoussf_bug_id0 => 2987949
2010-06-07 16:51adrianromeroRelationship addedrelated to 0013564
2010-06-07 16:55adrianromeroRelationship addedrelated to 0013490

Notes
(0023459)
carbonete   
2010-01-14 21:18   
I´m have same problem , my version are 2.50 MP8.
I´m input data from january to october, making a g/l journal with inital balance in january 1, when i get report using from date equal a january 1 , run ok , but with any other period initial balance is zero. Attached Images demonstrating problem.
(0023737)
eduardo_Argal   
2010-01-22 11:23   
Hi all,

There is an on going project to enhance accounting reports so any feedback we could get from you will be take into account for new report layout.
Once we have a project registered in the wiki for this report i will add a note so that any of you can give his/her insight.

Regards

Eduardo Argal
(0023738)
eduardo_Argal   
2010-01-22 11:34   
Hi all,

The project is:
http://wiki.openbravo.com/wiki/Projects/Financial_Reports_Review [^]

Any feedback will be welcome


Regards

Eduardo Argal
(0023740)
eduardo_Argal   
2010-01-22 12:25   
Hi all,

We had a look at the issue. It seems initial balance is just taking into account opening entries. Thats the reason why when you filter from march to June (as an example) you do not get any info in initial balance. We will take this into account for future version of the report we are about to launch. Again any additional feedback is really welcome as we are trying to redesign it.

Regards

Eduardo Argal
(0023744)
carbonete   
2010-01-22 14:00   
Hi Eduardo, I think this a functional bug not a enhancement. For end user it´s not time to wait future revised version, because he have an audit and don´t demonstrate correct report. This issue continue like a defect ??

thanks for attention
(0023795)
eduardo_Argal   
2010-01-25 18:15   
Hi Carbonete,

I completely agree.

I think my statement has been misunderstood. I meant that we would take this bug into account in the new report. This new report will be an enhanced trial balance.

Sorry for the inconvenience

Eduardo Argal
(0025469)
mirurita   
2010-03-15 12:02   
Fixed on revision 6705:c72b2f028c8f [1]

More information [2]

[1] https://code.openbravo.com/erp/devel/pi/rev/c72b2f028c8f [^]
[2] http://wiki.openbravo.com/wiki/Projects/Financial_Reports_Review/Trial_balance_report [^]