pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index 30ac9f2..09c262b 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -108,7 +108,7 @@ BEGIN
         AND
             gltrans_source = 'A/R'
         AND
-            gltrans_journalnumber = _ar.arapply_journalnumber;
+            gltrans_journalnumber = _ar.arapply_journalnumber::integer;
             
 
     IF NOT FOUND THEN