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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014074
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-07-28 10:082010-09-13 12:38
ReporternetworkbView Statuspublic 
Assigned Tosathiyan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc2393661413d
ProjectionnoneETAnoneTarget Version2.50MP21
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP20SCM 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

0014074: 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)
TagsNo tags attached.
Attached Filespng file icon 14074_part1.png [^] (199,490 bytes) 2010-08-10 11:26


png file icon 14074_part2.png [^] (247,726 bytes) 2010-08-10 11:26


png file icon trialbalance.png [^] (219,482 bytes) 2010-08-11 11:50


png file icon 14074_1.png [^] (207,825 bytes) 2010-08-11 15:45


png file icon 14074_2.png [^] (194,764 bytes) 2010-08-11 15:45


png file icon 14074_3.png [^] (218,673 bytes) 2010-08-11 15:45


png file icon 14704_4.png [^] (237,187 bytes) 2010-08-11 15:45

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 00131622.50MP18 closedsathiyan trial balance report is wrong if exist records of type "opening" similars 
related to backport 00158502.50MP28 closedjonalegriaesarte the XLS generated in report trial balance is not correct 

-  Notes
(0029826)
vmromanos (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
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 (viewer)
2010-08-11 16:05

 You missed:
2. Go to Header and check "Opening" checkbox
(0029971)
hgbot (developer)
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 (viewer)
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 (viewer)
2010-08-20 12:59

 tested working fine. I can see 200

- Issue History
Date Modified Username Field Change
2010-07-28 10:08 networkb New Issue
2010-07-28 10:08 networkb Assigned To => dalsasua
2010-07-28 10:08 networkb OBNetwork customer => Yes
2010-08-05 13:07 vmromanos Relationship added duplicate of 0013162
2010-08-05 13:08 vmromanos Assigned To dalsasua => sathiyan
2010-08-05 13:09 vmromanos Note Added: 0029826
2010-08-09 08:38 vmromanos Status new => scheduled
2010-08-09 08:38 vmromanos fix_in_branch => pi
2010-08-10 08:28 sathiyan File Added: 14074_part1.png
2010-08-10 08:28 sathiyan File Added: 14074_part2.png
2010-08-10 08:30 sathiyan Note Added: 0029857
2010-08-10 08:31 sathiyan Assigned To sathiyan => vmromanos
2010-08-10 09:02 vmromanos Note Added: 0029860
2010-08-10 09:03 vmromanos Assigned To vmromanos => sathiyan
2010-08-10 11:25 sathiyan File Deleted: 14074_part1.png
2010-08-10 11:25 sathiyan File Deleted: 14074_part2.png
2010-08-10 11:26 sathiyan File Added: 14074_part1.png
2010-08-10 11:26 sathiyan File Added: 14074_part2.png
2010-08-10 11:29 sathiyan Note Added: 0029865
2010-08-10 11:29 sathiyan Assigned To sathiyan => networkb
2010-08-11 05:41 sathiyan Note Added: 0029878
2010-08-11 05:41 sathiyan Status scheduled => feedback
2010-08-11 11:50 networkb Note Added: 0029886
2010-08-11 11:50 networkb Status feedback => new
2010-08-11 11:50 networkb fix_in_branch pi =>
2010-08-11 11:50 networkb File Added: trialbalance.png
2010-08-11 15:45 sathiyan File Added: 14074_1.png
2010-08-11 15:45 sathiyan File Added: 14074_2.png
2010-08-11 15:45 sathiyan File Added: 14074_3.png
2010-08-11 15:45 sathiyan File Added: 14704_4.png
2010-08-11 15:47 sathiyan Note Added: 0029893
2010-08-11 15:48 sathiyan Assigned To networkb => sathiyan
2010-08-11 15:48 sathiyan Assigned To sathiyan => networkb
2010-08-11 15:49 sathiyan Status new => feedback
2010-08-11 16:05 vmromanos Assigned To networkb => sathiyan
2010-08-11 16:05 vmromanos Note Added: 0029894
2010-08-11 16:12 vmromanos Status feedback => new
2010-08-16 07:30 hgbot Checkin
2010-08-16 07:30 hgbot Note Added: 0029971
2010-08-16 07:30 hgbot Status new => resolved
2010-08-16 07:30 hgbot Resolution open => fixed
2010-08-16 07:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2393661413dc171d25cbf2268bf0e1d4b7f2f39 [^]
2010-08-16 12:07 hudsonbot Checkin
2010-08-16 12:07 hudsonbot Note Added: 0030005
2010-08-20 12:59 psarobe Note Added: 0030183
2010-08-20 12:59 psarobe Status resolved => closed
2010-09-13 12:38 anonymous sf_bug_id 0 => 3065162
2011-03-09 09:50 dalsasua Relationship added related to 0015850

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker