Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

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.