Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Multicurrency Revaluat...

Multicurrency Revaluation report

(0) Share

Report

Posted on by Brent Olsen

We are trying to understand the Revaluation Report, specifically how the average Exchange rate is calculated. I understand that it can be calculated by net change or period balance but on our report it is averaging the period not the year end rate. Also, some of our transactions were entered incorrectly, is there a way to alter or correct the calculated average? Thanks in advance.

*This post is locked for comments

All responses (1)

Answers (0)

Heather Roggeveen 9,142 on at

Like (0)

Report

RE: Multicurrency Revaluation report

Hi Brent

I am not an expert in this area and someone can correct me if I am wrong, but I think the average is calculated based on the actual exchange rate used at the time of entry and the transactions that included in the report.

E.g.

Five entries with different rates = sum of all rates divided by five.

If you do a realised gain / loss calculation, that I think revalues permanently the transactions included in the period. So if something was entered incorrectly, you would then get a gain or loss calculation accordingly.

I haven't done this for a very long time so dredging from the back of the grey matter on this one.

Cheers

Heather