details: https://code.openbravo.com/erp/stable/2.50/rev/fc37e35a0783
changeset: 9859:fc37e35a0783
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Mar 28 12:45:48 2012 +0200
summary: issue 20028: Bug with Bank Accounts checked as default.
It was posible to query returns 2 records and it was wrong
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 8bd65a902a64 -r fc37e35a0783
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
12:34:29 2012 +0200
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Mar 28
12:45:48 2012 +0200
@@ -1544,7 +1544,7 @@
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
+ ORDER BY isDefault DESC limit 1
)
) 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
