details: /erp/devel/pi-engdev/rev/a34dc910797a
changeset: 6474:a34dc910797a
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Mon Mar 01 19:10:00 2010 +0100
summary: Fixes prepayment for invoices with partial prepayment
diffstat:
src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (15 lines):
diff -r 67f0130f0a64 -r a34dc910797a
src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql Mon Mar 01
13:22:22 2010 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql Mon Mar 01
19:10:00 2010 +0100
@@ -73,9 +73,9 @@
<SqlMethodComment></SqlMethodComment>
<Sql>
<![CDATA[
- SELECT MAX(FIN_PAYMENT_SCHEDULE.AMOUNT) - SUM(CASE WHEN
FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER IS NOT NULL THEN
FIN_PAYMENT_SCHEDULEDETAIL.AMOUNT ELSE 0 END) AS AMOUNT,
MAX(FIN_PAYMENT_SCHEDULE.C_CURRENCY_ID) AS C_CURRENCY_ID,
+ SELECT MAX(FIN_PAYMENT_SCHEDULE.AMOUNT) - SUM(CASE WHEN
(FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER is not null AND
COALESCE(FIN_PAYMENT_DETAIL.ISPREPAYMENT,'N') = 'Y') THEN
FIN_PAYMENT_SCHEDULEDETAIL.AMOUNT ELSE 0 END) AS AMOUNT,
MAX(FIN_PAYMENT_SCHEDULE.C_CURRENCY_ID) AS C_CURRENCY_ID,
FIN_PAYMENT_SCHEDULE.FIN_PAYMENT_SCHEDULE_ID,
MAX(FIN_PAYMENT_SCHEDULE.FIN_PAYMENTMETHOD_ID) AS FIN_PAYMENTMETHOD_ID,
- SUM(CASE WHEN FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER IS
NOT NULL THEN FIN_PAYMENT_SCHEDULEDETAIL.AMOUNT ELSE 0 END) AS PREPAIDAMT
+ SUM(CASE WHEN (FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER is
not null AND COALESCE(FIN_PAYMENT_DETAIL.ISPREPAYMENT,'N') = 'Y') THEN
FIN_PAYMENT_SCHEDULEDETAIL.AMOUNT ELSE 0 END) AS PREPAIDAMT
FROM FIN_PAYMENT_SCHEDULE LEFT JOIN FIN_PAYMENT_SCHEDULEDETAIL ON
FIN_PAYMENT_SCHEDULE.FIN_PAYMENT_SCHEDULE_ID =
FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_INVOICE
LEFT JOIN FIN_PAYMENT_DETAIL ON
FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_DETAIL_ID =
FIN_PAYMENT_DETAIL.FIN_PAYMENT_DETAIL_ID
WHERE FIN_PAYMENT_SCHEDULE.C_INVOICE_ID =?
------------------------------------------------------------------------------
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
