Define Control Tables - Structural Changes - Adjusting Opening Balances

Follow the next steps to define control tables for structural changes for adjustment of opening balances.

Note:
  • Offset Account, Closing Version and Contribution Version are not in use for this control table.
  • The disposed company must be removed from the selling group from the period when it is sold. When sold internally, the company should therefore belong to the selling group until the period it was sold, and belong to the buying group with X% from the period it was bought.
  • Changes will be booked on automatic journal type 20, unless you have selected the Enable Calculation of Change in Structure check box in the other automatic journals, which is recommended. If you have done that, these changes will be booked on the same automatic journal types that are defined in each automatic journal, but with the journal number for E300, except in the case for change in owned %. BASE values, that is, reported values and company journals, will always be booked on automatic journal type 20.
  • You must set a unique journal number for E300 in order to be able to analyze which automatic journal that has booked each amount. The journal number for E300 must not be used by any other automatic journal regarding acquisition calculations, elimination of internal balances or internal profit. Otherwise, there is a risk of mixing up the values.

Procedure

  1. On the Maintain menu, click Configuration/Automatic Journals/Control Tables/Acquisition Calculations. The Control Tables - Acquisition Calculations window opens.
  2. Select the control table E300, Structural Changes - Adjusting Opening Balances. Click OK.
  3. Enter a journal number. The automatic journal type 20 is displayed automatically.
  4. If necessary, enter the closing version and journal type.
  5. Enter all opening balance accounts from the account structure.
  6. Enter all investment accounts and disposals accounts.
  7. Enter accounts for change in owned % and change in consolidation method. Use unique accounts or the same as for investment/disposal.
  8. In the B/E/I column, specify the type of investment each calculation applies to.

    The code determines what type of investment the account applies to: Blank - both (E+I) E - external I - internal Example: If you only have one investment account for buildings, you only define one row where the B/E/I column is blank. If you have separate accounts for investments in group companies and external companies, you define two rows, where the B/E/I column contains one row of E and one row of I as well as the different accounts.

  9. Click Save.