pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index 2499242..11e52e8 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -110,10 +110,18 @@ BEGIN
         AND
             gltrans_doctype = 'CR'
         AND
-            gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber
+            gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber;
             
 
+    IF NOT FOUND THEN
+    
+        IF _ar.arapply_applied = 0.00 THEN
+            RAISE NOTICE 'skip arapply, zero dollar';
+            RETURN 'SKIP';
+        END IF;
     
+        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;