Consolidation (GL103000)
The parent company uses this form to set up consolidation with its consolidation units or subsidiaries. The system uses the information provided on this form to import consolidation data from the consolidation units. For more detailed information, see: General ledger consolidation overview.
This window is available only if the General ledger consolidation functionality is enabled in the Enable/disable functionalities (CS100000) window.
The window toolbar
| Button | Description |
|---|---|
| Synchronise | Synchronises the data for the selected consolidation units or imports the list of ledgers from the units. In the unit or subsidiary, these ledgers should be marked as Consolidation source in the Ledgers (GL201500) window. |
| Synchronise all | Synchronises the data for all consolidation units. |
The top part
In this area, you can select a consolidation segment by a number that defines the position of the segment in the segmented key.
| Element | Description |
|---|---|
| Consolidation segment number | The ID of a segment in the subaccount segmented key of the parent company. You reserve this subaccount segment for identifying a subsidiary once the consolidation process is performed. The system inserts a specified subaccount segment value of a subsidiary to this segment. The appropriate segment values are specified for each required subsidiary in the Consolidation segment value column of the current window. Note that the consolidation segment is not involved in mapping because the subsidiary does not contain such a segment in its subaccounts. |
The table
In this table, you can select different ledgers and particular branches in the parent company to consolidate data of different types from the consolidation units or from specific branches of those units. For example: Use one ledger for actual data and another for budget data.
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the ledger is active. |
| Consolidation company | The name of the consolidation company. |
| Consolidation branch | The branch of the consolidating company to which the data will be imported. |
| Consolidation ledger | The ledger (of the Actual type) to hold the imported records from the consolidation unit or units. |
| Consolidation unit | The description of the consolidation unit. |
| Username | The username to be used to sign in to the Visma Net website of the consolidation unit. |
| Password | The password associated with the user name. |
| URL | The address of the consolidation unit website. |
| Source ledger | The ledger of the consolidation unit that should be used as a data source for consolidation. The list of ledgers appears after you click Synchronise on the window toolbar. |
| Source branch | The branch of the consolidation unit. |
| From period | The period starting which the data should be imported. |
| To period | The last period for which the data should be imported. |
| Last post period | A read-only value that displays the financial period of the last consolidation. The value is updated each time a consolidation has been performed. |
| Last consolidation date | A read-only value showing the date of the last consolidation. |
| Bypass account/sub. validation | A check box that, if selected, indicates that account and subaccount validation should be bypassed. |
| Consolidation segment value | The segment value used to identify the consolidation unit. This value will be inserted to the specified segment (in the Consolidation segment number field) of the parent’s company subaccount during the consolidation process if the Paste segment value check box is selected. |
| Paste segment value | A check box that indicates (if selected) that the consolidation segment value is added to the specified subaccount segment of the parent company during the consolidation process. |
Parent topic: General ledger windows - overview
Related reference