Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035919Openbravo ERP09. Financial managementpublic2017-05-02 17:122017-06-26 10:32
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q1.2Fixed in Version3.0PR17Q1.2 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2015-01-15
Regression introduced in release3.0PR15Q2
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^]
Triggers an Emergency PackNo
Summary0035919: Wrong Trial Balance at "Account" level and without checking "Opening Entry Amount to Initial Balance"
DescriptionIn case regular accounting information exists for Opening Date and Trial Balance is run at "Account" level and without checking "Opening Entry Amount to Initial Balance", wrong information is shown
Steps To Reproduce0. Access To "End Year Close" window and verify that last year closed for "F&B España, S.A" organization is 2013
1. Run Trial Balance report from 01-01-2014 to 31-12-2014, "F&B España, S.A" organization, "F&B España, S.A US/A/Euro" general ledger, "Account" level, "Opening Entry Amount to Initial Balance" NOT checked and realize that no information for "130A" account appears
2. Create new GL Journal for "F&B España, S.A" organization, any description, Accounting Date=01-01-2014.
3. Add new Header for "F&B España, S.A. US/A/Euro" general ledger and Accounting date=01-01-2014.
4. Add new line for "10300 - Socios por desembolsos no exigidos; capital social" account, Debit=400
5. Add new line for "43000 - Clientes (euros) a corto plazo" account, Credit=400. Complete and post journal
6. Run Trial Balance using same filtering criteria and realize that now "103A" account appears but balance shown is 800 instead of 400

Moreover, if you change Account Level filtering criteria from Account to Sub-account you can see that proper balance of 400 is calculated for account "10300"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0035896 closed AtulOpenbravo Wrong Trial Balance at "Account" level and without checking "Opening Entry Amount to Initial Balance" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-05-04 09:42aferrazTypedefect => backport
2017-05-04 09:42aferrazTarget Version => 3.0PR17Q1.2
2017-05-04 21:18AtulOpenbravoRegression level => Production - Confirmed Stable
2017-05-04 21:18AtulOpenbravoRegression date => 2015-01-15
2017-05-04 21:18AtulOpenbravoRegression introduced in release => 3.0PR15Q2
2017-05-04 21:18AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^]
2017-05-16 18:16hgbotCheckin
2017-05-16 18:16hgbotNote Added: 0096627
2017-05-16 18:16hgbotStatusscheduled => resolved
2017-05-16 18:16hgbotResolutionopen => fixed
2017-05-16 18:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q1.2/rev/334a563cf66fddebac13732e8d79383192cb05f5 [^]
2017-05-16 18:17aferrazReview Assigned To => aferraz
2017-05-16 18:17aferrazNote Added: 0096630
2017-05-16 18:17aferrazStatusresolved => closed
2017-05-16 18:17aferrazFixed in Version => 3.0PR17Q1.2
2017-06-26 10:26dmitry_mezentsevRelationship addedcaused by 0028452
2017-06-26 10:32dmitry_mezentsevRelationship deletedcaused by 0028452

Notes
(0096627)
hgbot   
2017-05-16 18:16   
Repository: erp/backports/3.0PR17Q1.2
Changeset: 334a563cf66fddebac13732e8d79383192cb05f5
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon May 15 00:24:10 2017 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR17Q1.2/rev/334a563cf66fddebac13732e8d79383192cb05f5 [^]

Fixes issue 35919: Wrong Trial Balance at "Account" level
and without checking "Opening Entry Amount to Initial Balance"

select is modified to get all account tree elements and their respective dr and cr in fact
acct other than fact acct type R (Income Statement), C (Closing) and
O (Opening) in between date from and date to filters. Select Initial Balance Method
is modified to just get the initial balance of the account tree element upto from date
filter or the opening type fact acct register on from date filter.

Using the Opening Entry Amount to Initial Balance flag and initial balance sign it is
decided to add to either dr or cr column respectively. +ve value added to debits and
-ve value added to credits.

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0096630)
aferraz   
2017-05-16 18:17   
Code review + Testing OK