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
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
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"
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156