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 revisionPrevious revision
Next revision
Previous revision
update_fxpaid [2016/12/13 10:53] sweitmannupdate_fxpaid [2016/12/13 11:57] (current) sweitmann
Line 2: Line 2:
    SELECT invnumber, amount, paid, fxamount, fxpaid FROM ap WHERE amount=paid AND fxamount <>     SELECT invnumber, amount, paid, fxamount, fxpaid FROM ap WHERE amount=paid AND fxamount <> 
    fxpaid AND fxpaid <> 0 OR fxpaid is NULL;    fxpaid AND fxpaid <> 0 OR fxpaid is NULL;
-    
-    
        
    UPDATE ap SET fxamount = (SELECT SUM(0-amount) FROM acc_trans WHERE    UPDATE ap SET fxamount = (SELECT SUM(0-amount) FROM acc_trans WHERE
Line 11: Line 9:
        
    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 ar SET fxamount = fxpaid WHERE amount = paid;       UPDATE ar SET fxamount = fxpaid WHERE amount = paid;   
        
-   + Ignore below  
        
        
update_fxpaid.1481626427.txt.gz · Last modified: 2016/12/13 10:53 by sweitmann