details: /erp/devel/pi/rev/806f41767485
changeset: 12203:806f41767485
user: Mikel Irurita <mikel.irurita <at> openbravo.com>
date: Tue May 17 17:42:24 2011 +0200
summary: Fixes issue 17194: Add payment IN/OUT button in sales invoices is
not working well
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
| 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diffs (20 lines):
diff -r fe95455737a5 -r 806f41767485
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Tue May 17 17:29:14 2011 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Tue May 17 17:42:24 2011 +0200
@@ -340,12 +340,14 @@
SELECT SUM(amount) + v_pendingAmountFromOrder INTO
v_pendingAmountFromOrder
FROM fin_payment_scheduledetail
WHERE fin_payment_schedule_order =
order_schdet.fin_payment_schedule_order
- AND fin_payment_detail_id is null;
+ AND fin_payment_detail_id is null
+ AND fin_payment_scheduledetail_id <> v_scheduledetailid;
-- link remaining payment schedule detail from order to the
invoice as it is fully invoiced
UPDATE fin_payment_scheduledetail
SET fin_payment_schedule_invoice = v_payment_schedule_invoice
WHERE fin_payment_schedule_order =
order_schdet.fin_payment_schedule_order
- AND fin_payment_detail_id is null;
+ AND fin_payment_detail_id is null
+ AND fin_payment_scheduledetail_id <> v_scheduledetailid;
END IF;
IF (v_differenceamount > 0) THEN
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
