Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| update_fxpaid [2016/12/13 10:50] – sweitmann | update_fxpaid [2016/12/13 11:57] (current) – sweitmann |
|---|
| | |
| | SELECT invnumber, amount, paid, fxamount, fxpaid FROM ap WHERE amount=paid AND fxamount <> |
| | 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 |
| 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 |
| | |
| 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 ap SET fxamount = fxpaid WHERE amount = paid; | UPDATE ap SET fxamount = fxpaid WHERE amount = paid; |
| |
| SELECT invnumber, amount, paid, fxamount, fxpaid FROM ap WHERE amount=paid AND fxamount <> | |
| fxpaid AND fxpaid <> 0; | |
