Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Adding tax on Quote form

Posted on by

Hi

I am trying to apply tax on my quote. I am fine to add lumpsum tax inot totaltax field on quote form or tax on quote lines items/products. But i want tax to be calculated automatically based on a certain percentage defined for price list.

I tried various options line Business Rules and Custom Script. I am able to get calculations done very well calculated tax value in totaltax field is not getting saved since totaltax field is locked. i tried to unlock it but no success. 

Please advice what i am doing wrong. Does totaltax not editable since it is a rollup field from manualtaxamount field of quoteproduct entity?

I am using Dynamics 365 Sales.

*This post is locked for comments

  • Verified answer
    Piotr Kerner Profile Picture
    Piotr Kerner 285 on at
    RE: Adding tax on Quote form

    Hi,

    rollup fields are calculated automatically, so you cannot update them manually.

    You would need a modify the tax field on quote products, and then everything would be calculated on the Quote correctly. If you are not using quote products, you might create one (technical) quote product hide it from the users via customiations and perform calculations on that line.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adding tax on Quote form

    Having same Issue here, looking forward to the answer to this question

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