Purchase Order - Invoice Mismatch due to FX

(0) Share

Report

Posted on by Daniel H1

Hi,

We have a company with Accounting Currency and Reporting Currency of USD but a lot of expenses in Euro.

A lot of our purchase orders and invoices are created in Euro. When it comes to three-way matching between Euro invoices and Euro POs we are seeing a fail on the Price Total Match as D365 sees a difference in the reporting currency (USD) value due to the different FX rates on the date of the PO and the date of the invoice posting. Below is an example:

PO for value €169.50 dated 11/11/22 with FX rate 1.0308 for USD value $174.72

Invoice for value €169.50 dated 01/10/23 with FX rate 1.0723 for USD value $181.75

This leads to a Price Total Match fail due to the different USD amounts. Is there a way for the Price Total Match to occur based on the currency the PO and invoice are denominated in rather than the reporting/accounting currency?

Thanks

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Charlotte X on at

Like (0)

Report

Hi Daniel,

Please refer to this old thread, it mentions a similar problem to yours:

(+) Invoice matching problems with foreign currency - Microsoft Dynamics AX Forum Community Forum

Was this reply helpful? Yes No
Daniel H1 21 on at

Like (0)

Report

Thanks for this response Charlotte. That thread was very helpful.

Was this reply helpful? Yes No