Fixes issue 13654
authorDavid Alsasua <david.alsasua@openbravo.com>
Tue, 20 Jul 2010 13:41:49 +0200
changeset 7934 840c40e82c78
parent 7933 8bbb4af47cd2
child 7935 99ff33f65889
Fixes issue 13654
Added coalesce to avoid unwanted document cancellations
src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql	Mon Jul 19 18:25:56 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql	Tue Jul 20 13:41:49 2010 +0200
@@ -182,7 +182,7 @@
     <SqlMethodComment></SqlMethodComment>
     <Sql>
       <![CDATA[
-        SELECT DP.ISMANUAL, DP.ISDIRECTPOSTING
+        SELECT COALESCE(DP.ISMANUAL,'N') AS ISMANUAL, COALESCE(DP.ISDIRECTPOSTING,'N') AS ISDIRECTPOSTING
         FROM C_SETTLEMENT S LEFT JOIN C_DEBT_PAYMENT DP
           ON DP.C_SETTLEMENT_GENERATE_ID = S.C_SETTLEMENT_ID
         WHERE S.C_SETTLEMENT_ID = ?