pgsql/investigations/ar-creditmemo.sql
authorEdward <edward@roojs.com>
Tue, 4 Feb 2014 10:11:06 +0000 (18:11 +0800)
committerEdward <edward@roojs.com>
Tue, 4 Feb 2014 10:11:06 +0000 (18:11 +0800)
pgsql/investigations/ar-creditmemo.sql

index 058d600..0124e29 100644 (file)
@@ -67,23 +67,7 @@ BEGIN
             araccnt_id ASC
         LIMIT 1;
 
-    
-    
-    SELECT
-            salesaccnt_sales_accnt_id,      --135
-            salesaccnt_credit_accnt_id   -- 121
-            -- salesaccnt_cos_accnt_id
-        INTO
-            v_sales_accnt_id,
-            v_credit_accnt_id
-            -- v_cos_accnt_id
-        FROM
-            salesaccnt
-        ORDER BY
-            salesaccnt_id ASC
-        LIMIT 1;
-
-                    
+         
     -- we now have the base amount..
     
     --- Bank receipt should be exactly this amount.