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 revision		Previous revision
Next revisionBoth sides next revision
update_fxpaid [2016/12/13 10:59] – 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