Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011575Openbravo ERP09. Financial managementpublic2009-12-01 13:552009-12-15 04:56
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP8 
Target Version2.50MP10Fixed in Version2.50MP10 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011575: Not Posted Transaction Report fails when there is more than one Accounting Schema
DescriptionWhen your application has defined more than one Accounting Schema and you try to execute Not Posted Transaction Report, ERROR: una subconsulta utilizada como expresi�n retorn� m�s de un registro is obtained.
Steps To ReproduceOnce you have more than one accounting schema in your aplication:

1. Financial Management || Accounting || Analysis Tools || Not Posted Transaction Report: set valid dates
2. Execute the report and you will obtain the error
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-01 13:55networkbNew Issue
2009-12-01 13:55networkbAssigned To => rafaroda
2009-12-01 13:55networkbOBNetwork customer => Yes
2009-12-01 13:56networkbTarget Version2.50MP9 => 2.50MP10
2009-12-07 19:59psarobeStatusnew => scheduled
2009-12-07 19:59psarobefix_in_branch => pi
2009-12-11 08:33rafarodaAssigned Torafaroda => dalsasua
2009-12-13 19:11hgbotCheckin
2009-12-13 19:11hgbotNote Added: 0022726
2009-12-13 19:11hgbotStatusscheduled => resolved
2009-12-13 19:11hgbotResolutionopen => fixed
2009-12-13 19:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/97fbb49ee2420017be2428fe6b5ddb771a426e48 [^]
2009-12-14 12:12sureshbabuNote Added: 0022744
2009-12-14 12:12sureshbabuStatusresolved => closed
2009-12-14 12:12sureshbabuFixed in Version => 2.50MP10
2009-12-15 00:00anonymoussf_bug_id0 => 2914442
2009-12-15 04:56hudsonbotCheckin
2009-12-15 04:56hudsonbotNote Added: 0022790

Notes
(0022726)
hgbot   
2009-12-13 19:11   
Repository: erp/devel/pi
Changeset: 97fbb49ee2420017be2428fe6b5ddb771a426e48
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Sun Dec 13 19:10:57 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/97fbb49ee2420017be2428fe6b5ddb771a426e48 [^]

Fixes issue 11575: Not Posted Transaction Report
fails when there is more than one Accounting Schema

---
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
---
(0022744)
sureshbabu   
2009-12-14 12:12   
Tested working fine
(0022790)
hudsonbot   
2009-12-15 04:56   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/e7ad8a48210d [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15705.obx [^]
---