Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0022308Openbravo ERP09. Financial managementpublic2012-11-14 18:002012-12-18 17:39
Xpand-IT 
gorkaion 
lowminoralways
closedfixed 
10
 
3.0MP19 
Google Chrome
Core
No
0022308: User Defined Accounting Report raises an error
"ERROR: more than one row returned by a subquery used as an expression"

The error is shown when we try to get the report.
Log in at http://livebuilds2.openbravo.com/3.0MP16 [^]

Go to User Defined Accounting Report Setup and define a report as shown in the attachment.
Go to User Defined Accounting Report select the created report and year 2011.
The error is shown.
No tags attached.
png Openbravo - User Defined Accounting Report...png (80,415) 2012-11-14 18:00
https://issues.openbravo.com/file_download.php?file_id=5733&type=bug
png
Issue History
2012-11-14 18:00Xpand-ITNew Issue
2012-11-14 18:00Xpand-ITAssigned To => dmiguelez
2012-11-14 18:00Xpand-ITFile Added: Openbravo - User Defined Accounting Report...png
2012-11-14 18:00Xpand-ITWeb browser => Google Chrome
2012-11-14 18:00Xpand-ITModules => Core
2012-12-17 13:01gorkaionStatusnew => scheduled
2012-12-17 13:01gorkaionAssigned Todmiguelez => gorkaion
2012-12-17 13:01gorkaionfix_in_branch => pi
2012-12-17 18:38hgbotCheckin
2012-12-17 18:38hgbotNote Added: 0055024
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: 0055043
2012-12-18 17:39psarobeStatusresolved => closed
2012-12-18 17:39psarobeFixed in Version => 3.0MP19

Notes
(0055024)
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
---
(0055043)
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