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
Next revision
Previous revision
update_fxpaid [2016/12/13 11:22]
sweitmann
update_fxpaid [2016/12/13 11:57]
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;
Line 14: Line 16:
    UPDATE ar SET fxamount = fxpaid WHERE amount = paid;       UPDATE ar SET fxamount = fxpaid WHERE amount = paid;   
        
-   + Ignore below  
        
        
update_fxpaid.txt ยท Last modified: 2016/12/13 11:57 by sweitmann