Skip to content
Microsoft Dynamics 365

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.

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!

Join the conversation

Loading comments...