Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Tax doesn't calculate?

(0) ShareShare
ReportReport
Posted on by 20

. Apparently "out of the box" Dynamics does not calculate tax. I have dedicated products to be taxable and set a tax rate. When I generate a quote it will calculate the detail amount and add freight but tax is "locked" and doesn't populate. So, I created a Quote business rule that if "detail amount" contains data then set "Total Tax" to "Pre-Freight amount * .07". The rule works to populate "Total Tax Amount" on the quote screen, however, it does not factor into the "Total Amount". So, I created another Quote Business rule if "total tax" has data the "Total Amount" is "Total Amount + Total Tax". This rule also works to populate "Total Amount" with the correct math (Detail amount+freight+tax= TOTAL). My hang up is when I export the quote to a word template....Total Tax remains $0.00.

Any help to correct this issue would be greatly appreciated

.Screenshot_5F00_10.jpg

Screenshot_5F00_11.jpgScreenshot_5F00_12.jpg

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Tax doesn't calculate?

    Hi partner,

    The Quote "Total Tax" is calculated by the sum of all Quote Line "Tax". The calculation is not directly derived at the Quote level.

    pastedimage1580708011600v1.png    pastedimage1580708034180v2.png  

    Even if you revalue "Total Tax" and "Total Amount" by business rules, this is just what the front end shows.

    Simply modifying any of the fields in Quote Line causes all of the related fields in Quote to be recalculated, which is at the back-end level and avoids business rules. Exporting as a word template also causes all fields to be recalculated, which is why the business rules are invalid.

    So, to solve this problem, you have to assign a value to "Tax" at the Quote Line level.

    Solution: You could create business rules on the Quote Line form to calculate the value for "Tax" and thus affect the value of "Extended Amount".

    pastedimage1580709702281v3.png

    This allows "Tax" to participate in the calculation of "Total Amount" without affecting the calculation logic of Quote itself.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans