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

index a81d546..cd33bdf 100644 (file)
@@ -139,8 +139,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,