details: /erp/stable/2.50/rev/94b9b915de31
changeset: 9415:94b9b915de31
user: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
date: Tue May 10 09:36:44 2011 +0200
summary: Fixed issue 16667. Employee with accounting schema of other entity
diffstat:
src-db/database/model/triggers/C_BPARTNER_TRG.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (22 lines):
diff -r 80dbc32ecfd6 -r 94b9b915de31
src-db/database/model/triggers/C_BPARTNER_TRG.xml
--- a/src-db/database/model/triggers/C_BPARTNER_TRG.xml Mon May 09 17:21:14
2011 +0200
+++ b/src-db/database/model/triggers/C_BPARTNER_TRG.xml Tue May 10 09:36:44
2011 +0200
@@ -180,14 +180,14 @@
v_C_AcctSchema_ID:=null;
v_count:=0;
FOR Cur_Defaults2 IN (
- SELECT AD_IsOrgIncluded(:new.AD_Org_ID, oa.AD_Org_ID,
:new.AD_Org_ID),
+ SELECT AD_IsOrgIncluded(:new.AD_Org_ID, oa.AD_Org_ID,
:new.AD_Client_ID),
oa.ad_sequence_bp_id, oa.isbpnewaccount, oa.acct_length,
oa.subacct_length, oa.createdby, oa.updatedby,
d2.E_Expense_Acct, d2.E_Prepayment_Acct, d2.AD_Client_ID,
d2.C_AcctSchema_ID
FROM C_AcctSchema_Default d2, AD_Org_AcctSchema oa
WHERE d2.C_AcctSchema_ID = oa.C_AcctSchema_ID
- AND oA.AD_Client_ID = d2.AD_Client_ID
- AND (AD_IsOrgIncluded(oa.AD_Org_ID, :new.AD_Org_ID,
:new.AD_Org_ID)<>-1
- OR AD_IsOrgIncluded(:new.AD_Org_ID, oa.AD_Org_ID,
:new.AD_Org_ID)<>-1)
+ AND oA.AD_Client_ID = :new.AD_Client_ID
+ AND (AD_IsOrgIncluded(oa.AD_Org_ID, :new.AD_Org_ID,
:new.AD_Client_ID)<>-1
+ OR AD_IsOrgIncluded(:new.AD_Org_ID, oa.AD_Org_ID,
:new.AD_Client_ID)<>-1)
ORDER BY 1 DESC
)
LOOP
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
