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 :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Tax on a product
Microsoft Dynamics CRM (Archived)

Tax on a product

(0) ShareShare
ReportReport
Posted on by Community Member

I know it is probably a simple thing but CRM is new to us and I can not find where to add different tax rates to different products when creating an invoice.

Any help would be appreciated.

Thanks,

Carl.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    Not an area I am too familiar with but I believe you have to enter tax manually by default. You could add a tax rate field and then using jscript/c# calculate dynamically the amount that you should pay tax per item. As long as you update the right fields ie ordertax then it will roll up from the products to the opp/order/quote/invoice

    community.dynamics.com/.../127690 - Similar query

    stackoverflow.com/.../crm-plugin-to-calculate-tax - c# code to calc

  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    Andrew, from all the reading I have done I think you are correct but I don't know where to enter tax manually as part of the process. I can't find a field or form that says Tax, or enter Tax here.

    Thanks,

    Carl.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    community.dynamics.com/.../127690 -

    Follow this guide and it will show that it is entered on the opportunity product/quote product etc page. IE In the product linked to that record.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    community.dynamics.com/.../127690

  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    If it is not there then check to see if there have been any customisations to hide the field from the UI.

  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    Thank you for the help, I see it now.

    Do you know is it possible to have it work out the Tax based on a percentage of the unit price rather than having to manually work out the tax on each line and add it in?

    With a large quote this could be very cumbersome and time consuming!

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at
    RE: Tax on a product

    Hi Carl,

    It should be inside the Invoice product, you cant find it?

  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    Hi, I did thank you.

    I was disappointed to find that we had to work out the tax manually and apply it to each product. We put up 30 or 40 quotes per week with 20 or 30 lines in each and this is really slow... I have been looking on line and in forums for a solution for 2016 to allow tax codes or some sort of automated way to do this based on a percentage.

    Do you have any suggestions?

    Thanks,

    Carl.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    You can then create a calculated field http://www.powerobjects.com/2014/11/17/calculated-fields-in-dynamics-crm-2015/ that you can work out the tax based on the unit amount. (You can either have a static 20% and then update if it changes or have a field that is defaulted to 20 and use that field in the calculation). I would have that as a hidden field, then what you can do is set the out of the box tax field to the value of your calculated field. This can be done using business rules or jscript which ever you feel more comfortable with.

    Hope that helps.

  • Community Member Profile Picture
    Community Member on at
    RE: Tax on a product

    Worth mentioning you need the out of the box field so that the rolled up value can be calculated for the overall invoice etc

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Wayne Walton Profile Picture

Wayne Walton 2

#2
Good.Panos Profile Picture

Good.Panos 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans