Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

(0) ShareShare
ReportReport
Posted on by 16

Dear Experts

I am having a VAT settlement error while running this periodic task this month. This has happened after the upgrade to 10.0.12. the issue is that it throws up 100 of lines of accounting currency to reporting currency balancing error.

Please advice if there are any Hot fixes for this or any other solution to overcome. 

regards

PS

  • Suggested answer
    MhaU Profile Picture
    on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Pravin,

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

    fix.lcs.dynamics.com/.../Details

    Please create a support ticket with Microsoft if you experience this in PROD.

  • Suggested answer
    MhaU Profile Picture
    on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Pravin

    I have seen a similar request caused by customization, extension of a class to accept 3 decimals. This is why a support request logged would best clarify the error message and root cause.

    Is the sales tax authority setup with vendor account? If so, then could you clear this from the  sales tax authority setup and then run the report again?

  • Suggested answer
    MhaU Profile Picture
    on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Pravin

    Thank you for your update.

    I am looking for more details about this, it might have been deprecated, I will come back to this thread when I have more details.

    Meanwhile the error that you get, have you tried the suggested step, another option is to try to change Maximum penny-rounding in the reporting and to see how the voucher is posted. Also, is you look at the rounding error, is this accurate?

  • praveens007 Profile Picture
    16 on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Mihaela

    i got stuck here

    Enable the calculation of VAT exchange rates by turning on the Bank exchange rate parameter, and by defining sales tax receivable and sales tax payable exchange rate types, at General ledger > Ledger setup > General ledger parameters.

    I could not find it in the Ledger Parameter.

    regards

    Pravin

  • praveens007 Profile Picture
    16 on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Mihaela

    I will follow and check with my Technical consultants managing it.

    Thank you once again for providing support.

    B/regards

    PS

  • Suggested answer
    Ramit Paul Profile Picture
    22,375 Most Valuable Professional on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Hi,

    Please check the above comment from Mihaela Ursu, she is from MS and provided the LCS number.

    Please validate the same.

  • praveens007 Profile Picture
    16 on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Ramit

    have raised it with MS already. Its been now more then 2 weeks no solution yet.

    regards

    PS

  • Suggested answer
    MhaU Profile Picture
    on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear PS

    Thank you for logging this issue with us.

    I was able to find something already reported but as I see the fix is included in 10.0.12, is it Issue 437664.

    Another option is to try to change Maximum penny-rounding in the reporting and to see how the voucher is posted. Also, is you look at the rounding error, is this accurate?

    Please also check this LCS issue, it has a final disposition from development team Issue 481880 

    If none of the above are helpful, please log a support request to have a look at the error message and data for a more effective troubleshooting.

     

  • Suggested answer
    Ramit Paul Profile Picture
    22,375 Most Valuable Professional on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Alright,

    And it was okay before that upgrade?

    I can not find specific to this one in LCS.

    If this was working and without changing any confg in 10.0.12 if it is coming, you should report this to MS.

    We have never seen this in 10.0.12.

    Update us.

  • praveens007 Profile Picture
    16 on at
    RE: VAT Settlement Error due to Accounting Currency and Reporting Currency not balancing.

    Dear Ramit

    it is coming for all Entities. I am running now for UAE.

    regards

    PS

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,044 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans