query_2:correct_ar8percision
Two queries:
UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE amount - paid BETWEEN 0.00001 AND 0.009;
and
UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE paid - amount BETWEEN 0.00001 AND 0.009;
query_2/correct_ar8percision.txt · Last modified: 2020/05/22 07:42 by sweitmann