details: https://code.openbravo.com/erp/stable/2.50/rev/8bd65a902a64
changeset: 9858:8bd65a902a64
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Mar 28 12:34:29 2012 +0200
summary: Fixes issue 20028: Bug with Bank Accounts checked as default.
Now only bank accounts that are included in the org tree are propoused
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diffs (16 lines):
diff -r 2f9f33f0b923 -r 8bd65a902a64
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
09:41:47 2012 +0200
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
12:34:29 2012 +0200
@@ -1540,7 +1540,11 @@
(SELECT MAX(C_BankAccount_ID)
FROM C_BANKACCOUNT
WHERE AD_Client_ID=v_Client_ID
- AND isDefault='Y'
+ --AND isDefault='Y'
+ 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
)
) INTO v_bankAccount
FROM C_BPARTNER
------------------------------------------------------------------------------
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
