Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Running the financial ...
Microsoft Dynamics GP (Archived)

Running the financial multi-currency revaluation

(0) ShareShare
ReportReport
Posted on by C. Barrett 60

My company starting using Dynamics GP 2010 for the past couple of months. 

We are having some problems around the 'Financial multicurrency revaluation process'.  My superior, noticed that some of the exchange rates used (convert USD into CDN) appear to be off.   I am inquirng how can do i go about explaining the average exchange rate calculation.

In addition, would you run the Purchasing multi-currency revaluation; if your company only uses the purchase module to pay invoices.

Regards,

Courtney

*This post is locked for comments

  • C. Barrett Profile Picture
    C. Barrett 60 on at
    Re: Running the financial multi-currency revaluation

    Good afternoon Ian and Tariq,

    i was able to try out the calculation that you suggested.  However, i had to use the reciprocal value of The total sum of all orignating transaction amounts/Total sum of all functional transaction amounts. in order to match the average exchange rate in GP.

    Does that sound right?

    Regards,

    Courtney

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Running the financial multi-currency revaluation

    Agreed with Tariq - it can be a hard one to reconcile especially if you have a large number of transactions - but the calculation is correct and it works as intended. I too have run into this when people get unexpected results - but GP is always correct.

  • Suggested answer
    Tariq Aziz. Profile Picture
    Tariq Aziz. on at
    Re: Running the financial multi-currency revaluation

    Barrett !

    I spent a lot of time finding how average exchange rate is calculated and finally found the answer.

    Average Exchange rate is calculated by dividing/multiplying (depending upon the calculation method for the originating currency) sum of all Originating Transaction Amounts by/to sum or all functional transaction amounts.

    I have verified it for different accounts and found the calculation to b right.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans