Skip to main content

Notifications

Microsoft Dynamics CRM forum

CRM 2016 Quote Product Tax Bug

Posted on by

I appears that the Quote Product Tax Calculation is broken.  To clarify, I noticed that on on both existing and write in products, the extended amounts were wrong if I took the effort to add line-item tax amounts within the quote form (which is ridiculous as a requirement).  The Extended Amount field subtracts the tax field from instead of adding the tax field to the amount field for a total.  This appears to me to be a clear bug -if I put a negative figure into the Tax field, the Extended Amount is correct.  Please feel free to test and confirm this in your environments -I'd love to know your experience and get this fixed my MS if it is indeed a bug.

Quote-Error.jpgQuote-Error-2.jpg

These are my examples -same results with write in or existing product.

*This post is locked for comments

  • Suggested answer
    Pat Buskey Profile Picture
    Pat Buskey 1,540 on at
    RE: CRM 2016 Quote Product Tax Bug

    For those interested or experiencing this issue, it appears that update 8.2.3.008 (released November 2018 for on-premise and online) fixes this issue.  Unfortunately, the KB article does not state that it fixes the issue which caused me to waste a lot of my time.

    support.microsoft.com/.../4467675

    Hope this helps anyone that runs across this issue.

    Pat

  • Pat Buskey Profile Picture
    Pat Buskey 1,540 on at
    RE: CRM 2016 Quote Product Tax Bug

    I am experiencing this same issue. Was this ever resolved? I really need per unit discounting to work properly.

    Version 1612 (8.2.2.112) (DB 8.2.2.112) on-premises

    Thank you,

    Pat

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM 2016 Quote Product Tax Bug

    I have the same issue, that is shown here: community.dynamics.com/.../764698

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM 2016 Quote Product Tax Bug

    finalamnt.png

    I'm currently calculating the Tax field with a Business Rule on Opportunity Product, Quote Product etc, as that seems the only way for the Tax to actually be added onto the Total Amount in an Opportunity

    You can see above the two custom fields I had to add to do this calculation after discount, as the Amount only applies the discount for (Quantity - 1) of the items in the line. (I've just tested this with a Quantity of 10, and the discount only applies to 9/10, leaving the Amount (1 * Discount) too high.)

    So the Total Line Discount is (Price Per Unit - Manual Discount), and Amount Less Discount is (Total Line Discount * Quantity) - then Tax is (Amount Less Discount * 0.10) for our Tax rate.

    EDIT: I should note that in our global settings, the manual discount is set to apply per unit, not per line.

    This means the total for this line is $4400.00 after Tax, but the Extended Amount is $3491.00.

    Originally I thought that the Extended Amount was being calculated by taking the Tax off of the full amount for the line, but seeing the above values, I have no idea what it's doing anymore.

    Note that the actual final amounts on the Opportunity are all correct, without any changes made to those fields - so these calculations are doing what I'd expect:

    finalamnt.png

  • Vassil Profile Picture
    Vassil on at
    RE: CRM 2016 Quote Product Tax Bug

    I tested it on CRM Online 2016 (8.1.0.369) (DB 8.1.0.359) and I cannot reproduce it. It seems to be working as expected

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM 2016 Quote Product Tax Bug

    I'm also seeing the same issue on our Dynamics 2016 Online service. What's weird is the total amounts calculated after the line items is correct - just the Extended Amount on the actual line item is incorrect.

    Did you find out a fix for this?

  • AXEON Man Profile Picture
    AXEON Man on at
    RE: CRM 2016 Quote Product Tax Bug

    Does the same for Opportunity Products in our 2016 On-Prem deployment.  Anyone else tested this and confirmed?

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

News and Announcements

Give Back to the Community this Month

Quick Links

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... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans