pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index 3a011e7..4ec42b0 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -112,7 +112,7 @@ BEGIN
         AND
             gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber
         AND
-            gltrans_journalnumber = _ar.arapply_journalnumber;
+            gltrans_journalnumber = _ar.arapply_journalnumber::integer;
             
 
     IF NOT FOUND THEN