Manage consolidations

Creating a consolidation entity structure in Longview allows you to prepare your system for:

• Posting of journal entry adjustments to your consolidated entity.
• The automatic posting of elimination journal entries to the consolidated entity.

Sample consolidation entity hierarchy

Creating a Consolidation

The Manage Consolidations app allows you to easily create a consolidation entity structure. When creating a consolidation symbol, the following will automatically be performed:

1. An elimination and adjustment hierarchy will be created under the consolidation entity (i.e.: E10000CEA)
2. A consolidation adjustment entity will be created under the elimination and adjustment hierarchy (i.e.: E10000CA)
3. An elimination entity will be created under the elimination and adjustment hierarchy (i.e.: E10000CE)
4. The consolidation adjustment entity will be placed under the ENTITIES_ConsA hierarchy. The ENTITIES_ConsA structure allows certain Longview system processes to skip running on consolidation adjustment entities where required.
5. The elimination entity will be placed under the ENTITIES_ConsE hierarchy. The ENTITIES_ConsE structure allows certain Longview system processes to skip running on elimination entities where required.
6. On the consolidation entity (i.e.: E10000C), the elimination entity symbol attribute (ZElimEntity) will be set to the elimination entity (ie: E10000CE).

   For more information on setting up intercompany eliminations, see “Working with intercompany eliminations” in the Longview Application Administrator Guide.

7. The native currency for the consolidation entity and its structure will be set

Note: Currencies must be set up prior to setting up the entities in your system. For more information, see Managing currencies.

Total symbols (parents or groupings) can also be created to help organize the entity hierarchy structures. For example, entity symbols to group by country (Canada, USA etc.)

Accessing manage consolidations

1. Select the Consolidate module.
2. Select the Administration category.
3. Expand Entities.
4. Click Manage Consolidations. The Manage Consolidations dialog appears and contains the following options:
   • Import
   • Manage
   • Export

Importing consolidations

The import option in the Manage consolidations dialog allows you to create and update consolidation entities in the database from a .csv file.

To import consolidations:

1. For Option, select Import.
2. Select the .csv file to import from.
3. Click OK. A table will be displayed showing the summary of all actions performed by the import.

.csv file example:

Entity,Description,Rollup Type, Functional Currency,Parent Entity,Sort Order

"E10000C","ABC Holding, Consolidated","C","USD","NULL",0.000000000

"E11000C","Alpha Holding, Consolidated","C","USD","E10000C",11000.000000000

"E12000C","Beta Holding, Consolidated","C","USD","E10000C",12000.000000000

where:

• Entity is the name of the consolidation or total entity.
• Description is the description of the consolidation or total entity.
• Rollup Type is either:
  • “C” if the entity will be a consolidation entity structure holding adjustments and eliminations. The following entities will also be created under the consolidation entity:
    • <EntityName>EA - To hold the eliminations and adjustment entities.
    • <EntityName>E - To hold eliminations.
    • <EntityName>A - To hold adjustments.
  • “T” if the entity will be a total. This would be a grouping or parent in the consolidation hierarchy. For example, CANADA to hold the Canadian entities.
• The Rollup Type of an existing entity can not be updated.
• Functional Currency is the functional currency of the entity

  Note: The functional currency must be a source currency (i.e.: in the CURRENCIES_Source hierarchy).

  Note: If the entity being created is a consolidation entity, the functional currency would apply to all elimination and adjustment entities created in the consolidation structure.

  Note: The functional currency of an existing entity can not be updated.

• Parent Entity is the name of an entity to assign the entity to. The entity will become a child of the specified parent, and the values in the parent will be calculated from all its children.

  Note: If the parent entity is left blank, the entity will be created or detached and made a root.

• Sort Order indicates the order of the entity under the parent, with lower numbers ordered before higher numbers.

Managing consolidations

The Manage option in the Manage consolidations dialog allows you to create, update and delete consolidation entities and structures from within the Manage consolidations table.

To manage consolidations:

1. For Option, select Manage.
2. Select the consolidation root to manage.

   Note: You may leave the entity selection blank to start with an empty table. This can be used if entities only need to be added or modified; not deleted.

3. In the Manage Consolidations table the list of total and consolidation entities under the selected root entity is displayed.

This section provides information on these main topics:

• Adding a consolidation entity
• Deleting a consolidation entity
• Modifying a consolidation entity
• Applying changes
• Refreshing the entities
• Importing into the entities table
• Exporting from the entities table

Adding a consolidation entity

1. Click Add to add a new consolidation entity. Consolidation entities are not added to the database until you click Apply.

   Note: You can add a new entity that has similar settings by selecting an existing row and clicking duplicate.

