International SQL-Ledger Network Association

User Tools

Site Tools

Trace:
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 revisionBoth sides next revision
update_fxpaid [2016/12/13 11:00] – sweitmannupdate_fxpaid [2016/12/13 11:19] – sweitmann
Line 6: Line 6:
    chart_id IN (SELECT id FROM chart WHERE link LIKE '%AP_amount%' OR    chart_id IN (SELECT id FROM chart WHERE link LIKE '%AP_amount%' OR
    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);
 +   
 +   UPDATE ar SET fxamount = (SELECT SUM(amount) FROM acc_trans WHERE
 +   chart_id IN (SELECT id FROM chart WHERE link LIKE '%AR_amount%' OR
 +   link LIKE '%IC_income%' OR link LIKE '%tax%') AND trans_id=ar.id and
    NOT fx_transaction);    NOT fx_transaction);
        
    UPDATE ap SET fxpaid = paid WHERE fxpaid is NULL;    UPDATE ap SET fxpaid = paid WHERE fxpaid is NULL;
 +   
 +   UPDATE ar SET fxpaid = paid WHERE fxpaid is NULL;
        
    UPDATE ap SET fxamount = fxpaid WHERE amount = paid;    UPDATE ap SET fxamount = fxpaid WHERE amount = paid;
update_fxpaid.txt · Last modified: 2016/12/13 11:57 by sweitmann