query_2:correct_ar8percision
This is an old revision of the document!
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.1590133344.txt.gz · Last modified: 2024/09/25 06:19 (external edit)