Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028452 | Openbravo ERP | 09. Financial management | public | 2014-12-18 17:22 | 2015-02-04 20:34 |
|
| Reporter | maite | |
| Assigned To | reinaldoguerra | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR15Q2 | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | umartirena |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028452: Wrong Trial Balance when standard accounting information exists in Opening date |
| Description | Wrong 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 Reproduce | 1. 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 Solution | Problem 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)) |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | duplicate of | defect | 0021831 | 3.0MP19 | closed | jecharri | Trial Balance shows different Final Balance depending the check 'Opening Entry Amount to Initial Balance' | | causes | defect | 0035896 | | closed | AtulOpenbravo | Wrong Trial Balance at "Account" level and without checking "Opening Entry Amount to Initial Balance" |
|
| Attached Files | |
|
| 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 |
|
Notes |
|
|
|
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
|
|
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
|
|
2015-01-20 09:57
|
|
|
|
|
|
|