Back

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...

Turning on Reporting Ledgers in Dynamics GP

Reporting ledgers were introduced with the release of Dynamics GP 2010. Reporting Ledgers provide 3 financial ledgers, the general ledger (BASE) and two optional reporting ledgers. This allows for the separation of financial adjustments (Statutory adjustments, Eliminations, Transfer pricing, etc.) from the general ledger. Organizations would add separate accounts or maintain separate company databases to separate management reports from published financial statements for these types of adjustments before reporting ledgers. Elimination and Adjusting Entries for Consolidation Elimination and Adjusting entries are never posted to the General Ledger but are required to report on the consolidated financial results of an organization and its subsidiaries....