International SQL-Ledger Network Association

User Tools

Site Tools

Trace: • rest_api_sales_orders
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:19] – sweitmannupdate_fxpaid [2024/09/25 06:21] (current) – external edit 127.0.0.1
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);
        
Line 21: Line 16:
    UPDATE ar SET fxamount = fxpaid WHERE amount = paid;       UPDATE ar SET fxamount = fxpaid WHERE amount = paid;   
        
-   + Ignore below  
        
        
update_fxpaid.1481627962.txt.gz · Last modified: 2024/09/25 06:19 (external edit)