Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Sales Discount & Sales Tax: How to exclude discount from calculated tax?

Posted on by Microsoft Employee

We are faced with a situation where we need to omit the discount given to certain products from being included in the tax calculations. Example:

- we have a product with a sale price of 100

- the tax is 13%

- we want to give the customer a 10% discount, but we have to maintain the 13% tax amount 

what we managed to find in the system is that any discount given on the item line will affect the tax calculated. Some suggested to put the tax on the sales order rather than the item line, but we need to be able to know which items were sold with discount. 

So, our scenarios that we are looking for (from best to least working) are as follows:

1. a setup that will allow us to give discounts on certain products (on the line level) without affecting the tax

2. a setup that will allow us to give a discount on the entire sales order but will distribute the discount amount on the items (some sort of linking the discount to the items - and apologies for me not being accounting savvy, i am yet to take my AX Financial courses!!!)

3. a setup that will allow us to add the discount on the sales order and without affecting the tax amount imposed on the item's original price

Note: we are not using any retail modules and all sales are done through the Accounts Receivable - Sales Orders

Help is very much appreciated!

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    Hi Eduardo

    Is that a common business practice and in line with the tax rules in your country to have sales tax calculated on the amount before discounts? is that a cash discount? can you possibly provide some additional information on that? thanks

    ludwig

  • Eduardo Yambao Profile Picture
    Eduardo Yambao 5 on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    Got the same issue. Need to to exclude calculation of discount from calculated tax.

    Did you found solution?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    HI,

    We go the same requirement where we are using AX POS at retail outlets, where we have to distribute the discounted amount to all Items evenly. As of now it seems that it requires some customization. Wondering if this thing available in any updates.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    We ended up setting up the discounts as charges which are linked to specific accounts in the chart of accounts so that they affect the cost price of the sold / purchased items.

    I will update this post with the exact details of our setup.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    Sales tax is setup as follows (and we have tried different combinations):

    Origin:   Percent of net amount (and we have also gross)

    Marginal: Net amount of invoice (and we have tried net amount per line and gross per line)

    Calc method:  Whole amount

    all of these, any discount put on the line level, affects the tax calculated

    We have not tried the discounts on the header level

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Discount & Sales Tax: How to exclude discount from calculated tax?

    Hi,

    For 1 and 3:

    How did you setup your sales tax codes? What have you setup in the calculation tab for the origin, marginal base and calculation method? Have you tried modifying those setups?

    For 2:

    Do you make use of total / line / multiline discounts that can be setup at the SO header level? Have you already set them up or tried setting them up?

    Best regards,

    Ludwig

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