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:53] – sweitmann | update_fxpaid [2024/09/25 06:21] (current) – external edit 127.0.0.1 |
|---|
| 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 |
| | |
| 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 |
| | |
| | |
