Multiple sales tax on customer invoice

(0) Share

Report

Posted on by Community Member

I want to implement a scenario where 2 taxes will be applied on the customer invoice. I am generating invoice from sales order and there are no discounts in my scenario. How can i achieve this and configure in AX2012R3

Here is an example ,

Invoice amount = 1000
tax 1 = 5% of 1000 = 50
tax 2 = 10% of (1000+50) = 105
Total Invoice Amount = 1000+50+105 = 1155
Total Tax = 105+50 = 155

I am trying to configure multiple sales tax codes and add them in sales tax groups but unable to get the desired results

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (3)

Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

You may want to check if the use tax settings are properly configured or not. You can try and disable use tax and then see if the sales is getting calculated or not.

Was this reply helpful? Yes No
Suggested answer

Adineh Negahdari 807 on at

Like (1)

Report

Hi

From the calculation point of view, You can use one tax code and one charge code.

Because charges are applied after taxes are applied.

From financial point of view, it should be tested and reviewed.

Regards

adineh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

have you assigned this group to customer on sales order? then It should fetch associated tax code within that assigned tax group.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

I don't think you can apply this scenario .

If you check tax code origin , you can not find type to implement you scenario's , so as adineh mentioned you can can use charge code after calculate taxes

Was this reply helpful? Yes No
Suggested answer

Adineh Negahdari 807 on at

Like (0)

Report

Hi

Tax code is defined on customer. About charges code I should say Charges can be applied to both sales order line ond header.

Charges also can be configured automaticaly. So you need to set up a customer charges code and assigned that to customer. Alse a item charges code should be defined and assigned to item master data. If the charges or tax information does not changes alot, automatic cahrge code is very helpful. The account should be set too.

Else you need enter the amount manually on each Sales order.

Regards

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi,

Please try the following Setup:

Tax Code 1:

Tax Code 2:

Create a new sales tax Group and assign the codes

Add them to an item sales tax group

Create an invoice and check the sales tax

Best regards,

Ludwig

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

In the sales tax codes, have you set the %age from the values or you used the amount.

Secondly what are your calculation parameters to get the desired sales tax origin amount

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

That is how I setup the sales tax codes

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have also done the same configuration but the results are not same.

Can you explain me the amount/percentage fields, why you have put 5,00000 and 10,500000 instead of 5% and 10%

Was this reply helpful? Yes No
Fahad Safder 365 on at

Like (0)

Report

We put percentages themselves instead of the ratio.

Was this reply helpful? Yes No