pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index d915efc..11ffb99 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -112,7 +112,9 @@ BEGIN
         AND
             gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber
         AND
-            gltrans_journalnumber = _ar.arapply_journalnumber::integer;
+            gltrans_journalnumber = _ar.arapply_journalnumber::integer
+        AND
+            gltrans_misc_id = _citem.cashrcptitem_cashrcpt_id;
             
 
     IF NOT FOUND THEN
@@ -125,9 +127,9 @@ BEGIN
         RAISE EXCEPTION 'arapply is missing gltrans in A/R account arapply_ud=%' ,i_arapply_id;
     END IF;
     
-    IF (v_gl_misc_id IS NULL) THEN
---         UPDATE gltrans SET gltrans_misc_id = _citem.cashrcpt_id WHERE gltrans_id = v_gl_id;
-    END IF;
+--     IF (v_gl_misc_id IS NULL) THEN
+-- --         UPDATE gltrans SET gltrans_misc_id = _citem.cashrcpt_id WHERE gltrans_id = v_gl_id;
+--     END IF;
     
     -- if currency rate is off...
     IF v_diff != 0.00  THEN