Microsoft Dynamics AX (Archived)

How do I fix the vat calculation

(0) Share

Report

Posted on by AngelAX

245

Good Day

I have a Purchase requisition which is calculated as GBP -Pound.

We are using rands, but we have other currencies that are used.

The pound exchange rate is correct.

The amount is 9650 pounds and the vat is calculated at 15%. The vat amount should be 1447.5

The screenshot below shows that the vat is 1456.16.

Please assist

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi AngelAX,

Can you share some setup information about your Tax parameters and the Tax Code used for this 15%? I do see there is only one line on this requisition, correct?

Was this reply helpful? Yes No
AngelAX 245 on at

Like (0)

Report

Hi Andre

Yes there is only one line.

Kindly see below:

Was this reply helpful? Yes No
André Arnaud de Cal... 301,156 Super User 2025 Season 2 on at

Like (0)

Report

Hi AngelAX,

From the requisition line, there is a menu item (Financial > Sales Tax) which shows the details for the line. Can you share what information is on that form?

Was this reply helpful? Yes No
AngelAX 245 on at

Like (0)

Report

Hi Andre

I do not have a menu for Financial that has Sales Tax, but I found these details of the line. Will this help?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

If you select the currency in the first screen to Rand, what do you see? Do the amounts and % match in Rand?

And, as Andre already mentioned, can you open the sales tax code form and click on the value button on top of that form. What do you see there?

Would be great if you could share.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

AngelAX 245 on at

Like (0)

Report

Dear Ludwig \Andre

I spoke to our finance division after finding a previous PR that has GBP and the vat amount was also incorrect. They informed me that it is calculated based on the rate on that day.

Therefore the exchange rate needs to be changed to the invoice date, in order for the amount to be the same.

Thank you for your assistance

Kind Regards

Angel AX

Was this reply helpful? Yes No
Suggested answer

Vat Calculator 5 on at

Like (0)

Report

How to calculate VAT online?

Hi

Now You become able to Calculate Value added tax using Online platForm Such as

www.vatcalculator.info/

Was this reply helpful? Yes No