2. For each entity fill in the following fields:

   Field	Description
   Entity	Enter the name of the entity Note: The name of the entity is limited to 31 characters for a Total type entity and 29 characters for a Consolidation type entity.
   Description	Enter a description for the entity. Note: The description of the entity is limited to 100 characters for a Total type entity and 70 for a Consolidation type entity.
   Rollup Type	Select Consolidation if the entity will be a consolidation entity structure holding adjustments and eliminations. If a consolidation entity is created, the following entities will also be created under the consolidation entity: <EntityName>EA - To hold the eliminations and adjustment entities <EntityName>E - To hold eliminations <EntityName>A - To hold adjustments Select Total if the entity will be used as a parent to summarize a group of entities. For example, CANADA to hold the Canadian entities.
   Functional Currency	Select the functional currency for the entity. Note: The functional currency must be a source currency (i.e.: in the CURRENCIES_Source hierarchy) Note: If the entity being created is a consolidation entity, the functional currency would apply to all elimination and adjustment entities created in the consolidation structure Note: The functional currency of an existing entity can not be updated.
   Parent Entity	Select or enter the name of the parent symbol to assign the entity to. Note: If the parent entity is left blank, the entity will be created as a root. Note: The list only contains parents that already exist in the database. You can enter the name for the parent to make an entity being added into a parent.
   Sort Order	Enter a number to define the order of the entity under the parent. Entities are sorted from low to high.

Deleting a consolidation entity

Delete a consolidation entity by selecting the row and clicking delete. The entity is not deleted from the database until you click Apply.

Note: You cannot delete an entity that contains legal entities. You must first detach any legal entities from the entity structure.
For more information on legal entities, see Entities, Managing Entities

Note: If you delete a consolidation entity, this will also delete the related adjustment and elimination entities.

Modifying a consolidation entity

You can change the properties of an existing consolidation entity:

1. Modify the description by editing the value in the ‘Description’ cell.
2. Switch the parent of the entity by selecting or entering a new parent name.

   Note: The parent specified must either already exist in the database or be a new entity that will be added before the entity being modified.

   Note: If the parent entity is left blank, the entity will be detached from its parent and made a root.

3. Change the order the entity appears under its parent by modifying the sort order value.

   Note: Name, Rollup Type and Functional Currency cannot be modified for an existing entity.

No changes are applied until you click Apply.

Applying changes

To apply changes to the entities, click Apply.

For new rows in the table:

1. Each new entity will be added under the selected parent symbol with the specified sort order. If a consolidation entity is created, the following entities will also be created under the consolidation entity:
   1. <EntityName>EA - To hold the eliminations and adjustment entities.
   2. <EntityName>E - To hold eliminations.
   3. <EntityName>A - To hold adjustments.
2. Each new entity will update the ZGPNativeCurreny symbol attribute according to the functional currency specified.

Note: The functional currency must be a source currency (i.e.: in the CURRENCIES_Source hierarchy)

Note: For consolidation entities, the functional currency (ZGPNativeCurrency) will be set for the elimination and adjustment entities created in the consolidation structure

For modified entities:

1. Any description changes will be applied.
2. If the parent entity is changed, the entity will be reassigned to the new parent with the specified sort order. If the parent entity is left blank, the entity will be detached from it’s current parent and made a root.
3. Any changes to the sort order (same parent entity) will be applied.

For deleted entities:

1. Each deleted entity will be confirmed before deleting.

   Note: You cannot delete an entity that contains legal entities. You must first detach any legal entities from the entity structure.
   For more information on legal entities, see Entities, Managing Entities
   

   Note: If you delete a consolidation entity, this will also delete the adjustment and elimination entities in its structure.

   1. If confirmed, the related symbol(s) are deleted.
   2. Otherwise, the row(s) are restored to the table.

Results:

1. All actions performed are presented at the end of processing with:
   1. Each row identified by its row number.
   2. The action performed or the reason any error occurred.
2. Any valid changes, not cancelled, are applied.

Refreshing the entities

1. Click Refresh to refresh the list of entities.
2. Click Selections to change the selected entity and refresh the list of entities.

In either case, if there are any unapplied changes, you will be prompted to apply or discard any changes that have not yet been applied.

• Choose Apply Changes to apply any changes made, then refresh the list of entities. If there are any errors the refresh will not be performed.
• Choose Discard Changes to discard any changes made, then refresh the list of entities.
• Click Cancel to return to the table without refreshing the list of entities.

Importing into the entities table

Click Import to import from a .csv file into the entities table.

1. Select the file to import. See .csv file example: for import file format.
2. You may select the option to replace existing rows

   Option	Description
   Replace Existing Rows	If this option is checked, all rows in the table view will be cleared and replaced with the entities in the import file Note: This will only clear the entities from the table view. It will NOT delete any entities in the database
   Do Not Replace Existing Rows	If this option is unchecked, all entries in the import file will be appended to the table view. Note: Any entities that exist multiple times in the same import file will be initially duplicated in the table view. Any entities that exist in the import file AND already exist in the table prior to import will be initially duplicated in the table view. Once you click Apply, the settings for the last instance of the duplicate entity will be used.

3. Click OK. The file will be imported into the table.
4. Click Apply to save the changes.

Exporting from the entities table

1. Click Export to export from the entities table to a .csv file.
2. Select the .csv file to export to.

   Note: If the file selected does not currently exist, it will be created during the export process.

3. Click OK. A confirmation dialog will appear.
4. Click View File to view the exported file.