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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Historical FX Rates in GP
Microsoft Dynamics GP (Archived)

Historical FX Rates in GP

(0) ShareShare
ReportReport
Posted on by Frank Hamelly | MVP... 46,627 Moderator

Is there an Exchange Rate table in GP that is the equivalent to the Historical Rates table in FRx that is used to translate certain accounts (Fixed Assets for example) to a fixed, historical rate?  I'm trying to determine if it's possible to use only the GP exchange rate tables in lieu of the FRx exchange rate tables and still maintain the ability to report certain balance sheet accounts at historical rates using FRx.

Thanks,

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    Bump.

  • Ryan Sandness Profile Picture
    Ryan Sandness Microsoft Employee on at

    Hi Frank,

    This is not possible with FRx without using the DAX tables. With GP2010 Feature Pack 1 there were new windows and tables added that Management Reporter will use to accomplish this.

    The user guide for this feature in GP2010 (CurrencyTranslationENUS.pdf) can be found here:

    mbs2.microsoft.com/fileexchange

    Thanks

    Ryan

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Frank, you can read about MR doing this with GP take a look

    gp.rosebizincblogs.com/.../currency-translation-default-exchange-table-idsdemystified.html

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    Thanks Ryan and Francisco for your helpful input.  Unfortunately, the client is on GP7.5 and FRx 6.5.  We're preparing them for an upgrade but that won't happen for a few months.  The real issue is they don't like having to maintain FX rates in both GP and FRx and I was looking for a work-around, hoping they could maintain the rates only in GP but it appears that's not possible if they want to use the Historical rates for financial reporting.

    Thanks again,

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Frank, what about enter the historical rates per month as an example in a worksheet and use the worksheet link and do the calculations at the row level

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,627 Moderator on at

    But they still need to maintain the rates in GP so they'd be maintaining the worksheet and GP, right?

    Thanks Francisco,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans