Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020254Openbravo ERP09. Financial managementpublic2012-04-12 13:392012-04-21 14:24
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020254: Multi accounting schema is not working properly in some circunstances
DescriptionHaving an environment with 2 accounting schemas configured, a sales invoice is being posted into one single accounting schema.

There is a bug in code which is trying to eval if a table is active in an accounting schema but it is failing due to a wrong sql which is using an exist clause which is wrong.
Steps To ReproduceCreate a client (initial client setup)
Create an organization called Jamaica and create an accounting schema within the process (Initial organization setup)
Create an organization called USA and create an accounting schema within the process (Initial organization setup)
Modify USA accounting schema: organization = *
make sure both organizations are bellow * and ready.
configure Jamaica organization so that both accounting schemas are used (Jamaica and USA) by adding them to accounting schema tab in organization window.
Create an invoice for jamaica and post it
Realize that it is being posted just to Jamaica accounting schema
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020294 scheduled Triage Omni OMS Updating Organization in Accounting Schema window 
related to defect 0020295 closed naiaramartinez AcctSchemaData.selectAcctSchemaTable2() should be deprecated 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-04-12 13:39eduardo_ArgalNew Issue
2012-04-12 13:39eduardo_ArgalAssigned To => eduardo_Argal
2012-04-12 13:39eduardo_ArgalModules => Core
2012-04-12 16:47eduardo_ArgalStatusnew => scheduled
2012-04-12 16:47eduardo_Argalfix_in_branch => pi
2012-04-17 20:45vmromanosRelationship addedrelated to 0020294
2012-04-17 20:47vmromanosRelationship addedrelated to 0020295
2012-04-17 20:49hgbotCheckin
2012-04-17 20:49hgbotNote Added: 0047684
2012-04-17 20:49hgbotStatusscheduled => resolved
2012-04-17 20:49hgbotResolutionopen => fixed
2012-04-17 20:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/564fb957650e8c00fb5f0c384204e0ee4f777207 [^]
2012-04-17 20:52vmromanosNote Added: 0047685
2012-04-17 20:52vmromanosStatusresolved => closed
2012-04-17 20:52vmromanosFixed in Version => 3.0MP11
2012-04-21 14:24hudsonbotCheckin
2012-04-21 14:24hudsonbotNote Added: 0047828

Notes
(0047684)
hgbot   
2012-04-17 20:49   
Repository: erp/devel/pi
Changeset: 564fb957650e8c00fb5f0c384204e0ee4f777207
Author: Eduardo Argal <eduardo.argal <at> openbravo.com>
Date: Thu Apr 12 17:05:03 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/564fb957650e8c00fb5f0c384204e0ee4f777207 [^]

Fixes bug 20254: Multi accounting schema is not working properly in some circunstances

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
---
(0047685)
vmromanos   
2012-04-17 20:52   
The root cause for this issue is 0020294.
0020295 is also related to this one and it should be fixed ASAP.

The code review + testing for this issue is OK.
(0047828)
hudsonbot   
2012-04-21 14:24   
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/2eb57286c1fc [^]

Maturity status: Test