As mentioned in the announcement for Management Reporter Feature Pack 1, currency translation support has been added to Management Reporter. The currency translation feature works in conjunction with the currency enhancements added in Microsoft Dynamics GP 2010 SP1, giving customers the ability to create financial statements in a specific reporting currency.
However, before discussing the new currency translation feature, I would like to give a brief overview of existing currency functionality.
In Management Reporter there are two currency related fields that can be selected in the column definition: Currency Source and Currency Filter
Currency Source- This specifies the type of currency (Natural, Functional, or Reporting) that the transactions will be displayed in.
Currency Filter- When selecting a currency filter, only transactions entered in the selected currency will be displayed in the report.
So for example, the user chooses the following:
Currency Source: Functional (US Dollars)
Currency Filter: Canadian Dollars
Results: The column will print only transactions that were entered in Canadian Dollars, but will display those transactions in the Functional Currency (US Dollars).
As I noted above, with Management Reporter FP1, there is the option…