Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Sales tax calculation
Finance forum

Sales tax calculation

Posted on by 11,721

Dear Experts,

I am working on ME region where system default currency is BHD. The sales tax code has been setup as per the following. For example; sales tax code IM-RE.

Sales-tax-code.JPG

Now while creating a General journal, based on the combination of item sales tax group and sales tax group; tax code IM-RE has been recorded with appropriately calculated tax amount. For example; in below screen shot, the Debit amount is BHD 5.263 and tax is calculated 5% which is (5.263 * 5%) = 0.265 which is nearest to 5 Fils as per the setup in tax code.

6518.1.JPG

Now to balance the voucher, an additional line is created with same tax groups with Debit amount of BHD 10.687. But this time system is calculating tax as (10.687 * 5%) = 0.536 which is ideally should be rounded to nearest 5 Fils as 0.535 !!

6518.2.JPG

Also, after this line is created, the sales tax value on the amount BHD 5.263 is changed from 0.265 to 0.264 !!

0333.3.JPG

The rounding rule in BHD currency is set as per the following.

0333.4.JPG

All above setups have been done as per the requirement of the client company. Tax code setups also done as per Country specific rules.

Am I missing anything in tax code setup calculation which is causing this difference?


Best regards,
Sourav Dam

  • SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Sales tax calculation

    Hi Ludwig,

    Thank you for this information.

    We have replaced Net amount of invoice balance with Net amount per line and posted invoices. Sales tax is calculating properly this time :)

    Best regards,

    Sourav Dam

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales tax calculation

    Hello Sourav Dam,

    Your sales tax calculation is based on the 'net amount of the invoice balance'.

    It is not calculated on an individual line bases with this setup.

    Can you modify this calculation setup and test again?

    Best regards,

    Ludwig

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans