1. Home
  2. /
  3. User Guides
  4. /
  5. Financials
  6. /
  7. General Ledger
  8. /
  9. Company consolidation
  10. /
  11. Working with company consolidation
  12. /
  13. Validate a consolidation

Validate a consolidation

Related topics

Two menu items apply for this task:

  1. Create interface file
    where you create company consolidation files. This is the normal, periodical program to run in order to transfer values from originating companies to a corporate company.
  2. Create interface file for opening balances
    where you create company consolidation files for the start-up of opening balances for originating companies, which you normally only do once for each company.

Through this routine you can validate the relationship between the originating companies and the corporate company to see if a consolidation can be done without any errors. The validation is performed according to the account hierarchy and conversion setups established in Define the consolidated relationship between the corporate and originating company and Define the components of the consolidation conversion. Only one accounting year can be created at a time. Next time you run this program with the same or another year, old values will be cleared in the interface files.

Note: This program can only be reached if you are working in an originating company.

A report is always printed, showing if any errors have been found. There are two types of errors:

    1. One is showing which account numbers could not be converted.
    2. The other one is showing in which periods there is a debit/credit difference.

Errors can be corrected in the following routines:

  • Work with consolidation company hierarchy
  • Work with account/sum id part conversions
  • Work with chart of accounts, including summary id’s, in the originating company, and in
  • Work with chart of accounts in the corporate company.
  1. Select the Create interface file menu item.
  2. You access Create interface file. In the fields below, make the selections for the creation of the originating company’s consolidation data.
    3. Accounting year
    Select the accounting year to include in the selection. Note: Only one accounting year can be created at a time.
    Conversion report
    Indicate if you want to print a conversion report of the accounts that can be created without error indications.

    Click OK.

    Create interface file for opening balances

    This is a similar program to the one described above. The difference is that in this program you create company consolidation files only for opening balances for the originating companies. This is a one time operation at start-up.

    Note: All open periods in the originating company has to be connected to a period in the corporate company, which is done in the Work with consolidation company hierarchy routine. If there is one period which is normally not transferred to the corporate company, you have to temporarily connect it to a period in the corporate company for this routine.

    Exit the routine.

Related topics