Exchange rate of the previous day applied

(0) Share

Report

Posted on by obaech

Hello,

I have an issue with the exchange rate applied to a posted purchase invoice. The document was created and posted on the 22/04/2022. The exchange rate that was applied was the rate of the previous day (21/04/2022). We are using the automatic exchange rate update. I have checked the job queues and they have run successfully each of those days. Any idea why the exchange rate of the posting date was not applied?

Thanks for your feedback.

Best regards

Omar

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Alfredo_Iorio 1,264 on at

Like (1)

Report

Hi.

It might be because of a user error.

I see the document date is 01/04. Could it be that the original posting date was 01/04 and then it got changed?

If yes, the user should have seen a prompt to update the Exchange Rate

If they clicked no, the rate would have remained the old one.

Was this reply helpful? Yes No
obaech 30 on at

Like (0)

Report

Dear Alfredo,

Thanks for your feedback. I looked at the "SystemCreatedAt" field of the posted sales invoice and it was on 22/04/2022. So the user probably entered a document date in the past.

Best regards

Omar

Was this reply helpful? Yes No
Alfredo_Iorio 1,264 on at

Like (0)

Report

The "system created at" field shows the date when the posted invoice was created.

The currency rate is stamped on the sales header.

You need to find the sales order that created the posted invoice and see the posting date of the original document.

Was this reply helpful? Yes No
obaech 30 on at

Like (1)

Report

I think you were right about the posting date being changed.

This is probably what happened:

• The invoice was entered by accident with previous date

• The date was corrected to the right date

• The first popup appeared mentioning “You have changed….”

• Then the second popup "Do you want to update the exchange rate" appeared. (This popup is often not expected)

• The OK button of the first popup is at the same position as the “No” button of the second popup.

• So if the user was in a hurry he probably clicked twice at the same cursor position and accidently said “no” to update the exchange rate.

Was this reply helpful? Yes No