details: /erp/devel/pi-engdev/rev/b36a1592a57e
changeset: 6457:b36a1592a57e
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Mon Feb 22 13:52:16 2010 +0100
summary: Fix issue in FIN_GEN_PAYMENTSCHEDULE_INV procedure.
diffstat:
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 5f0a059d8d05 -r b36a1592a57e
src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml
--- a/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Mon Feb
22 13:43:48 2010 +0100
+++ b/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml Mon Feb
22 13:52:16 2010 +0100
@@ -187,7 +187,7 @@
SELECT count(*), max(pd.paymentno)
INTO v_count, v_paymentno
FROM fin_payment_schedule ps, fin_payment_detail_v pd
- WHERE ps.fin_payment_schedule_id = pd.fin_payment_schedule_invoice
+ WHERE ps.fin_payment_schedule_id = pd.fin_payment_sched_inv_v_id
AND ps.c_invoice_id = p_record_id;
IF (v_count <> 0) THEN
RAISE_APPLICATION_ERROR(-20000, '@InvoiceWithPayments@' || ' ' ||
v_paymentno);
------------------------------------------------------------------------------
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
