TRANSLATE_LDI

TRANSLATE_LDI(%bs_acc%,%bs_acc_fxdiff%,%avg_rate%,%end_rate%)

This function translates a balance based on the current value and compares it against the prior balance. The current translated rate is applied to the difference from the current and prior values. For example:

January balance: 100

exchange rate: .5

February balance: 200

exchange rate: .75

The final balance is: (100*.5) +(100*.75) = 125, given that the difference between the two time periods is 100.

The local difference in the bs_acc account is translated at the avg_rate, and added to the prior period translated value, with the translation difference posted to the bs_acc_fxdiff account. This function has a complete commit section. Requires the properties PRIOR and CURRENT in the Time dimension.

Parameters:

%bs_acc% Balance statement account.

%bs_acc_fxdiff% Balance statement account to which the local differences are posted.

%avg_rate% The ID of the average rate (normally AVG).

%end_rate% The ID of the end of period rate (normally END).

TRANSLATE_LDI( CYNI, FXCYNI, AVG, END )

TRANSLATE_PROFIT_AND_COMMIT

TRANSLATE_PROFIT_AND_COMMIT(%bs_profit_acc%,

%bs_profit_acc_fxdiff%,

%avg_rate%,

%end_rate%)

The balance statement (BS) account is translated at the AVG rate, and the difference from END rate is posted into FXDIFF account. This function defines a complete commit section.