pgsql/investigations/ar-cash.sql

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