Using the Transaction Date (historical) translation type in Management Reporter

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation.

YTD/BB Column

The report date is March 31^st. The columns are set to return YTD/BB data. The data is from a transaction that occurred during 2011. The rate in effect at the time the transaction was entered was .62820.

January Column

The report date is March 31^st. The columns are set to return January data. Below is a screen shot of the report followed by the transactions that exist within January. The effective rate calculates to .56286.

February Column

The report date is March 31^st. The columns are set to return February data. Below is a screen shot of the report followed by the transactions that exist within February. The effective rate calculates to .66524.

March Column

The report date is March 31^st. The columns are set to return March data. Below is a screen shot of the report followed by the transactions that exist within March. The effective rate calculates to .60211.

YTD Column

The report date is March 31^st. The columns are set to return YTD data. Below is a screen shot of the report followed by the transactions that exist within the year. The effective rate calculates to .63569.