pgsql/investigations/ar-debitmemo.sql
authorEdward <edward@roojs.com>
Wed, 5 Feb 2014 06:38:51 +0000 (14:38 +0800)
committerEdward <edward@roojs.com>
Wed, 5 Feb 2014 06:38:51 +0000 (14:38 +0800)
pgsql/investigations/ar-debitmemo.sql

index 9214fbc..243724f 100644 (file)
@@ -76,8 +76,7 @@ BEGIN
     SELECT
             gltrans_id,
             gltrans_amount * -1.0,
-            ROUND( _ar.aropen_amount / _ar.aropen_curr_rate, 3 ) - ROUND(gltrans_amount * -1.0, 3),
-            v_diff
+            ROUND( _ar.aropen_amount / _ar.aropen_curr_rate, 3 ) - ROUND(gltrans_amount * -1.0, 3)
     INTO
             v_gl_id,
             v_gltrans_amount,