details: /erp/devel/pi/rev/0a2a03157bd5
changeset: 7557:0a2a03157bd5
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Fri Jun 04 15:38:46 2010 +0200
summary: Fixed bug 13474: Create payment fails while creating on bank
statements
It only checks if a withholding has been selected by the user
diffstat:
src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml | 16 ++++++++------
1 files changed, 9 insertions(+), 7 deletions(-)
diffs (26 lines):
diff -r 355f66af2294 -r 0a2a03157bd5
src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml
--- a/src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml Fri Jun 04
14:39:18 2010 +0200
+++ b/src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml Fri Jun 04
15:38:46 2010 +0200
@@ -122,13 +122,15 @@
WHERE L.C_BankStatementLine_ID=v_Record_ID
AND L.C_BankStatement_ID=B.C_BankStatement_ID;
--Check Withholding belongs to Business Partner
- SELECT COUNT(*)
- INTO v_count
- FROM C_BP_Withholding
- WHERE C_Withholding_ID=v_c_withholding_id
- AND C_BPartner_ID=v_C_BPartner_ID;
- IF (v_count=0) THEN
- RAISE_APPLICATION_ERROR(-20000, '@NOT_BP_WITHHOLDING@');
+ IF (v_c_withholding_id IS NOT NULL) THEN
+ SELECT COUNT(*)
+ INTO v_count
+ FROM C_BP_Withholding
+ WHERE C_Withholding_ID=v_c_withholding_id
+ AND C_BPartner_ID=v_C_BPartner_ID;
+ IF (v_count=0) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@NOT_BP_WITHHOLDING@');
+ END IF;
END IF;
--Insert Settlement
v_ResultStr:='InsertingSettlement';
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
