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
But they still need to maintain the rates in GP so they'd be maintaining the worksheet and GP, right?
Thanks Francisco,
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
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,
Frank, you can read about MR doing this with GP take a look
gp.rosebizincblogs.com/.../currency-translation-default-exchange-table-idsdemystified.html
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
Bump.
#1
André Arnaud de Cal...
291,784
Super User 2024 Season 2
#2
Martin Dráb
230,476
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
