Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035896 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2017-05-02 17:12 | 2017-05-29 17:43 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR17Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 2f8dba119a61 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | aferraz | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | Production - Confirmed Stable | |||||||
| Regression date | 2015-01-15 | |||||||
| Regression introduced in release | 3.0PR15Q2 | |||||||
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035896: Wrong Trial Balance at "Account" level and without checking "Opening Entry Amount to Initial Balance" | |||||||
| Description | In 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 Reproduce | 0. 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" | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0096405) AtulOpenbravo (developer) 2017-05-04 22:33 |
Test Plan - Access To "End Year Close" window and verify that last year closed for "F&B España, S.A" organization is 2013. - 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. - Create new GL Journal for "F&B España, S.A" organization, any description, Accounting Date=01-01-2014. - Add new Header for "F&B España, S.A. US/A/Euro" general ledger and Accounting date=01-01-2014. - Add new line for "10300 - Socios por desembolsos no exigidos; capital social" account, Debit=400. - Add new line for "43000 - Clientes (euros) a corto plazo" account, Credit=400. Complete and post journal. - Run Trial Balance using same filtering criteria and check that now "103A" account has balance as 400. Test plan 28452 1- Login F&B International Group Admin. 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 check 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 check that obtained balance is 0.00. |
|
(0096624) hgbot (developer) 2017-05-16 17:48 |
Repository: erp/devel/pi Changeset: 2f8dba119a61615c208990200a7c32e7b6fde139 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Mon May 15 00:24:10 2017 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/2f8dba119a61615c208990200a7c32e7b6fde139 [^] Fixes issue 35896: 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 --- |
|
(0096628) aferraz (manager) 2017-05-16 18:16 |
Code review + Testing OK |
|
(0096971) hudsonbot (developer) 2017-05-29 17:43 |
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/1ee70113bdc4 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-05-02 17:12 | maite | New Issue | |
| 2017-05-02 17:12 | maite | Assigned To | => Triage Finance |
| 2017-05-02 17:12 | maite | Modules | => Core |
| 2017-05-02 17:12 | maite | Resolution time | => 1495490400 |
| 2017-05-02 17:12 | maite | Triggers an Emergency Pack | => No |
| 2017-05-02 17:12 | maite | Issue Monitored: networkb | |
| 2017-05-02 17:12 | maite | Relationship added | caused by 0028452 |
| 2017-05-03 09:47 | aferraz | Assigned To | Triage Finance => AtulOpenbravo |
| 2017-05-04 09:42 | aferraz | Status | new => scheduled |
| 2017-05-04 09:42 | aferraz | Regression level | => Production - Confirmed Stable |
| 2017-05-04 11:09 | AtulOpenbravo | Regression date | => 2015-01-15 |
| 2017-05-04 11:09 | AtulOpenbravo | Regression introduced in release | => 3.0PR15Q2 |
| 2017-05-04 11:09 | AtulOpenbravo | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/92d415cdc5cf0c2bd31363292d5da6d8e4e43b26 [^] |
| 2017-05-04 22:33 | AtulOpenbravo | Note Added: 0096405 | |
| 2017-05-09 18:09 | aferraz | Relationship added | related to 0021831 |
| 2017-05-11 19:56 | aferraz | Relationship deleted | depends on 0035920 |
| 2017-05-16 15:49 | AtulOpenbravo | Relationship added | related to 0036013 |
| 2017-05-16 17:48 | hgbot | Checkin | |
| 2017-05-16 17:48 | hgbot | Note Added: 0096624 | |
| 2017-05-16 17:48 | hgbot | Status | scheduled => resolved |
| 2017-05-16 17:48 | hgbot | Resolution | open => fixed |
| 2017-05-16 17:48 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2f8dba119a61615c208990200a7c32e7b6fde139 [^] |
| 2017-05-16 18:16 | aferraz | Review Assigned To | => aferraz |
| 2017-05-16 18:16 | aferraz | Note Added: 0096628 | |
| 2017-05-16 18:16 | aferraz | Status | resolved => closed |
| 2017-05-16 18:16 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096971 | |
| 2019-08-22 12:28 | ngarcia | Relationship added | related to 0023606 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |