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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028452
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2014-12-18 17:222015-02-04 20:34
ReportermaiteView Statuspublic 
Assigned Toreinaldoguerra 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revision92d415cdc5cf
ProjectionnoneETAnoneTarget Version3.0PR15Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toumartirena
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028452: Wrong Trial Balance when standard accounting information exists in Opening date

DescriptionWrong Trial Balance when standard accounting information exists in Opening date, and report is run at "Account" level and with "Opening Entry Amount to Initial Balance" flag is NOT marked
Steps To Reproduce1. Run Trial Balance for "España General Ledger" , Account Level= Account and "Opening Entry Amount to Initial Balance" NOT marked and dates from 01/01/2014 to 31/12/2014
2. Realize that balance obtained is 0.00
3. Register new Sales Invoice with date 01/01/2014 and post it
4. Run trial balance using same filters and realize that obtained balance is not 0.00
Proposed SolutionProblem is in "calculateTree" function, when "dataIB" variable is not null. In line 763, value of "data[i].amtacctdr" is being overwritten with (new BigDecimal(dataIB[k].amtacctdr).add(parcialDR)) instead of being increased (new BigDecimal(dataIB[k].amtacctdr).add(parcialDR).add(data[i].amtacctdr))
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 00218313.0MP19 closedjecharri Trial Balance shows different Final Balance depending the check 'Opening Entry Amount to Initial Balance' 
causes defect 0035896 closedAtulOpenbravo Wrong Trial Balance at "Account" level and without checking "Opening Entry Amount to Initial Balance" 

-  Notes
(0073560)
reinaldoguerra (developer)
2015-01-16 02:55

Test plan used:
1- Login into Openbravo ERP.
2- Run Run Trial Balance Report
3- Select dates from 01/01/2014 to 31/12/2014, organization and general ledger: España S.A
4- Display advanced filters and select account level as account and uncheck "Opening Entry Amount to Initial Balance"
5- Click search button and realize that balance obtained is 0.00
6- Register new Sales Invoice with date 01/01/2014, complete it and post it.
7- Run trial balance using same filters and realize that obtained balance is still 0.00
(0073637)
hgbot (developer)
2015-01-20 09:57

Repository: erp/devel/pi
Changeset: 92d415cdc5cf0c2bd31363292d5da6d8e4e43b26
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Thu Jan 15 17:46:57 2015 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^]

Fixed bug 28452: Wrong Trial Balance having standard accounting in Opening date.

The method calculateTree, in Report Trial Balance process class, was calculating in a wrong way the balance of accounting's credits and debits in opening dates. So the method was changed to not just overwrite credit and debit values but to increase them with the accumulate, when initial balance information is requested.
Now when executing Trial Balance report, for opening dates, accounting's credits and debits are calculated properly and balance is set to 0.

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
---
(0073638)
umartirena (reporter)
2015-01-20 09:57

Code Review + Testing OK
(0074163)
hudsonbot (developer)
2015-02-04 20:34

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f36c91d0ad63 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-12-18 17:22 maite New Issue
2014-12-18 17:22 maite Assigned To => dmiguelez
2014-12-18 17:22 maite Modules => Core
2014-12-18 17:22 maite Resolution time => 1421276400
2014-12-18 17:22 maite Triggers an Emergency Pack => No
2014-12-18 17:23 maite Assigned To dmiguelez => Sandrahuguet
2014-12-18 17:23 maite Issue Monitored: networkb
2015-01-15 00:49 reinaldoguerra Assigned To Sandrahuguet => reinaldoguerra
2015-01-15 00:49 reinaldoguerra Status new => scheduled
2015-01-16 02:55 reinaldoguerra Note Added: 0073560
2015-01-20 09:57 hgbot Checkin
2015-01-20 09:57 hgbot Note Added: 0073637
2015-01-20 09:57 hgbot Status scheduled => resolved
2015-01-20 09:57 hgbot Resolution open => fixed
2015-01-20 09:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^]
2015-01-20 09:57 umartirena Review Assigned To => umartirena
2015-01-20 09:57 umartirena Note Added: 0073638
2015-01-20 09:57 umartirena Status resolved => closed
2015-01-20 09:57 umartirena Fixed in Version => pi
2015-02-04 20:34 hudsonbot Checkin
2015-02-04 20:34 hudsonbot Note Added: 0074163
2017-05-02 17:12 maite Relationship added causes 0035896
2017-05-12 12:31 aferraz Relationship added duplicate of 0021831
2017-06-26 10:26 dmitry_mezentsev Relationship added causes 0035919
2017-06-26 10:32 dmitry_mezentsev Relationship deleted causes 0035919


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker