Finance | Project Operations, Human Resources, ...

Different exchange rate (Purchase Invoice vs. TaxTrans)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

The user posted a Vendor Invoice with exchange rate 122.03:

Transaction in VendInvoiceJour and VendInvoiceTable have been reflected with the exchange rate 122.03. This exchange rate has been put manually by the user when posted the Invoice.

Meanwhile the transactions in TaxTrans Table have been reflected with another exchange rate, the daily exchange rate that is generated by the provider.

Why does this happen?

Thanks,

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Different exchange rate (Purchase Invoice vs. TaxTrans)

Hello Ludwig,

yes, the last voucher is related to this purchase invoice and the exchange rate is correct in the voucher.

at the time of the posting, the parameter in GL had been set up to invoice level. Since we were having some problems with the calculations for service items, we changed it to line level. However the change has been made long after the posting of this document.

We operate on AX 2012 R3, CU 10.

thanks,

Irida
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Different exchange rate (Purchase Invoice vs. TaxTrans)

Hi Iridia,

Is the last voucher one that is related to a purchase order and has the exchange rate change between the time the packing slip and the invoice has been posted?

Another thing that I would like you to check is how the sales tax calculation has been configured. In the GL parameters form there is a parameter that allows calculating sales tax at the invoice or line level. What has been selected in your case.

Finally, I would like to know what AX2012 version you operate exactly? Is it R2/R3 and what CU is implemented?

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Different exchange rate (Purchase Invoice vs. TaxTrans)

Hello Ludwig,

We corrected the original invoice. here is another case with the same problem.

The original document is the Purchase invoice with an exchange rate of 124.26.

For the same invoice, in tax trans table we have the following values, which have an exchange rate of 124.69.

Here you can find the voucher.

thanks,

Irida
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Different exchange rate (Purchase Invoice vs. TaxTrans)

Hello Irida,

Have you been able to get your issue resolved in the meantime or is there some additional help/support required?

Best regards,

Ludwig
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Different exchange rate (Purchase Invoice vs. TaxTrans)

Hello Irida,

I cannot see this difference from the screenshot that you provided. Can you make another one of the voucher where you show the exchange rate and also from the transaction origin form.

If there are really different rates used then the voucher should not balance in my opinion.

Best regards,

Ludwig