Using transaction templates

To distribute a transaction across a number of ledger accounts and dimensions, you can use a transaction template. For each transaction template, you can define one or more transaction template lines to specify the distribution of the main transaction amount across a number of ledger accounts and dimensions.

The transaction template type determines whether the distribution of the transaction amount is based on:

  • Amounts

    Fixed amounts are posted to specific ledger accounts and dimensions. The sum of the amounts must be equal to the transaction amount.

  • Percentages

    Percentages of the transaction amount are posted to specific ledger accounts and dimensions. The sum of the percentages must be 100.

  • Factors

    Proportional parts of the transaction amount are posted to specific ledger accounts and dimensions.

You can create transactions based on transaction templates in these sessions:

  • Create Transactions from Template (tfgld1204s000)
  • Standing Orders (tfcmg1510m000)

Using factors

You can use factors to distribute the transaction amount proportionally.

For example, to distribute the electricity bill proportionally across three work centers that comprise three, five, and two machines respectively, you can set up a transaction template that is based on a factor. You must define three transaction template lines in the Transaction Template Lines (tfgld0113m000) session, one for each work center. For the first work center, you enter 3 in the Factor field, for the second work center, you enter 5, and so on.

LN calculates the parts of the transaction amount for each transaction template line as follows:

3 + 5 +4 = 12

As a result:

3/12 of the total transaction amount is posted to the first work center.

5/12 of the total transaction amount is posted to the second work center.

4/12 of the total transaction amount is posted to the third work center.

Specifying the transaction template line

To specify the transaction template line:

  1. In the Transaction Templates (tfgld0512m000) session, double-click the appropriate transaction template. The Transaction Template (tfgld0612m000) session starts.
  2. On the Template Lines tab, click the New button to specify the part of the transaction amount, the ledger account, and the dimensions to which the amount must be posted. LN automatically generates the next line number.
  3. Repeat the previous step for each transaction template line.