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

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Tax and Extended Amount Calculation (Opportunity, Quote)

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Pat Buskey Profile Picture
    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

  • Suggested answer
    Pat Buskey Profile Picture
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans