web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Multicurrency Revaluat...
Microsoft Dynamics GP (Archived)

Multicurrency Revaluation report

(0) ShareShare
ReportReport
Posted on by Brent Olsen 87
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

I have the same question (0)
  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans