pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index 6f4b2fc..8f61a96 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -107,6 +107,8 @@ BEGIN
             gltrans_accnt_id = v_ar_accnt_id
         AND
             gltrans_source = 'A/R'
+        AND
+            gltrans_doctype = 'CR'
         AND
             gltrans_journalnumber = _ar.arapply_journalnumber::integer;