Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Tax and Extended Amount Calculation (Opportunity, Quote)

Posted on by 600

Hi All,

I have an odd one this time and any help is appreciated...

A customer provides discount per unity rather than per line item.  Very simple, there is a System Setting under Sales to have discounts applied per item:

system-setting.png

All the product prices are exclusive of any additional sales tax, and most products have a volume discount applied to them.

volume-discount.png

The issue is around Tax calculation and the Extended Amount.  When The tax field is populated (manually or via workflow calculation), instead of the Extended Amount going up by that amount, it actually goes down by that amount.  That would make sense if the price per unit was tax inclusive, but there is no where to specify this on the product or price line item.

invalid-extended.png

 If the System Setting for discounts is flipped back to "Line Item" the field is calculated as expected.  

valid-extended.png

Note that all of this is without actually entering a value into the discount, which means CRM didn't actually need to calculate a discount yet, either per line or per item, yet the extended amount is very different...

Anyone know how to fix this up? Am I missing anything?

*This post is locked for comments

  • Suggested answer
    Pat Buskey Profile Picture
    Pat Buskey 1,540 on at
    RE: Tax and Extended Amount Calculation (Opportunity, Quote)

    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 Buskey Profile Picture
    Pat Buskey 1,540 on at
    RE: Tax and Extended Amount Calculation (Opportunity, Quote)

    I am experiencing the same issue. Was this ever resolved? I have been searching for 2 days and haven't been able to figure out what is wrong or find a fix.

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

    Any thoughts or help would be greatly appreciated. Thank you,

    Pat

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans