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...
Smartlist Builder to sort by Reporting Ledgers
As of the publication of our white paper, "Eliminations and Adjustments in Dynamics GP and Management Reporter", standard SmartLists for Account Transactions does not have a sort field for Reporting Ledgers. Here is what you need to create an Account Transaction SmartLists by Reporting Ledger. Basically, you have to rebuild the standard SmartLists, Financial>>Account Transactions, to bring in the field, Ledger_ID. GL40001 contains the needed descriptions for the Ledger_ID setup in GP. There are other options and it is hoped that Microsoft will add this field to the standard SmartLists soon, as well as in the Detail Inquiry window. Using separate Accounts dedicated...
Setting up Multicurrency in GP with Management Reporter
Setting up Multicurrency in Dynamics GP with Management Reporter is very different from the days of Rate Tables in FRx. Setting up Multicurrency for financial statement translation requires building the currency translation logic in Dynamics GP, both the rate tables and what method each account uses to convert to a reporting currency. The purpose of the White Paper, "Consolidation design in Microsoft Dynamics GP and Management Reporter", the 2nd in the Consolidation Accounting Series, is to provide the step-by-step setup requirements for performing multicurrency consolidation in Dynamics GP and Management Reporter. Consolidated Currency Translation This document covers the required setup to perform multicurrency...
What rate does MR use when translating from functional to reporting currency?
How Does Management Reporter know what rate to use when translating an Account from its functional currency to the Reporting Currency? 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. Working from MR to GP Sometimes a picture is worth a thousand words. Here is the connection between a Management Reporter financial statement and the appropriate GP rate table. Currency Translation in Microsoft Dynamics GP® and Management Reporter, the 2nd in the Consolidation Accounting Series The purpose of this White Paper is...
Currency Translation in Microsoft Dynamics GP® and Management Reporter
The purpose of this White Paper, the 2nd in the Consolidation Accounting Series, is to provide the step-by-step setup requirements for performing multicurrency consolidation 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...