Foreign Currency Revaluation - AR

(1) Share

Report

Posted on by praveens007

Dear members

I have a very peculiar issue here with the revaluation of Invoices in Foreign Currency.

I had invoice which was raised in EUR in April 24

- Revaluation for April and May went off well.

- Before I did the revaluation for June, I settled the invoice on July 2nd

- Then I ran the Revaluation for Jun'30. When I did that there was a huge amount which came in June under gain/loss. But in July it is reversing that amount also. But my June numbers go for a toss.

Can someone please let me know if they had a similar issue or are there any rules that the settlement should be done only after the Revaluation.

Any help/adivce will be great help and KB.

regards

I have the same question (0)

All responses (7)

Answers (0)

Sort by

André Arnaud de Cal... 306,240 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Praveen,

Can you provide an example with amounts? Is the huge amount somehow explainable? Is July 2 used as the settlement date or is that the date when the settlement itself has been done?

Was this reply helpful? Yes No
praveens007 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Andrea

Thanks for your response. If you look at the below example. I had now settled the invoice today which is 7th July. Then i ran the revaluation for Jun'24. Marked in blue arrow are the amount which i dont understand. Though these amounts are reversed but in July only. When i see my books for June they are way out with that amount.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,240 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Praveen,

This is insane! Do you have customizations or is this fully standard? In case it is standard, I would suggest checking LCS issue search for a known issue or create a ticket for Microsoft Support.

Was this reply helpful? Yes No
praveens007 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Andre,

I am sure and agree with you that this is so insane. We do have customisation with regards to decimals. We have extended to 3 decimals in our environment.

Regards

Pravin

Was this reply helpful? Yes No
Bharath jain 1,578 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Praveen,

have you verified the exchange rate. cant think of any other reason.

Regards,

Bharath Jain

Was this reply helpful? Yes No
praveens007 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bharat. There are no ExRate abnormalities. I have verified everything and have failed to understand the calculation it has done.

regards

Pravin

Was this reply helpful? Yes No
LJ-31071451-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you found a reason and/or a solution to the issue you had? I am having the same issue with bank FCR process - huge amounts in P&L that I cannot explain.

Was this reply helpful? Yes No