Currency conversion

When a TGKML script reads data from an entity and writes the result on another entity which has a different currency, it is necessary to perform a conversion; indeed in these cases the normal value the system would write on the amount 2 (for further details see Amounts and currencies) doesn't make any sense.

Tagetik provides the users with the ConvertOriginalutility where the amount 2 is calculated by converting the amount into currency 2.

The ConvertOriginal function can be used with the temporary accounts only if all needed information for the conversion is available in the temporary account, that is:

  • scenario
  • period
  • account
  • entity or journal number (information not needed for the consolidated cubes)
  • currency

From Tagetik 5.0.2, the conversion utility ConvertInput is no longer supported.