details: https://code.openbravo.com/erp/devel/pi/rev/ae4bf9ced9d3
changeset: 18552:ae4bf9ced9d3
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Thu Nov 15 11:15:07 2012 +0100
summary: Fixed bug 22311 Update InitializeGeneralLedgerOrganization to work
properly
Update InitializeGeneralLedgerOrganization to work properly when there
are two or more ad_org_acctschema with same organization and same creation date
diffstat:
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeGeneralLedgerOrganizationData.class
| 0
src-util/modulescript/src/org/openbravo/modulescript/InitializeGeneralLedgerOrganization_data.xsql
| 2 +-
2 files changed, 1 insertions(+), 1 deletions(-)
diffs (14 lines):
diff -r bcfa910662a2 -r ae4bf9ced9d3
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeGeneralLedgerOrganizationData.class
Binary file
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeGeneralLedgerOrganizationData.class
has changed
diff -r bcfa910662a2 -r ae4bf9ced9d3
src-util/modulescript/src/org/openbravo/modulescript/InitializeGeneralLedgerOrganization_data.xsql
---
a/src-util/modulescript/src/org/openbravo/modulescript/InitializeGeneralLedgerOrganization_data.xsql
Wed Nov 14 12:05:51 2012 +0100
+++
b/src-util/modulescript/src/org/openbravo/modulescript/InitializeGeneralLedgerOrganization_data.xsql
Thu Nov 15 11:15:07 2012 +0100
@@ -23,7 +23,7 @@
<SqlMethodComment></SqlMethodComment>
<Sql>
<![CDATA[
- select (select ad_org_acctschema.c_acctschema_id
+ select (select min(ad_org_acctschema.c_acctschema_id)
from ad_org_acctschema
where ad_org.ad_org_id = ad_org_acctschema.ad_org_id
and ad_org_acctschema.isactive = 'Y'
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
