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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / management reporter an...
Microsoft Dynamics GP (Archived)

management reporter and exchange rates

(0) ShareShare
ReportReport
Posted on by Ian Richardson 4,150

today's exchange rate is yesterday's closing rate.

for a month end we will also enter today's closing rate for today's rate so that month end revaluations will use the month end rate.

so we have two rates for each month end.

management reporter multicurrency feature is now translating my CAD entries into USD for me and it can see both rates and is therefore pulling all the transactions twice.

Is this a bug in MR?  Is this a set up issue in MR or GP? Is this an expectation that the data should / can only have one rate per day?

thanks!

Ian

*This post is locked for comments

I have the same question (0)
  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: management reporter and exchange rates

    for a pure average exchange rate I would agree with you have only one rate.

    We are however entering rates daily, hence the two dates on a month end.

    I'll go with the separate exchange table that has only the one rate until we can make it over to GP 2013 (once our third party software catches up) where average can be calculated by GP based on the daily rates entered.

    thanks!

  • Community Member Profile Picture
    Community Member on at
    RE: management reporter and exchange rates

    I have not heard of anyone overlapping rates before. For example, if you want a rate for July, I would have the start date 7/1/2013 and the end date 7/31/2013. The rates are valid for all days including the start and end date. Any other rates should fall on an adjacent day. For example, August would run from 8/1/2013 to 8/31/2013.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: management reporter and exchange rates

    I created a new exchange table with only one rate on it and the problem went away.  That's the only solution I can see as any month end that falls on a week day is going to have two rates, one set from the prior days close at start of day and one set as the spot rate for the closing of the period.

    ian

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: management reporter and exchange rates

    I have not heard of this before. I know it is recommended to only have one exchange rate per day so if you correct your rates, does that correct MR? I would also recommend testing this from the other way around by removing the translation code from MR to see if that corrects the duplicate transactions.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans