Announcements
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.
These are my examples -same results with write in or existing product.
*This post is locked for comments
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
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
I have the same issue, that is shown here: community.dynamics.com/.../764698
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:
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
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?
Does the same for Opportunity Products in our 2016 On-Prem deployment. Anyone else tested this and confirmed?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156