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

index 7b0c830..0c2d510 100644 (file)
@@ -67,22 +67,6 @@ 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..