details: /erp/devel/pi-engdev/rev/bd725f656988
changeset: 6926:bd725f656988
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Thu Apr 08 12:10:57 2010 +0200
summary: Fixes issue 0012864: While Generating payment Plan...
diffstat:
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diffs (33 lines):
diff -r f7f0baeef402 -r bd725f656988
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml
--- a/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Thu Apr
08 14:19:54 2010 +0530
+++ b/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Thu Apr
08 12:10:57 2010 +0200
@@ -44,6 +44,7 @@
v_BPartner_ID VARCHAR2(32);
v_DateInvoiced DATE;
v_TotalLines NUMBER;
+v_PaymentMethod C_INVOICE.FIN_PAYMENTMETHOD_ID%TYPE;
TYPE RECORD IS REF CURSOR;
Cur_Params RECORD;
@@ -72,10 +73,10 @@
v_ResultStr:='ReadingInvoice';
SELECT ad_client_id, ad_org_id, c_doctypetarget_id, IsSOTrx,
grandtotal, C_PaymentTerm_ID, PaymentRule, C_Currency_ID,
- C_BPartner_ID, DateInvoiced, totallines
+ C_BPartner_ID, DateInvoiced, totallines, fin_paymentmethod_id
INTO v_Client_ID, v_Org_ID, v_DocTypeTarget_ID, v_IsSOTrx,
v_GrandTotal, v_PaymentTerm, v_PaymentRule, v_Currency_ID,
- v_BPartner_ID, v_DateInvoiced, v_totallines
+ v_BPartner_ID, v_DateInvoiced, v_totallines, v_PaymentMethod
FROM c_invoice
WHERE c_invoice_id=p_record_id;
@@ -178,7 +179,7 @@
v_payment_schedule_invoice, v_client_id, v_org_id, 'Y',
now(), p_user, now(), p_user,
p_record_id, v_currency_id, null,
- 'to-do',
+ v_PaymentMethod,
v_scheduledamount, v_planneddate,
v_scheduledamount
);
------------------------------------------------------------------------------
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
