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.

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

The rates are defined for each period.

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.

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

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