Skip to main content

Notifications

Announcements

No record found.

Management Reporter currency translation using the Historical translation type

In this post, we'll cover how MR uses the historical translation type.

 

In GP, account 000-1120-00 set up with Historical translation type.

 4848.1.png

The account has an ending balance of 110, which is the beginning balance for 2014.

 6014.2.png

0247.3.png

 

The rates are defined for each period.

 4861.4.png

 

 

In MR, there are columns formatted for the two periods in 2013, the BB, Period 1 and Period 2 and a YTD . This will display the functional amount and the translated amount. Each period should be converted at the rate for that period.

5037.5.png

 

We can see that each period was translated at the rate for that period.

P11 – 10 * 1.2 = 12

P12 – 100 * 1.1 = 110

P1 - 100 * 1.5 = 150

P2 - 200 * 1.35 = 270

0652.6.png 

The beginning balance is the ending balance of 2013 (10 + 100 = 110). The converted beginning balance is converted amounts from 2013, rolled forward (12 + 110 = 122).

The YTD amount is the BB plus the balance of each period. The functional YTD would be:

BB – 110

P1 – 100

P2 – 200

YTD – 110 + 100 + 200 = 410

The convert YTD is then the sum of the converted amounts.

BB – 122

P1 – 150

P2 – 270

YTD – 122 + 150 + 270 = 542

 

Thanks,

Greg Byer

Microsoft Dynamics

 

 

 

 

Comments

*This post is locked for comments