Currency Translation Update – Management Reporter and Dynamics GP

Businesses need to create a monthly comparative balance sheet. Therefore, Management Reporter 2012 RU2 allows you to return individual exchange rates for each column of data for General Ledger accounts that use the Current translation type in Dynamics GP. This allows for comparative balance sheet reporting. 

 

Example: 

Exchange Rates:

  •          January 12th – 0.79
  •          January 31st – 0.78
  •          February 14th – 0.78
  •          February 28th - 0.77
  •          March 31st – 0.79

 

Report Information:

Quarter 1 report: January, February, and March columns

Report Date: March 31st 2012

 

Results:

January amounts * 0.78

February amounts * 0.77

March amounts * 0.79

 

Please note that this calculation is specifically for current amounts, and the rate used for the calculation is based on the rules that are defined in the exchange table setup in Dynamics GP. If you have questions on how the exchange rate is determined, please see this post. Check back again to hear about the new Average Rate calculations that will be coming in Dynamics GP 2013.