web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GST appears to not be Calculating Correctly

(0) ShareShare
ReportReport
Posted on by 12

I have an invoice that I am matching to a PO and it works perfectly - all values agree to the penny - except for the GST / TAX

The total dollar value of the invoice line items is 9,321.81 and at 5% GST would be 466.0905

When I look at the number GP (2015 R2) presents, the GST is 466.1350

Now we are not going to lose it over .04 but the important question is why.

What we know:

There are 40 line items

All 40 have GST - same tax detail - attached

When I review each detail line I get a total of 466.135

Anyone have a suggest as to why and that can be explained to a client that is a little concerned about how the system works already and now we see this happening.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi Bill,

    I think what your seeing is the effect of the rounding option on the tax detail on a number of lines. GP will round the tax amount on each line, not on the transaction total, so it can make a difference to what you expect if you calculate the tax on the transaction total.

    If you go through and round the tax amounts for each line, based on the tax detail rounding option, it should come to a total of $466.1350.

    Cheers

    Rob

  • Bill Campbell Profile Picture
    12 on at

    Ok, so what you are saying is that the TAX that is presented below the subtotal is the 'rounded affected' amount and that when I calculate 5% on the subtotal it is the different value.

    I get this, so, question - is there a way to drop this - so that is does not round ???

    Thanks

  • Community Member Profile Picture
    on at

    Hi Bill,

    As far as I know there isn't a way to prevent this. There is no rounding option of do not round on the tax details and there is nothing in POP setup in relation to this either.

    Regards

    Rob

  • Bill Campbell Profile Picture
    12 on at

    Thanks Rob, just thought I would vent and ask at the same time.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans