pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index e96662c..a63a74d 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -122,13 +122,13 @@ BEGIN
     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;
+--         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
     
-        v_new_rate := _ar.aropen_amount / v_gltrans_amount;
+        v_new_rate := _ar.arapply_applied / v_gltrans_amount;
         
         RAISE NOTICE 'aropen_id  % change currency rate from % to %', i_aropen_id, _ar.aropen_curr_rate  ,v_new_rate ;