D.11 Inserting Into Management Ledger Table

Allocations inserting into the Management Ledger table treat Currency as a Key Processing Dimension. For example, in a Dynamic Driver type of allocation that outputs to Management Ledger table, if the allocation's Debit value in the Currency dimension is <Same as Source> and if five distinct currencies are found in the Source data, then the engine will output to five currencies in its Debit currency. If the allocation's Debit value in the currency dimension is <Same as Driver> and if six distinct currencies are found in the Driver data and if the allocation's Driver is constructed to use Force to 100%, then the allocation engine will perform a percent-distribution calculation to the six currencies.

The engine decides how to Debit and Credit the Currency dimension based on the instructions you specify in an allocation rule. The decision as to whether or not to translate output values to the currency basis of the target output currencies is a completely separate one.

For any row in the output of an allocation rule, the engine decides whether or not to convert to a target currency based on the Column Property of the Financial Element for that row.

As was the case when selecting data from the Management Ledger table:

  • If the Column Property of a target row's Financial Element is Balance or Balance Weighted Object then the value is translated from the Functional Currency to the target currency.
  • If the Column Property of a target row's Financial Element is Statistic or Standard Rate then the value is NOT translated. That is, the value has no currency-specific basis).