pgsql/investigations/ar-cash.sql
authorEdward <edward@roojs.com>
Wed, 5 Feb 2014 07:22:25 +0000 (15:22 +0800)
committerEdward <edward@roojs.com>
Wed, 5 Feb 2014 07:22:25 +0000 (15:22 +0800)
pgsql/investigations/ar-cash.sql

index 11ffb99..052900c 100644 (file)
@@ -112,9 +112,7 @@ BEGIN
         AND
             gltrans_docnumber = 'I-' || _ar.arapply_target_docnumber
         AND
-            gltrans_journalnumber = _ar.arapply_journalnumber::integer
-        AND
-            gltrans_misc_id = _citem.cashrcptitem_cashrcpt_id;
+            gltrans_journalnumber = _ar.arapply_journalnumber::integer;
             
 
     IF NOT FOUND THEN