Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021945Openbravo ERP09. Financial managementpublic2012-10-16 10:302012-12-18 17:39
psarobe 
gorkaion 
normalmajoralways
closedfixed 
5
pi 
3.0MP19 
Core
No
0021945: Enhancement "User defined accounting report setup" - Modify the "Account" combo box
- Modify the "Account" combo box so you can select not only a sub-account but any other element level such as account, breakdown and heading. This combo will be similar as the one in "Accounting schema-->Accounting schema element" tab. There you can find the field "Account element" when selecting "Type": Account.
- Having this combo box you won't need to create a new node in the report whenever you create a sub-account and needs to be there. If you are able to select an Account or a breakdown you can skip to add new nodes/sub-accounts because this new sub-account will be in the corresponding Account/Breakdown/Heading. So finally you don't need to worry about whether new sub-accounts have been added to the report or not
N/A
No tags attached.
related to feature request 00225013.0MP19 closed gorkaion "User Defined Accounting Report" enhancement 
png Result1.png (15,375) 2012-12-10 16:39
https://issues.openbravo.com/file_download.php?file_id=5809&type=bug
png
Issue History
2012-10-16 10:30psarobeNew Issue
2012-10-16 10:30psarobeAssigned To => dmiguelez
2012-10-16 10:30psarobeModules => Core
2012-10-16 10:31psarobeStatusnew => scheduled
2012-10-16 10:31psarobefix_in_branch => pi
2012-12-10 16:38psarobeNote Added: 0054804
2012-12-10 16:39psarobeFile Added: Result1.png
2012-12-10 17:01psarobeTriggers an Emergency Pack => No
2012-12-10 17:01psarobeAssigned Todmiguelez => gorkaion
2012-12-10 17:01psarobefix_in_branchpi =>
2012-12-10 17:45psarobeRelationship addedrelated to 0022501
2012-12-17 18:38hgbotCheckin
2012-12-17 18:38hgbotNote Added: 0055022
2012-12-17 18:38hgbotCheckin
2012-12-17 18:38hgbotNote Added: 0055023
2012-12-17 18:38hgbotCheckin
2012-12-17 18:38hgbotNote Added: 0055026
2012-12-17 18:38hgbotStatusscheduled => resolved
2012-12-17 18:38hgbotResolutionopen => fixed
2012-12-17 18:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3ba207ffcdeceb355287148a50e2e2d42ad713a0 [^]
2012-12-18 10:58hudsonbotCheckin
2012-12-18 10:58hudsonbotNote Added: 0055041
2012-12-18 10:58hudsonbotCheckin
2012-12-18 10:58hudsonbotNote Added: 0055042
2012-12-18 10:58hudsonbotCheckin
2012-12-18 10:58hudsonbotNote Added: 0055045
2012-12-18 17:39psarobeStatusresolved => closed
2012-12-18 17:39psarobeFixed in Version => 3.0MP19

Notes
(0054804)
psarobe   
2012-12-10 16:38   
Test done to verify:
1. Create report for the breakdown account element 1100 (Current assets). Report name "1100 Current Assets - Breakdown"
2. Create another report which is summary and named "1100 Current Assets - summary". In this report as it is summary we add all the subaccounts that belong to it

Expected behaviour: The result in both report must be the same.
Current behaviour: The result is the same. See attach result1.png
(0055022)
hgbot   
2012-12-17 18:38   
Repository: erp/devel/pi
Changeset: e9513e612a33757b9ee2adcc63c1e8e8df9bc731
Author: daniel <daniel.martins <at> xpand-it.com>
Date: Wed Nov 14 14:43:10 2012 +0000
URL: http://code.openbravo.com/erp/devel/pi/rev/e9513e612a33757b9ee2adcc63c1e8e8df9bc731 [^]

Related to issue 21945.Modify the "Account" combo box so you can select not only a sub-account but any other element level

---
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
---
(0055023)
hgbot   
2012-12-17 18:38   
Repository: erp/devel/pi
Changeset: 3c68da0ffda11701d6ea7b880e0881453303c69e
Author: daniel <daniel.martins <at> xpand-it.com>
Date: Thu Nov 15 17:55:44 2012 +0000
URL: http://code.openbravo.com/erp/devel/pi/rev/3c68da0ffda11701d6ea7b880e0881453303c69e [^]

Related to issue 21945.Modify the "Account" combo box so you can select not only a sub-account but any other element level

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0055026)
hgbot   
2012-12-17 18:38   
Repository: erp/devel/pi
Changeset: 3ba207ffcdeceb355287148a50e2e2d42ad713a0
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Mon Dec 17 13:01:20 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3ba207ffcdeceb355287148a50e2e2d42ad713a0 [^]

Fixed issue 22308.Fixed issue 21507.Fixed issue 21945.Apply code review and fix issues.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
R src-db/database/model/functions/AD_ZERO_IF.xml
---
(0055041)
hudsonbot   
2012-12-18 10:58   
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/faba12fdbc2d [^]

Maturity status: Test
(0055042)
hudsonbot   
2012-12-18 10:58   
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/faba12fdbc2d [^]

Maturity status: Test
(0055045)
hudsonbot   
2012-12-18 10:58   
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/faba12fdbc2d [^]

Maturity status: Test