The Translation Rates Procedure

The execution of this procedure (080 - Calculate Translation Rates) is mandatory, and basically prepare the data later required, by the Consolidation Procedure to execute a correct translation.

It must be executed before executing the Consolidation Procedure and anytime any change in the translation rates occurs.

Remember that the Translation Rates have been keyed in at Period, Scenario, Currency and Node Currency Level.

Such Rates must be copied across all the other dimensions of the Conso Infocube depending from the attributes of the different cells. This attributes can greatly varied depending from Accounts and Movs.

Let's examine how this happens: (grey areas are not being calculated)

> Setting Selections

Since this procedure is useful only if combined with the consolidation procedure this command group narrows the execution to meaningful combination of scenario/period : the working periods.

The working period are available (not archived) and open periods.

How to setup working period please refer to.

> Accounts without Movements translated at AVG

Such accounts (as P&L Accounts) has no movements except Closure (CLO). Closure it is always calculated at Average Rate.

> Accounts with Movements translated at AVG

Average Rates are copied on Movs translated at AVG Rate for all the Movs Accounts (both translated at Average Rate or Closure Rate)

> Accounts with Movements translated at CLO

Then Closing Rates are copied on Movs translated at CLO Rate for all the Movs Accounts translated at Closure Rate

> Accounts with Movements translated at SPOT

Spot Rates are copies on all Movs translated at SPOT rate independently from the nature of the Account

> Accounts Not Monetary

Finally Translation Rate equal to "1" is copied across all the Not Monetary Accounts

General Rules

> If the translation Rates is expected but not provided a default Exchange Rate equal to "1" is copied.

> Depending on the General Settings option YTD Average Exchange Rate two different calculation command groups are used for the AVG calculation

> The CLO Mov of Accounts @AVG is not calculated because the CLO Mov is re-calculated during the at the end of the Consolidation Translation Procedure

> In the procedure there are two disabled blocks :

- Accounts at HIS (disabled : done @IC Macthing)

  The users  key in the translated value so it's useless. It can be re-activated for reporting purposes (if you want to use the Translation Rates infocube for historical accounts too)

- Reverse Exchange Rate (disabled : done @IC Macthing)

  IC Matching requires to reverse the Translation Rates Infocube. This can be done here, but it's useful only when IC

  Matching process starts, so such reversion is implemented in the IC Matching Capsule as preliminary process.

Reverse a cube it means to transpose the data loaded as RU to the same code as IC Company so that your data become visible to other RU users. For IC Matching is mandatory.