International SQL-Ledger Network Association

User Tools

Site Tools

Trace: • find_arap_outofbalance • sql-ledger_consultants
update_fxpaid

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
update_fxpaid [2016/12/13 11:35] – sweitmannupdate_fxpaid [2024/09/25 06:21] (current) – external edit 127.0.0.1
Line 7: Line 7:
    link LIKE '%IC_expense%' OR link LIKE '%tax%') AND trans_id=ap.id and    link LIKE '%IC_expense%' OR link LIKE '%tax%') AND trans_id=ap.id and
    NOT fx_transaction);    NOT fx_transaction);
 +   
 +   UPDATE ap SET fxpaid = paid WHERE fxpaid is NULL;
        
    UPDATE ar SET fxpaid = paid WHERE fxpaid is NULL;    UPDATE ar SET fxpaid = paid WHERE fxpaid is NULL;
update_fxpaid.1481628941.txt.gz · Last modified: 2024/09/25 06:19 (external edit)