details: /erp/devel/pi-engdev/rev/7fae9304b964
changeset: 6468:7fae9304b964
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Thu Feb 25 12:27:19 2010 +0100
summary: Fixed issue in FIN_GEN_PAYMENTSCHEDULE_INV extension point.
diffstat:
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diffs (33 lines):
diff -r b58aa5f87424 -r 7fae9304b964
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml
--- a/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Wed Feb
24 17:07:21 2010 +0100
+++ b/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Thu Feb
25 12:27:19 2010 +0100
@@ -85,8 +85,9 @@
v_scheduledamount NUMBER;
v_invoicedamount NUMBER;
v_notassignedamount NUMBER;
+ v_assignedamount NUMBER;
v_scheduledetailamount NUMBER;
- v_oldorder VARCHAR2(32) := '';
+ v_oldorder VARCHAR2(32) := '-1';
v_payment_schedule_invoice VARCHAR2(32);
CURSOR cur_order_schdet (invoice_id VARCHAR2) IS
@@ -186,15 +187,16 @@
AND c_invoiceline.c_invoice_id = p_record_id
AND c_orderline.c_order_id = order_schdet.order_id;
--substract previously assigned amount
- SELECT v_invoicedamount - SUM(psd.amount) INTO v_notassignedamount
+ SELECT SUM(psd.amount) INTO v_assignedamount
FROM fin_payment_schedule ps_inv, fin_payment_scheduledetail psd,
fin_payment_schedule ps_ord
WHERE ps_inv.fin_payment_schedule_id =
psd.fin_payment_schedule_invoice
AND psd.fin_payment_schedule_order =
ps_ord.fin_payment_schedule_id
AND ps_inv.c_invoice_id = p_record_id
AND ps_ord.c_order_id = order_schdet.order_id;
+ v_notassignedamount := COALESCE(v_invoicedamount,0) -
COALESCE(v_assignedamount,0);
END IF;
- IF (v_notassignedamount <= 0) THEN
+ IF (v_notassignedamount != 0) THEN
next_order := TRUE;
END IF;
--create a new payment schedule detail if necessary
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
