Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021507Openbravo ERP09. Financial managementpublic2012-08-30 12:522012-12-18 17:40
maite 
gorkaion 
urgentmajoralways
closedfixed 
5
 
3.0MP19 
Core
No
0021507: It would be nice to include more "Report type" options in User Defined Accounting Reports
It would be nice to include more "Report type" options, in User Defined Accounting Reports, in order to cover much more situations
N/A
1. Field "Report Type": Add more options
* Negative Credit (-Credit)
* Negative Debit (-Debit)

2. Add new field "Consider Zero": This is a list with the following value:
* Never
* When negative
* When positive
When the result is one of this options then it shows zero*
No tags attached.
related to feature request 00225013.0MP19 closed gorkaion "User Defined Accounting Report" enhancement 
png Result1.png (23,329) 2012-12-10 17:11
https://issues.openbravo.com/file_download.php?file_id=5810&type=bug
png
Issue History
2012-08-30 12:52maiteNew Issue
2012-08-30 12:52maiteAssigned To => mirurita
2012-08-30 12:52maiteModules => Core
2012-08-30 12:52maiteIssue Monitored: networkb
2012-08-30 13:30Xpand-ITIssue Monitored: Xpand-IT
2012-12-10 17:00psarobeTriggers an Emergency Pack => No
2012-12-10 17:00psarobeSummaryIt would be nice to include more "Report type" options, in User Defined Accounting Reports => It would be nice to include more "Report type" options in User Defined Accounting Reports
2012-12-10 17:00psarobeDescription Updatedbug_revision_view_page.php?rev_id=4150#r4150
2012-12-10 17:00psarobeSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4152#r4152
2012-12-10 17:00psarobeProposed Solution updated
2012-12-10 17:01psarobeStatusnew => scheduled
2012-12-10 17:01psarobeAssigned Tomirurita => gorkaion
2012-12-10 17:01psarobefix_in_branch => pi
2012-12-10 17:11psarobeNote Added: 0054806
2012-12-10 17:11psarobeFile Added: Result1.png
2012-12-10 17:45psarobeRelationship addedrelated to 0022501
2012-12-17 18:37hgbotCheckin
2012-12-17 18:37hgbotNote Added: 0055020
2012-12-17 18:37hgbotCheckin
2012-12-17 18:37hgbotNote Added: 0055021
2012-12-17 18:38hgbotCheckin
2012-12-17 18:38hgbotNote Added: 0055025
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: 0055039
2012-12-18 10:58hudsonbotCheckin
2012-12-18 10:58hudsonbotNote Added: 0055040
2012-12-18 10:58hudsonbotCheckin
2012-12-18 10:58hudsonbotNote Added: 0055044
2012-12-18 17:40psarobeStatusresolved => closed
2012-12-18 17:40psarobeFixed in Version => 3.0MP19

Notes
(0054806)
psarobe   
2012-12-10 17:11   
functional testing done. See attach result1.png
(0055020)
hgbot   
2012-12-17 18:37   
Repository: erp/devel/pi
Changeset: 89ba5b74782aefb26beeb3e0d738d82a203f957a
Author: daniel <daniel.martins <at> xpand-it.com>
Date: Wed Oct 24 16:20:58 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/89ba5b74782aefb26beeb3e0d738d82a203f957a [^]

Related to issue 21507.Add the options -Credit and -Debit to the Report Type in User Defined Accounting Report

---
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
---
(0055021)
hgbot   
2012-12-17 18:37   
Repository: erp/devel/pi
Changeset: 691418c9a8b9a8142aa6e10e1a9930c010ef85c2
Author: daniel <daniel.martins <at> xpand-it.com>
Date: Wed Oct 24 19:00:00 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/691418c9a8b9a8142aa6e10e1a9930c010ef85c2 [^]

Related to issue 21507.Add a conditional option (Consider Zero) to the User Defined Accounting Report

---
M src-db/database/model/tables/AD_ACCOUNTINGRPT_ELEMENT.xml
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_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
A src-db/database/model/functions/AD_ZERO_IF.xml
---
(0055025)
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
---
(0055039)
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
(0055040)
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
(0055044)
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