Microsoft Dynamics AX Support

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

Using the Weighted Average translated type in Management Reporter

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation. The weighted average is calculated by taking the rates multiplied by the days in effect and divided by number of days in the period. (rate * days in effect)/day in 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 a weighted average of all the rates that exist within January. Each rate is weighted by the number of days it is in effect which calculates to .64734.

 

 

February Column

The report date is March 31st. The columns are set to return February data. The rate used is a weighted average of all the rates that exist within February. Each rate is weighted by the number of days it is in effect which calculates to .63259.

 

 

March Column

The report date is March 31st. The columns are set to return March data. The rate used is a weighted average of all the rates that exist within March. Each rate is weighted by the number of days it is in effect which calculates to .63055.

 

 

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 .63677.