Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016275Openbravo ERP09. Financial managementpublic2011-03-14 17:222011-03-17 18:38
Reporteregoitz 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP23 
Target Version2.50MP28Fixed in Version2.50MP28 
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
Summary0016275: The User Defined Accounting Report does not work in 2.50
DescriptionThe User Defined Accounting Report does not work in 2.50.

Steps To Reproduce-In an application create an organization using the spanish accounting file.
-Download the script to use ECPN from sourceforge:
http://switch.dl.sourceforge.net/project/openbravo/04-openbravo-accounting/2.50,%202.40%20and%202.35/ECPN%2BEFE.zip [^]
-Execute the script fro 2.50 in oracle to create the ECPN report
-Go to Financial Management || Accounting || Analysis Tools || User Defined Accounting Report || User Defined Accounting Report and execute the report.
*you get an error with:

ERROR: no existe la columna «1000003» en carácter 896
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 00162763.0RC6 closed egoitz The User Defined Accounting Report does not work with new uuid 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-14 17:22egoitzNew Issue
2011-03-14 17:22egoitzAssigned To => egoitz
2011-03-14 17:22egoitzModules => Core
2011-03-14 17:22egoitzOBNetwork customer => Yes
2011-03-14 17:23egoitzIssue cloned0016276
2011-03-14 17:23egoitzRelationship addeddepends on 0016276
2011-03-14 17:27hgbotCheckin
2011-03-14 17:27hgbotNote Added: 0034818
2011-03-14 17:27hgbotStatusnew => resolved
2011-03-14 17:27hgbotResolutionopen => fixed
2011-03-14 17:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/2efa29be45958875e9869d7f48e57cf0f52511ed [^]
2011-03-14 17:30egoitzNote Added: 0034819
2011-03-17 18:38egoitzNote Added: 0035019
2011-03-17 18:38egoitzStatusresolved => closed
2011-03-17 18:38egoitzFixed in Version => 2.50MP28

Notes
(0034818)
hgbot   
2011-03-14 17:27   
Repository: erp/stable/2.50
Changeset: 2efa29be45958875e9869d7f48e57cf0f52511ed
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Mon Mar 14 17:26:16 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/2efa29be45958875e9869d7f48e57cf0f52511ed [^]

Fixed issue 16275. The User Defined Accounting Report does not work

---
M src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
---
(0034819)
egoitz   
2011-03-14 17:30   
* How to test the issue
Follow the steps to reprocue
 * Other areas affected
Only a parameter of the select has been modified to add simple quotes (') in the org list to make the report compatible with new uuids used in 2.50 release.
In 2.40 it was working perfect becuase the id's where numbers, so quotes were not needed
(0035019)
egoitz   
2011-03-17 18:38   
Tested by the client.