# HG changeset patch
# User Asier Martirena <asier.martirena@openbravo.com>
# Date 1466065248 -7200
#      Thu Jun 16 10:20:48 2016 +0200
# Node ID bbb0ddaf497d0156cd1f586acc01ad6d05338011
# Parent  21698df6e4fe6e0272f997ba99be1c38bc966ee7
Fixed issue 32939: It was not possible to add a payment to an order with negative outstanding amount

diff --git a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_AUXILIARINPUT.xml
@@ -71,7 +71,7 @@
 <!--874CCFB2FE7B40D79D2B0AE27951853F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--874CCFB2FE7B40D79D2B0AE27951853F-->  <AD_TAB_ID><![CDATA[294]]></AD_TAB_ID>
 <!--874CCFB2FE7B40D79D2B0AE27951853F-->  <NAME><![CDATA[APRM_OrderIsPaid]]></NAME>
-<!--874CCFB2FE7B40D79D2B0AE27951853F-->  <CODE><![CDATA[@SQL=select case when ps.outstandingamt > 0 then 'N' else 'Y' end
+<!--874CCFB2FE7B40D79D2B0AE27951853F-->  <CODE><![CDATA[@SQL=select case when ps.outstandingamt <> 0 then 'N' else 'Y' end
           from fin_payment_scheduledetail fpsd
               join fin_payment_detail fpd on fpsd.fin_payment_detail_id=fpd.fin_payment_detail_id
               join fin_payment fp on fpd.fin_payment_id=fp.fin_payment_id
@@ -101,7 +101,7 @@
 <!--9FF4321DE0E5487B8A649A444F3F64BC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--9FF4321DE0E5487B8A649A444F3F64BC-->  <AD_TAB_ID><![CDATA[186]]></AD_TAB_ID>
 <!--9FF4321DE0E5487B8A649A444F3F64BC-->  <NAME><![CDATA[APRM_OrderIsPaid]]></NAME>
-<!--9FF4321DE0E5487B8A649A444F3F64BC-->  <CODE><![CDATA[@SQL=select case when ps.outstandingamt > 0 then 'N' else 'Y' end
+<!--9FF4321DE0E5487B8A649A444F3F64BC-->  <CODE><![CDATA[@SQL=select case when ps.outstandingamt <> 0 then 'N' else 'Y' end
           from fin_payment_scheduledetail fpsd
               join fin_payment_detail fpd on fpsd.fin_payment_detail_id=fpd.fin_payment_detail_id
               join fin_payment fp on fpd.fin_payment_id=fp.fin_payment_id