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

index 0124e29..539b08c 100644 (file)
@@ -76,8 +76,7 @@ BEGIN
     SELECT
             gltrans_id,
             gltrans_amount,
-            ROUND( _ar.aropen_amount / _ar.aropen_curr_rate, 3 ) - ROUND(gltrans_amount, 3),
-            v_diff
+            ROUND( _ar.aropen_amount / _ar.aropen_curr_rate, 3 ) - ROUND(gltrans_amount, 3)
     INTO
             v_gl_id,
             v_gltrans_amount,