pgsql/investigations/ar-debitmemo.sql

diff --git a/pgsql/investigations/ar-debitmemo.sql b/pgsql/investigations/ar-debitmemo.sql
index 793a6b8..9214fbc 100644 (file)
--- a/pgsql/investigations/ar-debitmemo.sql
+++ b/pgsql/investigations/ar-debitmemo.sql
@@ -86,15 +86,9 @@ BEGIN
             gltrans
     
     WHERE
-            CASE WHEN _ar.aropen_applyto IS NULL OR _ar.aropen_applyto = '' THEN
-                gltrans_docnumber  = _ar.aropen_docnumber
-                AND
-                gltrans_doctype = 'CM'
-            ELSE
-                gltrans_docnumber = _ar.aropen_applyto
-                AND
-                gltrans_doctype = 'IN'
-            END
+            gltrans_docnumber  = _ar.aropen_docnumber
+        AND
+            gltrans_doctype = 'DM'
         AND
             gltrans_accnt_id = v_ar_accnt_id
         AND