Finance | Project Operations, Human Resources, ...

Sales tax settlement rounding error

(0) Share

Report

Posted on by CapsLock

1,419

Hi,

I'm getting this error when trying to settle sales tax for January: "Error in unit of amount in currency "XX". Must be rounded to 0.01". "The unit of... being posted is outside the current penny rounding threshold".

We updated the rounding rules and penny differences to 0.01 but we are still getting the same message.

I have seen in this discussion thread:

(+) VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing. - Dynamics 365 Finance Forum Community Forum

That there was a bug in the system causing this and Microsoft launched the fix back in November 2020. So I am assuming that if we didn't have the error until now, January 2021, it must not be related to the fix? Or could it be related anyway?

Thanks!

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

I can add some input here.

You can run this script to fix this issue, if it works, let me know.

--confirm corrupted data number is correct

select dataareaid, count(*) from TAXTRANS

where TAXINCOSTPRICEREP != round(TAXINCOSTPRICEREP, 2)

group by dataareaid

--Fix data

update TAXTRANS set TAXINCOSTPRICEREP = TAXINCOSTPRICEMST

where TAXINCOSTPRICEREP != round(TAXINCOSTPRICEREP, 2)

--If only want to fix data for some company, use below script and change 'xxx','yyy' to specific company name

update TAXTRANS set TAXINCOSTPRICEREP = TAXINCOSTPRICERMST

where TAXINCOSTPRICEREP != round(TAXINCOSTPRICEREP, 2) and dataareaid in ('xxx','yyy')

Was this reply helpful? Yes No
Suggested answer

Sheela Ningappa Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

We have a known issue caused by this bug below and this is causing the rounding error when running settle and post sales tax:

Details for issue 530501 (dynamics.com).

If the above fix is installed and still if you are facing the issue, you have the feature "Sales tax conversion"- Please disable the feature and check.

Thanks,

Sheela

Was this reply helpful? Yes No