Back

Finance

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

Transfer Pricing and Reporting Ledgers in Dynamics GP

Transfer Pricing and Reporting Ledgers in Dynamics GP In addition to Elimination and Adjusting Entries, Reporting Ledgers can be used to record tax adjustments, non-operating adjustments, or Transfer Pricing entries. Often these types of entries are kept separate from Management Financial Reports and Operational Financial Statements. Transfer Pricing entries can be posted to the General Ledger and then Eliminated or posted to a separate Reporting Ledger and simply ignored in Consolidation. One of the advantages of posting eliminating entries in the functional currency, YEN in this example, is that the Reporting Ledgers use the same multicurrency translation rules in Management Reporter as...

Elimination and Adjusting entries using Reporting Ledgers for Consolidation Accounting in Microsoft Dynamics GP and Management Reporter.

How to use Reporting Ledgers for Consolidation Accounting in Dynamics GP and Management Reporter. When a business is operated as a parent company with subsidiaries, separate accounting records are kept for each entity. Investments in Subsidiaries, Dividends, Transfer Pricing, Intercompany Transactions, etc., require Elimination and Adjusting entries for consolidation. These entries are only for consolidation and are not posted to an entities books and records (General Ledger). The challenge is where to record elimination entries to provide a reliable audit trail and internal controls. Given the many challenges, you can successfully leverage an investment in Dynamics GP to record and manage elimination...

Historical Rates for Previous Periods, Dynamics GP

In Microsoft Dynamics GP, the use of Historical Rates requires some manual entry to establish the correct translation for prior periods. After the initial prior period Historical Rates are setup, the system will manage the Historical Currency Translations going forward as part of the closing process. To enter prior period historical conversions, use the Currency Translation window to translate beginning balance information for "average" and "historical" currency translation types. You also can enter translated beginning balance amounts for a new translation currency or correct translated beginning balance amounts. You don't translate beginning balances for the "current" translation type because the current...