News and Announcements icon

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

Microsoft Dynamics GP (Archived)

Multicurrency Revaluation report

(0) Share

Report

Report

Posted on by Brent Olsen

85

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 Img

All responses (1)

Answers Img

Answers (0)

Heather Roggeveen 9,144 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2

Martin Dráb 230,354 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans