Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014074Openbravo ERP09. Financial managementpublic2010-07-28 10:082010-09-13 12:38
Reporternetworkb 
Assigned Tosathiyan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP20 
Target Version2.50MP21Fixed in Version 
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
Summary0014074: Error with Opening entry in Trial Balance report
DescriptionInitial Balance quantities of used accounts are not correct when you try visualize the opening entry in Trial Balance Report
Steps To Reproduce1. Financial Management || Accounting || Transactions || G/L Journal || Batch: create new record for DocumentDate=01-01-2010
2. Go to Header and check "Opening" checkbox
3. Go to Lines and add lines for:
   a) AccountCombination= Main-67100-_-_-_ and Debit=200
   b) AccountCombination= Main-28290-_-_-_ and Credit=100
   c) AccountCombination= Main-28290-_-_-_ and Credit=100
4. Process and Post
5. Financial Management || Accounting || Analysis Tools || Trial Balance Report || Trial Balance Report: execute report for
   FromDate=01/01/2010
   ToDate=01/01/2010
   Org=Main
   AccSchema=SmallBazaar
   AccountLevel=Subaccount
   AccountFrom= 28290
   AccountTo=671

Initial Balance from Account 671 is correct (200 euros). But realize that Initial Balance for Account 28290 is NOT correct (it is 100 euros instead of 200 euro)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00131622.50MP18 closed sathiyan trial balance report is wrong if exist records of type "opening" similars 
related to backport 00158502.50MP28 closed jonalegriaesarte the XLS generated in report trial balance is not correct 
Attached Filespng 14074_part1.png (199,490) 2010-08-10 11:26
https://issues.openbravo.com/file_download.php?file_id=2832&type=bug
png

png 14074_part2.png (247,726) 2010-08-10 11:26
https://issues.openbravo.com/file_download.php?file_id=2833&type=bug
png

png trialbalance.png (219,482) 2010-08-11 11:50
https://issues.openbravo.com/file_download.php?file_id=2836&type=bug
png

png 14074_1.png (207,825) 2010-08-11 15:45
https://issues.openbravo.com/file_download.php?file_id=2837&type=bug
png

png 14074_2.png (194,764) 2010-08-11 15:45
https://issues.openbravo.com/file_download.php?file_id=2838&type=bug
png

png 14074_3.png (218,673) 2010-08-11 15:45
https://issues.openbravo.com/file_download.php?file_id=2839&type=bug
png

png 14704_4.png (237,187) 2010-08-11 15:45
https://issues.openbravo.com/file_download.php?file_id=2840&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-07-28 10:08networkbNew Issue
2010-07-28 10:08networkbAssigned To => dalsasua
2010-08-05 13:07vmromanosRelationship addedduplicate of 0013162
2010-08-05 13:08vmromanosAssigned Todalsasua => sathiyan
2010-08-05 13:09vmromanosNote Added: 0029826
2010-08-09 08:38vmromanosStatusnew => scheduled
2010-08-09 08:38vmromanosfix_in_branch => pi
2010-08-10 08:28sathiyanFile Added: 14074_part1.png
2010-08-10 08:28sathiyanFile Added: 14074_part2.png
2010-08-10 08:30sathiyanNote Added: 0029857
2010-08-10 08:31sathiyanAssigned Tosathiyan => vmromanos
2010-08-10 09:02vmromanosNote Added: 0029860
2010-08-10 09:03vmromanosAssigned Tovmromanos => sathiyan
2010-08-10 11:25sathiyanFile Deleted: 14074_part1.png
2010-08-10 11:25sathiyanFile Deleted: 14074_part2.png
2010-08-10 11:26sathiyanFile Added: 14074_part1.png
2010-08-10 11:26sathiyanFile Added: 14074_part2.png
2010-08-10 11:29sathiyanNote Added: 0029865
2010-08-10 11:29sathiyanAssigned Tosathiyan => networkb
2010-08-11 05:41sathiyanNote Added: 0029878
2010-08-11 05:41sathiyanStatusscheduled => feedback
2010-08-11 11:50networkbNote Added: 0029886
2010-08-11 11:50networkbStatusfeedback => new
2010-08-11 11:50networkbfix_in_branchpi =>
2010-08-11 11:50networkbFile Added: trialbalance.png
2010-08-11 15:45sathiyanFile Added: 14074_1.png
2010-08-11 15:45sathiyanFile Added: 14074_2.png
2010-08-11 15:45sathiyanFile Added: 14074_3.png
2010-08-11 15:45sathiyanFile Added: 14704_4.png
2010-08-11 15:47sathiyanNote Added: 0029893
2010-08-11 15:48sathiyanAssigned Tonetworkb => sathiyan
2010-08-11 15:48sathiyanAssigned Tosathiyan => networkb
2010-08-11 15:49sathiyanStatusnew => feedback
2010-08-11 16:05vmromanosAssigned Tonetworkb => sathiyan
2010-08-11 16:05vmromanosNote Added: 0029894
2010-08-11 16:12vmromanosStatusfeedback => new
2010-08-16 07:30hgbotCheckin
2010-08-16 07:30hgbotNote Added: 0029971
2010-08-16 07:30hgbotStatusnew => resolved
2010-08-16 07:30hgbotResolutionopen => fixed
2010-08-16 07:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2393661413dc171d25cbf2268bf0e1d4b7f2f39 [^]
2010-08-16 12:07hudsonbotCheckin
2010-08-16 12:07hudsonbotNote Added: 0030005
2010-08-20 12:59psarobeNote Added: 0030183
2010-08-20 12:59psarobeStatusresolved => closed
2010-09-13 12:38anonymoussf_bug_id0 => 3065162
2011-03-09 09:50dalsasuaRelationship addedrelated to 0015850

