You’re offline. This is a read only version of the page.
1,599
My client would like to start using Management Reporter to Consolidate a US company with multiple foreign entities, translating the foreign entities into US dollars. Each company is a separate database configured with their home country currency. All the transactions in each country are within their own currency and do not cross companies. MR currently does individual balance sheets and income statements but does not do any consolidation.
Within the US company, they have rate tables for each of the foreign currencies which are maintained on a monthly basis with new rates entered at the end of each month.
The foreign countries are denominated in their own currencies, but have not rate tables.
There is a foreign currency setup document for Management Reporter, but it is not very clear. Is there anyone out there that has completed this type of setup?
If so should the rate tables reside with the US company or should they be within each foreign company?
Look forward to a reply.
JG
Thanks Greg,
Appreciate the response, I am now seeing a road map in terms of adjustments the client needs to make. In our case it appears the client's setup is in the US company and not in the foreign entities. Their configuration goes back over 10 years and was designed to support a custom consolidation process without consideration for back then FRx, today Management Reporter.
Again, appreciate the help.
JG
Hi JG,
MR reads all the currency translation information from the company in GP. You'd need to have exchange rates set up for each company that had a rate for the functional currency to USD. The KB below has the steps for setting up currency and exchange rates in GP:
support.microsoft.com/.../2986068
Let's say that I have two companies, one with a functional currency of USD and another with CAD. I want to consolidate them and see the amounts in USD. In my CAD company, I would need to have an exchange rate set up between CAD and USD. In MR, I would need to select the USD currency in the Currency Display cell of the column definition. I can add both companies to the report tree and when the report is generated, both companies would display in USD.
You can also view an on demand learning video here:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (