CRM 2016 Quote Product Tax Bug

(0) Share

Report

Posted on by AXEON Man

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

All responses (7)

Answers (0)

Suggested answer

Pat Buskey 1,540 on at

Like (0)

Report

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 1,540 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: CRM 2016 Quote Product Tax Bug

I have the same issue, that is shown here: community.dynamics.com/.../764698
Community Member Microsoft Employee on at

Like (0)

Report

RE: CRM 2016 Quote Product Tax Bug

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:
Vassil on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 on at

Like (0)

Report

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?