details: https://code.openbravo.com/erp/stable/2.50/rev/7fc73f97cb62
changeset: 9862:7fc73f97cb62
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Mar 28 17:17:31 2012 +0200
summary: issue 20028: Bug with Bank Accounts checked as default.Fixed
dbcons-oracle
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 14 +++++++++-----
1 files changed, 9 insertions(+), 5 deletions(-)
diffs (29 lines):
diff -r de31e1dafc8d -r 7fc73f97cb62
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
15:41:51 2012 +0200
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
17:17:31 2012 +0200
@@ -1536,16 +1536,20 @@
WHEN 'Y' THEN SO_BankAccount_ID
ELSE PO_BankAccount_ID
END
+ ),(COALESCE(
+ (SELECT MAX(C_BankAccount_ID)
+ FROM C_BANKACCOUNT
+ WHERE AD_Client_ID=v_Client_ID
+ AND
ad_isorgincluded(v_Org_ID,C_BANKACCOUNT.ad_org_id,v_Client_ID) <> -1
+ AND isActive='Y'
+ AND isDefault='Y'
),
(SELECT MAX(C_BankAccount_ID)
FROM C_BANKACCOUNT
WHERE AD_Client_ID=v_Client_ID
AND
ad_isorgincluded(v_Org_ID,C_BANKACCOUNT.ad_org_id,v_Client_ID) <> -1
- AND isActive='Y'
- GROUP BY isDefault
- ORDER BY isDefault DESC limit 1
- )
- ) INTO v_bankAccount
+ AND isActive='Y'))
+ )) INTO v_bankAccount
FROM C_BPARTNER
WHERE c_BPartner_ID=v_BPartner_ID;
v_cashBook:=NULL;
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
