Sales tax calculation

(0) Share

Report

Posted on by Community Member 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

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 89 on at

Like (1)

Report

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 89 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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.