Dynamics Management Reporter Currency Translation Type
I posted this last year and felt it worth repeating! How Does Management Reporter know what rate to use when translating an Account from its functional currency to the Reporting Currency in Dynamics GP? They say a picture is worth a thousand words. Well, my white paper, Currency Translation in Dynamics GP and MR, has 3,147 words and this image sums it all up! I thought it may be helpful to lay out the logic and connections used by MR to correctly translate a functional to a reporting currency used in the sample Balance Sheet.
- Account is setup to Currency Translation Type
- Currency Translation Type is setup to a Multicurrency Exchange Rate Table
- The Multicurrency Exchange Rate Table sends the appropriate rate to MR
- MR converts the Fictional Currency to the Reporting Currency
Currency Translation in Microsoft Dynamics GP® and Management Reporter, the 2nd in the Consolidation Accounting Series
The purpose of this White Paper is to provide design requirements for performing Multicurrency Translation in Dynamics GP and Management Reporter.
Consolidated Currency Translation
This document covers the required setup to perform multicurrency consolidation in Dynamics GP and Management Reporter. It leverages the design concepts presented in the first white paper in the Consolidation Accounting Series, Consolidation design in Microsoft Dynamics GP and Management Reporter. This White Paper focuses on setting up both Microsoft Dynamics GP and Management Reporter to successfully perform multicurrency consolidations.
Dynamics GP Currency Translation Setup
Create Exchange Tables and Enter Rates
Create the Month End, Average, and Historical TRANSLATION Exchange Tables Management Reporter Translation Setup
Translation Type for Accounts
Entering Historical Currency Translations
Management Reporter Translation
Create a column indicating the reporting currency required
Create a report definition
Cumulative translation adjustments under FSFAS 52 (OCI)
Validate the Account settings
Multicurrency translation can be very complex and include the need for multiple company account structures, companies outside of Dynamics GP, minority interest, international accounting standards, and more. Having a well-thought-out multicurrency design adds significant value to any consolidation process.
This white paper is intended for Accounting and Financial users and consultants that are responsible for producing consolidated financial statements in Dynamics GP and Management Reporter.
Request a free copy “Currency Translation in Microsoft Dynamics GP® and Management Reporter®” at Currency Translation