pgsql/fixes/x-dragon-trialbal-fix.sql

diff --git a/pgsql/fixes/x-dragon-trialbal-fix.sql b/pgsql/fixes/x-dragon-trialbal-fix.sql
index 0e5656a..30542fe 100644 (file)
--- a/pgsql/fixes/x-dragon-trialbal-fix.sql
+++ b/pgsql/fixes/x-dragon-trialbal-fix.sql
@@ -634,57 +634,6 @@ ALTER FUNCTION  trialbal_fix(i_id integer)
   OWNER TO admin;     
 
 
-
-
------- fetch the trial balance by period-----
-
- 
-CREATE OR REPLACE FUNCTION trialbal_byperiod(i_accnt_id INTEGER, i_date DATE)
-  RETURNS NUMERIC AS
-$BODY$
-DECLARE
-    v_balance NUMERIC;
-BEGIN
-
-    SELECT 
-            COALESCE(SUM( 
-                CASE WHEN accnt_type IN ('A','E') THEN  
-                        (trialbal_ending -  trialbal_beginning)   * -1
-                 ELSE 
-                        trialbal_ending -  trialbal_beginning 
-                 END
-             ), 0.0)
-    INTO
-            v_balance
-    FROM 
-            trialbal
-    
-    LEFT JOIN 
-            accnt
-    ON
-            accnt_id = trialbal_accnt_id
-    LEFT JOIN 
-            period
-    ON
-            period_id = trialbal_period_id
-    
-    WHERE
-            period_start <= i_date
-        AND
-            trialbal_accnt_id = i_accnt_id;
-
-    RETURN v_balance;
-    
-
-END;
-$BODY$
-  LANGUAGE plpgsql VOLATILE
-  COST 100;
-ALTER FUNCTION  trialbal_byperiod(INTEGER, DATE)
-  OWNER TO admin;     
-
-
-
 ------ fetch the trial balance by period END-----