1 ---quick way to set clearance..
3 -- call setbankreccleared()
5 CREATE OR REPLACE FUNCTION setbankreccleared(integer, text, integer, boolean)
9 pBankrecid ALIAS FOR $1;
11 pSourceid ALIAS FOR $3;
12 _cleared ALIAS FOR $4;
16 v_basecurr_id INTEGER;
23 SELECT bankrecitem_id, bankrecitem_cleared INTO _r
25 WHERE ( (bankrecitem_bankrec_id=pBankrecid)
26 AND (bankrecitem_source=pSource)
27 AND (bankrecitem_source_id=pSourceid) );
51 bankaccnt_accnt_id = gltrans_accnt_id
53 gltrans_id = pSourceid;
56 --RAISE NOTICE 'gltransid = %, bank cur =%, base_curr= % curr_rate = %', pSourceid, v_curr_id, v_basecurr_id, v_rate;
57 IF v_curr_id != v_basecurr_id THEN
58 SELECT currrate(v_curr_id, v_date) INTO v_rate;
60 --RAISE EXCEPTION 'gltransid = %, bank cur =%, base_curr= % curr_rate = %', pSourceid, v_curr_id, v_basecurr_id, v_rate;
62 INSERT INTO bankrecitem
63 (bankrecitem_bankrec_id, bankrecitem_source,
64 bankrecitem_source_id, bankrecitem_cleared ,
66 bankrecitem_curr_rate,
73 v_rate, abs(v_amount) * v_rate
78 SET bankrecitem_cleared=_cleared
79 WHERE (bankrecitem_id=_r.bankrecitem_id);
85 LANGUAGE plpgsql VOLATILE
87 ALTER FUNCTION setbankreccleared(integer, text, integer,boolean)