User Tools

Site Tools


update_fxpaid

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
update_fxpaid [2016/12/13 11:35]
sweitmann
update_fxpaid [2016/12/13 11:57] (current)
sweitmann
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.txt ยท Last modified: 2016/12/13 11:57 by sweitmann