Notes
(0029826)
vmromanos   
2010-08-05 13:09   
Sathiyan,

It seems 0013162 wasn't properly fixed. Could you please check it? I'm able to reproduce it.
(0029857)
sathiyan   
2010-08-10 08:30   
Hello Victor,
I have attached screen shots. I am not able to reproduce as followed the same step as given. Could you give me the set of steps you have followed to reproduce.
Regards
Sathiyan.
(0029860)
vmromanos   
2010-08-10 09:02   
I'm able to reproduce it following the steps to reproduce of the bug.

I see in your screenshot you haven't specified the accounts from and to. Please follow the steps **exactly** as they are in the bug description.

If, after following them exactly, you can't reproduce it, you should start thinking of an environment issue, like for example the database used. In this case, please mark the bug as "in feedback" and ask the reporter to give you more detailed info about his environment.

Finally, and for your information, I'm reproducing it using Postgres.

Regards.
(0029865)
sathiyan   
2010-08-10 11:29   
I have uploaded those two files after changing the condition(including from and to account). There is no difference in the result. I am not able to reproduce. Could you please try again and bug persist, give the detailed steps.

Regards
Sathiyan.
(0029878)
sathiyan   
2010-08-11 05:41   
Could you please respond to my last message, so that I can change into "Not Able to Reproduce" and closed the issue.
(0029886)
networkb   
2010-08-11 11:50   
I have just followed "Steps to Reproduce" in http://live.builds.openbravo.com/erp_devel_main-full-pgsql/security/Menu.html [^]
and error still happens to me.

You can check it in GLJournal with documentno=10000002

I attach screenshot of trial balance obtained where Initial Balance for Account 28290 is NOT correct

regards
(0029893)
sathiyan   
2010-08-11 15:47   
I have followed as it is from your reproduce. Sorry to say this, I am not able to reproduce. Please look into 14074_1.png, 14074_2.png,14074_3.png,14074_4.png,

Please correct me , if I do any mistakes on reproduce.

Regards
Sathiyan.
(0029894)
vmromanos   
2010-08-11 16:05   
You missed:
2. Go to Header and check "Opening" checkbox
(0029971)
hgbot   
2010-08-16 07:30   
Repository: erp/devel/pi
Changeset: c2393661413dc171d25cbf2268bf0e1d4b7f2f39
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Mon Aug 16 10:59:54 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c2393661413dc171d25cbf2268bf0e1d4b7f2f39 [^]

Fixes Issue 14074: Error with Opening entry in Trial Balance report

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0030005)
hudsonbot   
2010-08-16 12:07   
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/c2393661413d [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/294ab49a87fa [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18156.obx [^]
(0030183)
psarobe   
2010-08-20 12:59   
tested working fine. I can see 200