Inputting Intercompany Investment Data

The Intercompany Investment Input App is used to enter intercompany investment detail into the Longview system.

To input intercompany investment data:

1. In the Longview Client, open the Consolidate module.
2. Select Data Collection and expand Input.
3. Select an entity.
4. Click Intercompany Investment Input.
5. Select a time period (default is current period). If you did not select an entity in step 2 you can select it now.
6. Click OK. A table displaying intercompany investment transactions appears.

You can add, delete, and modify intercompany transactions.

Adding intercompany investment detail

1. Click Add to add a line of intercompany investment detail data. Data is not uploaded until you click Submit.

   Note: You can add a line of intercompany investment detail that has a similar intersection as another row by selecting the existing row and clicking duplicate.

2. For each line of intercompany detail, fill in the following fields:

   1. Investment Account: Select the investment account to submit the intercompany data to

   2. Ownership Account: Select the ownership account to enter the ownership percentage to.

   3. Ownership %: Enter the percentage of the entity that is owned via the investment.

   4. Entity: Select the contra entity to submit the intercompany data to.

      Note: Only the entities that allow Intercompany transactions to be recorded against them (where attribute ZElimAllowICTransactions is set to TRUE) will be listed.

   5. Data View: Select the Data view symbol to submit the intercompany data to.

      Note: The Data views available for selection are child symbols of NOCORP_Total.

   6. Scenario: Select the Scenario symbol to submit the intercompany data to.

      Note: This column will only display if you have more than one leaf scenario under the Scenarios_Actual hierarchy.

   7. Additional Dimension: Select a symbol from any additional dimension to submit the intercompany data to.

      Note: Additional Dimension columns will only display if your system has any custom dimensions, and the associated ASICD(X)INPUT attribute is set to a parent symbol. For more information, see “Updating the intercompany input symbols for custom dimensions” in the Solutions Administrator Guide

   8. Investment Amount: Enter the investment amount for the specified intersection.

Deleting intercompany investment detail

Delete intercompany investment detail by selecting the row and clicking delete. Alternatively, you can zero out the balance for the row.

The intercompany detail is not deleted until you click Submit.

Editing intercompany investment detail

You can change the symbols the intercompany investment detail is submitted to by changing the symbols in the intercompany investment input view. You can change the amount of the ownership percentage and/or investment amount by updating the related value. No changes are applied until you click Submit.

Applying changes

To apply changes to the intercompany details, click Submit.

Note: Any symbol intersections that exist multiple times will be initially duplicated in the table view. Once you have submitted and refreshed the data, the balance for any duplicate intersections in the intercompany input view will be aggregated.

Importing into the intercompany investment input view

1. Click Import to import from a .csv file into the intercompany input view.
2. Select the file to import. See .csv file example:
3. Select one of the following options to replace existing rows:

   1. Replace Existing Rows: If this option is checked, all rows in the table view will be cleared and replaced with the intercompany data in the import file.

      Note: Upon submission, this will also delete these intercompany investment values from the database.

   2. 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 symbol intersections that exist multiple times will be initially duplicated in the table view. Once you have submitted and refreshed the data, the balance for any duplicate intersections in the intercompany investment input view will be aggregated.

4. Click OK. The file will be imported into the table. 
5. Click Submit to submit the data.

.CSV File Example

Note:

• Account and Data view must be surrounded by brackets [] in your .csv file.

• Your .csv import file should match the columns in the intercompany Investment input view. If additional dimension columns are visible in your view, these dimension symbols would need to be added to the import .csv file.

Validating Intercompany Investment Detail Against the Trial Balance

The intercompany data entered into the intercompany input view should match the corresponding intersections in the trial balance.

To validate the intercompany data against the trial balance:

1. From within the Intercompany Input View, click Validate Against Trial Balance.
2. The validation view will open displaying the following:

   1. Investment Account: Any intercompany investment account that has an investment or Trial Balance amount loaded.

      Note: For any non-standard dimensions, the total amount as determined by the ASICD(X)INPUT attribute will be displayed.

   2. Investment Amount: The total intercompany investment amount entered to the intersection

   3. Trial Balance Data: The Trial Balance amount entered to the intersection.

   4. Variance: The difference between the Trial Balance Data – Intercompany Investment Input.

   5. Data View: Any Data View that has an intercompany investment or Trial Balance amount loaded.

   6. Scenario: Any Scenario that has an intercompany investment or Trial Balance amount loaded.

      Note: This column will only display if you have more than one leaf scenario under the Scenarios_Actual hierarchy.