pgsql/investigations/ar-cash.sql

diff --git a/pgsql/investigations/ar-cash.sql b/pgsql/investigations/ar-cash.sql
index d8e305c..f333d76 100644 (file)
--- a/pgsql/investigations/ar-cash.sql
+++ b/pgsql/investigations/ar-cash.sql
@@ -132,7 +132,7 @@ BEGIN
     
         v_new_rate := _ar.arapply_applied / v_gltrans_amount;
         
-        RAISE NOTICE 'arapply_id  % change currency rate from % to %', i_arapply_id, _citem.cashrcpt_curr_rate  ,v_new_rate ;
+        RAISE NOTICE 'arapply_id  % change currency rate from % to %, applied % gl amount %', i_arapply_id, _citem.cashrcpt_curr_rate  ,v_new_rate,_ar.arapply_applied,v_gltrans_amount ;
     
 --         UPDATE 
 --                 aropen