Consolidation
Form ID: (GL103000)
The parent company uses this form to set up consolidation with its consolidation units (that is, subsidiaries). The system uses the information provided on this form to import consolidation data from the consolidation units. For more detailed information, see GL Consolidation: To Prepare the Consolidation Unit.
Form Toolbar
The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.
| Button | Description |
|---|---|
| Synchronize | Synchronizes the data for the consolidation units you have selected in the table (by using the Included check boxes)—that is, imports the list of source ledgers from the units. For these ledgers, the Consolidation Source check box have to be selected on the Ledgers (GL201500) form. |
| Synchronize All | Synchronizes the data for all consolidation units. |
Summary Area
In this area, you can select a consolidation segment by the number that defines the position of the segment in the segmented key.
| Element | Description |
|---|---|
| Consolidation Segment Number |
Optional. The ID of the segment in the subaccount segmented key of the parent company that is reserved for identifying a subsidiary when the consolidation process is performed. The system inserts the specified subaccount segment value of each subsidiary into this segment. You specify the appropriate segment values for each required subsidiary in the Consolidation Segment Value column of the current form. Note that the consolidation segment is not involved in mapping, because the subsidiary does not contain a similar segment in its subaccounts. |
Table
In this table, you 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, you can use one ledger for actual data and another for budget data.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
| Column | Description |
|---|---|
| Included | An unlabeled check box that indicates (if selected) that the ledger specified in this row will be used to consolidate data from the consolidation unit if you click Synchronize. |
| Active | A check box that indicates (if selected) that the ledger is active. |
| Consolidation Branch |
The branch of the consolidating company to which the data will be imported. This column is available only if multiple branches or companies are used in your system. If only one branch is used in the system, the system automatically fills in this column with this branch. |
| Consolidation Ledger | The ledger of the Actual type (of the parent tenant) to hold the imported records from the consolidation unit or units. |
| Consolidation Segment Value |
The segment value used to identify the consolidation unit. The system inserts this value into the specified segment (that is, the segment that is specified in the Consolidation Segment Number box) of the parent's company subaccount during the consolidation process if the Paste Segment Value check box is selected. This column appears on the form only if you select a segment ID in the Consolidation Segment Number box. |
| 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. This column appears on the form only if you select a segment ID in the Consolidation Segment Number box. |
| Consolidation Unit | The description of the consolidation unit. |
| Username |
The combination of the username to be used to sign in to the MYOB Advanced website of the consolidation unit and the username of the consolidation unit entered in the following format: your username@tenant username—for instance, admin@Headquarter. On the Access Rights by Screen (SM201020) form in the tenant with the consolidation unit, you need to make sure that this user account can access the needed consolidation forms. You should verify that a role of the user has the Delete access rights to the following forms, which can be found in the Hidden node of the left pane:
|
| Password | The password associated with the user name. |
| URL | The address of the consolidation unit website. |
| Source Ledger | Required. The ledger of the consolidation unit that should be used as a data source for consolidation. The list of ledgers appears for selection in this column after you click Synchronize on the form toolbar and the synchronization process is completed; you must then select the source ledger to be used. |
| Source Company/Branch |
The consolidation unit or a branch of the consolidation unit. The lookup table for this cell displays the following organizational units:
Branches of companies with the With Branches Not Requiring Balancing type are NOT shown in the lookup table. Note: If a company of any type is specified in this column, the consolidation
process that is run on the Import Consolidation Data (GL509000)
form will consolidate the balances of all the branches of this company.
|
| Start Period | The first period for which the data should be imported. |
| End 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 system updates this value 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 indicates (if selected) that account and subaccount validation should be bypassed. |