With the release of Management Reporter CU7 and CU8, currency translation for Dynamics AX 2012 and Dynamics GP 2013 was introduced. Customers want to be able to compare their Profit and Loss accounts at the weighted average or average rate to the month end rate. Each ERP allows one currency translation method to be applied to the account, so a report will help you accomplish this goal.
This video explains how to create a report that shows you the month end rate and apply it to the profit and loss accounts so you can compare and get a currency translation adjustment. The high level steps are:
NOTE: You can import the attached .tdbx and import it to get started quickly. Just change the accounts in the row definition and the currency display in the column definition.