Exchange Rate Table ID Design for Multicurrency Consolidation

Moving the Translations rate tables into Dynamics GP with the release of Management Reporter 2012 makes for a more extensive list of Exchange Rate tables having both Transaction and Translation rate tables managed in one area.  When setting up your new Translation rate tables consider using a common prefix for Translation Exchange Rate Table IDs to organize exchange tables between Translation and Transaction.


Excerpt from the Consolidation Accounting Series White Paper, Currency Translation in

Microsoft Dynamics GP® and Management Reporter

The following example is a naming convention used for Translation Exchange Rate tables in Dynamics GP for the purposes of this White Paper, and is one of many design concepts to keep your rate tables organized and separated. You could use a Z to move to the bottom, or use a prefix to represent all translation tables. In this example, MR is used as a prefix.


Translation Exchange Table ID logic:

Translation TablesFunctional CurrencyReporting CurrencyTranslation Type, Average, Month End, or Historical


For consolidating the Japan company into a US$ consolidated report, the following Exchange Table IDs are used:

Translation Tables – MR (prefix for all translation Exchange Table IDs)


Functional CurrencyYEN

Reporting Currency – US

Translation Type, Average – ME, Month End – AVG, and Historical – HIST

The following Exchange Rate Table IDs are created in the Two Inc. Japan Company

MRYENUSME (Translation Table for YEN to US$ at Month End (Current) rates)

MRYENUSAVG (Translation Table for YEN to US$ at Average rates)

MRYENUSHIST (Translation Table for YEN to US$ at Historical rates)


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

  • Functional Currency
  • Create Exchange Tables and Enter Rates
  • Create the Month End, Average, and Historical TRANSLATION Exchange Tables Management Reporter Translation Setup
  • Multicurrency Access
  • Multicurrency Setup
  • Rate Types
  • Translation Type for Accounts
  • Entering Historical Currency Translations

 Management Reporter Translation

  • Create Report
  • 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