details: https://code.openbravo.com/erp/devel/pi/rev/0156dbf78729
changeset: 22137:0156dbf78729
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Mon Feb 24 18:04:54 2014 +0100
summary: Related to issue 25696 Fixes in modulescript
diffstat:
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeIsPaymentPaidData.class
| 0
src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
| 6 +-----
2 files changed, 1 insertions(+), 5 deletions(-)
diffs (21 lines):
diff -r 395b16591ed9 -r 0156dbf78729
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeIsPaymentPaidData.class
Binary file
src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeIsPaymentPaidData.class
has changed
diff -r 395b16591ed9 -r 0156dbf78729
src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
---
a/src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
Mon Feb 24 16:01:09 2014 +0100
+++
b/src-util/modulescript/src/org/openbravo/modulescript/InitializeIsPaymentPaid_data.xsql
Mon Feb 24 18:04:54 2014 +0100
@@ -33,14 +33,10 @@
<![CDATA[
update fin_payment_scheduledetail set isinvoicepaid=(select CASE WHEN
fpsd.fin_payment_detail_id is null then 'N'
WHEN
- ((aprm_seqnumberpaymentstatus(fp.status))>=
(aprm_seqnumberpaymentstatus((CASE WHEN fp.isreceipt='Y'
- THEN Payin_Invoicepaidstatus ELSE Payout_Invoicepaidstatus END))))
THEN 'Y' ELSE 'N' END
+ fp.status IN ('PPM', 'RPR', 'PWNC', 'RDNC', 'RPPC') THEN 'Y' ELSE 'N'
END, fp.status
from fin_payment_scheduledetail fpsd
left join fin_payment_detail fpd on
fpsd.fin_payment_detail_id=fpd.fin_payment_detail_id
left join fin_payment fp on fpd.fin_payment_id=fp.fin_payment_id
- left join fin_financial_account fa on
fa.fin_financial_account_id=fp.fin_financial_account_id
- left join FIN_FinAcc_PaymentMethod fpm on
fpm.fin_financial_account_id=fp.fin_financial_account_id
- and fpm.fin_paymentmethod_id=fp.fin_paymentmethod_id
and fin_payment_schedule_invoice is not null
where
fin_payment_scheduledetail.fin_payment_scheduledetail_id=fpsd.fin_payment_scheduledetail_id)
]]>
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
