pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index 681cb7f..3a011e7 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -110,7 +110,9 @@ BEGIN
         AND
             gltrans_doctype = 'CR'
         AND
-            gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber;
+            gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber
+        AND
+            gltrans_journalnumber = _ar.arapply_journalnumber;
             
 
     IF NOT FOUND THEN