Example

The application currency is Euros, and we are translating a French child to a US parent using the following rates entered in the [None] entity against the C2#EURO:

Table 17. Example of Rate Function

 

Opening Rate

Closing Rate

C1#FFR

0.16000

0.16500

C1#USD

1.15862

1.15785

The following function multiplies the opening balance account by the difference between the relative ending and opening rates. This is useful when calculating movement analyses if the translation is not consistently between the local and application currencies.

HS.EXP "A#FXO = A#OPEN * (" & RATE("A#EOP_RATE"," ") & "-" & RATE("A#OPE_RATE"," ") &")"

For the previous example, if the value in the OPEN account for the child is FFR 10,000,000, the value in the US parent FXO account will be USD 44,102 [10,000,000 * (0.165 /1.15785 - 0.16 /1.15862)].