Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Sales tax calculation

(0) ShareShare
ReportReport
Posted on by

I have numerous Tax Detail IDs set up to calculate the sales tax for the various jurisdictions in California. As a result , most taxable sales have taxes calculated three times.

All of the Tax Detail IDs have the round set to "To the Nearest Currency Decimal Digit"

Yet, I frequently find that the calculation does not round as expected:

For example: today I have an invoice that on the Sales Tax Summary Entry window it shows Total Taxable Sales of $607.22; Percent/Amount of 1.00000% and Tax Amount of $6.08 (actual calculation is $6.0722 which should round to $6.07)

On this same invoice, I have another tax detail, again showing Total Taxable Sales of $607.22; Percent/Amount of 6.50000% and Tax Amount of $39.48 (actual calculation is $39.4693 which should round to $39.47).

This is not an exception occurrence but happens frequently.

Yes I could change the "Round" option  to "Down to the Previous Currency Decimal Digit" but I do not want to consistently undercharge my customers. Besides if the calculation is not correct on the other "Round" option, why should it be correct on this one.

Any fixes?

 

*This post is locked for comments

  • RE: Sales tax calculation

    Thank you, Kirk. That does appear what is happening. I apologize for not having thought to look at this on a more granular level.

    Thank you again.

    Don Johnson

  • Verified answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Sales tax calculation

    Hi Donald,

    What do you end up with if you calculate the sales tax and perform the rounding on each line item? I believe this is how GP calculates sales tax which would cause what you are describing.

    Regards,

    Kirk

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…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans