details: /erp/devel/pi-engdev/rev/67f0130f0a64
changeset: 6473:67f0130f0a64
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Mon Mar 01 13:22:22 2010 +0100
summary: Fixes invoice prepayment
diffstat:
src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r b2b81c54fa41 -r 67f0130f0a64
src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql Mon Mar 01
16:20:39 2010 +0530
+++ b/src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql Mon Mar 01
13:22:22 2010 +0100
@@ -76,7 +76,7 @@
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,
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
- FROM FIN_PAYMENT_SCHEDULE LEFT JOIN FIN_PAYMENT_SCHEDULEDETAIL ON
FIN_PAYMENT_SCHEDULE.FIN_PAYMENT_SCHEDULE_ID =
FIN_PAYMENT_SCHEDULEDETAIL.FIN_PAYMENT_SCHEDULE_ORDER
+ 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 =?
AND COALESCE(FIN_PAYMENT_DETAIL.ISPREPAYMENT,'Y') = 'Y'
------------------------------------------------------------------------------
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
