Define Control Tables

The Control Table's Header

In the control table header you can see:

• The automatic journal code and name.
• The predefined automatic journal type.
• Journal number (defined by the user).
• Offset account (can be stated in the header or on the rows for counter booking of the elimination). Note that the offset account should only be used for the E100-E115, E150, E760-E775. It is also used in the E600-E603 control tables, where it is called Retained Earnings BS. It should only be used for investment eliminations and investments adjustments.
• Closing version (calculation basis for the elimination).
• Journal type (journal type to which the journal entry is to be posted).
• Contribution version (calculation basis for the elimination). This is only selectable for some control tables that are based on the period database. The automatic journal types in the selected contribution version must belong to the automatic journals defined with a lower level than the level of the present automatic journal. Note that by leaving the contribution version field blank, only base values and automatic journals from a lower level will be used as the calculation basis.

The Lower Part of the Control Table

The lower part of the control table will usually contain at least the following columns:

• From Account
• Sign
• To Account (OB)
• To Account (change)

Calculation Logic

How amounts are calculated depends on how the To and From Accounts are handled - whether they are considered as Head or Change account in IBM® Controller.

Head account: An account that is not part of an OB/CB structure. Head accounts also include OB accounts (with reconciliation code I, J, K or L).

Change account: An account of type I, C, T, U (P&L type) or any account that is part of an OB/CB structure (except the OB account itself).

The next table shows how different combinations of head and change accounts give different results. Note that transaction amount (trbelopp) has impact on case 3. Be aware that not only amounts affect the calculation, but also other parameters such as selection methods, calculation methods and the category of the automatic journal.

Calculation of Automatic Journals Affected by Head and Change Accounts

• H = head acct
• C = change acct
• 1 = from account
• 2 = to account
• Y0= current year
• Y-1 = previous year

Note that you should not combine H + C -> C as that will produce unexpected values. In case you get an unexpected result, please study this logic. You can also run the report Check Rules for Automatic Journals under Maintain/Special Utilities/Verify Structures to see how the accounts are handled.

The Contents of the Control Table

The pre-defined control tables have a number of different appearances. Which columns are shown depends on what you have defined in the matrix on the Define tab in the Define Automatic Journals window. The user-defined control table has an optional number of columns, and you can structure it according to your preferences.

Pre-defined Automatic Journals

The table shows the predefined automatic journals in IBM Controller, as well as the automatic journal types the generated automatic journals have been booked to:

Sub-control Tables

This table shows the sub-control tables that are used for reference when calculating certain automatic journals: