Using the Average translation type in Management Reporter
Rates entered in AX for USD to GBP that will be used by MR when doing currency translation. The average rate is calculated by taking the sum of the rates and dividing by the number of rates in the period.
YTD/BB Column
Average translation type accounts are typically P&L accounts so they won’t have a beginning balance as noted in the screen shot showing no data. If a Balance Sheet account was set to Average each month’s balance that makes up the beginning balance would be translated at that month’s average rate.
January Column
The report date is March 31st. The columns are set to return January data. The rate used is an average of all the rates that exist within January which calculates to .64292.
February Column
The report date is March 31st. The columns are set to return February data. The rate used is an average of all the rates that exist within February which calculates to .63251.
March Column
The report date is March 31st. The columns are set to return March data. The rate used is an average of all the rates that exist within March which calculates to .62873.
YTD Column
The report date is March 31st. The columns are set to return YTD data. Each month’s balance is translated at that month’s average rate. The effective rate calculates to .63467.
