Define Control Tables - Transfer of Equity, Investment Adjustments

In this control table, E760, you define the equity accounts to be eliminated on the subsidiaries. This control table is applicable for customers in the Netherlands and Denmark, using Investment Adjustments E600-E603.

Note: The offset account for control table E770 is usually the same. This means that the automatic journals make a zero sum to the offset account in the consolidated group.

Procedure

  1. On the Maintain menu, click Configuration/Automatic Journals/Control Tables/Acquisition Calculations. The Control Tables - Acquisition Calculations window opens.
  2. Select control table E760, Transfer of Equity, Investment Adjustments and click OK.
  3. Enter a journal number. The automatic journal type 50 is displayed automatically.
  4. Add an offset account in the Balance Sheet. This offset account should preferably be the same as the offset account in control table E770 (etyp 10), elimination of Investments.
  5. Enter a closing version and journal type.

    A blank journal type means that the journal will be booked on the same journal types as the calculation basis.

    A blank closing version means that the elimination will be calculated on every journal and reported value.

  6. Define a Contribution Version. You select which contribution version the elimination should be calculated on. To be able to correspond to the elimination of the Equity (E770, etyp 10), this should be the same contribution version. Example B30X contains: BASE + etyp 30.
  7. In the From Account 1 and From Account 2 columns, enter the range of accounts to base the calculation on. This is normally the accounts for the equity. It can be summation accounts, main accounts and movement accounts.
  8. In the Sign column, enter a plus sign if the value should be booked with the same sign as the From Account, or enter a minus sign if the value should be booked with the reversed sign.
  9. In the To Account (OB) column, enter the OB account belonging to the selected To Account for change.

    If the To Account (change) is a movement account or an OB account, the corresponding Opening Balance account should be added here. If the To Account (change) is a P&L account (Account type I, C, T, U) To account (OB) must not be filled in.

  10. In the To Account (change) column, enter the accounts where the elimination should be posted.

    The elimination will be stored on the subsidiary. Normally you enter the same account as From Account, but this is not necessary.

  11. If applicable, enter dimension codes to store the calculated transactions on. If these fields are not defined, the elimination will be stored on the same dimension(s) as the source data.
  12. Click Save.