Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Sales tax calculation

Posted on by Microsoft Employee

Hi All,

I raised a sales order with 4 lines and the sales tax is not calculating properly. There is always a difference in rounding and there is a difference in the total value of sales tax. When we analysed the code we found that sales tax is calculated and then the same is apportioned between the 4 lines based on the values.

I want to have sales tax calculated line wise and the order wise.

Please correct me if i am wrong.

Regards

Narayan Seshaddri

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales tax calculation

    Hi,

    Thanks for the reply

    Now i have set the "Marginal Base"as Net amount per line as specified above and the rounding is coming except for the company currency. For other currency like transaction currency the rounding is working properly for 4 digits. But when i look the Invoice journal and in Posted sales tax screen the company currency is not getting rounded off to 4 digits.

    Regards

    Narayan Seshaddri

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 84 on at
    RE: Sales tax calculation

    I double checked that and I can confirm.

    This is not a "defect" but simply 2 different options to calculate VAT or sales tax.

    You can calculate the tax on the invoice total.  In such case, due to rounding of amounts to 2 decimal points, the tax amount calculated is not exactly the total of what calculated for each line. In such case - Dynamics AX will adjust the line with the highest amount up or down several cents so the total tax of all lines is the total tax recorded.

    The setup to achieve that:

    On tax code definition, the "Marginal Base" is set to "Net Amount by Invoice Balance"

    You can calculate the tax on each line separately. In such cases, due to the same rounding, when you look at the total tax charged on the order, it will not be exactly the invoice total x tax percentage.

    The setup to achieve that:

    On GL parameters form: Calculate Tax "By Line"

    On tax code definition, the "Marginal Base" is set to "Net Amount per Line"

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 84 on at
    RE: Sales tax calculation

    I believe this is controlled by how you set up your Sales Tax codes.

    On the sales tax code, calculation tab,

    Marginal Base --> Net Amount per Line

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales tax calculation

    Hi,

    Thanks for the reply,

    But the calculation method is Line here but when i calculate the tax it is comming as below

    For ex : My invoice value is 100, total sales tax to be calculated is 10 but calculating as 8.5 the rounding off is 0 in currency master and 0 in sales tax .

    Regards

    Narayan Seshaddri

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,134 Super User 2024 Season 2 on at
    RE: AX 2012 R3

    Hi Narayan,

    There is a setup where you can indicate if the tax should be calculated per line or in total. It is set to line, it will calculate and round per line. The total invoice amount is not considered then.

    If it is set to total, initially per line the tax will be calculated and rounded. Also a total will be calculated and rounded. If there is a difference between the total and the cumulation of the lines AX will correct this on one of the lines.

    Is this the answer to your question? If not, please provide examples.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans