System Setup For Intercompany Validations

Intercompany validations are used to ensure that intercompany data entered into the Longview system matches the trial balance data loaded for the intercompany accounts.

Configuring the intercompany validation hierarchy

The Solutions Framework creates a symbol called VR_Intercompany under the accounts structure ACCOUNTS_ValRep. Each symbol attached to the VR_Intercompany structure should hold validation rule data for a specific intercompany account.

To create an intercompany validation rule symbol:

1. Sign on to the Longview Application Administrator.
2. Select Symbols.
3. Select Accounts.
4. Expand ACCOUNTS_System.
5. Expand ACCOUNTS_ValRep.
6. Right-click on VR_Intercompany and select New Symbol...
   1. Name the symbol VR_<Rule ID> where <Rule ID> is the ID that you will give the intercompany validation rule (described in the next section of this document). For example, VR_1500010.
      • For more information on rule naming conventions, see “Rules” in the Solutions Install Guide.
   2. Set the description of the symbol to describe what the validation will store. For example, “Intercompany AR does not match trial balance”.
   3. Set the Type to Standard.
   4. Set the Balance type to Neither.
   5. Set the weight to 0.

Setting up the Intercompany validation rule

One validation rule must be created for each intercompany account that you would like to be able to run a validation report against.

Note: Before you can create your intercompany validation rule, the intercompany validation rule symbol must be created. For more information, see Configuring the intercompany validation hierarchy.

To create an intercompany validation rule:

1. Sign on to the Longview Application Administrator.
2. Right-click on Rules and select New Rule...
3. Fill in the following fields:

   1. Rule ID: Set the Rule ID to be the same Rule ID specified when creating the validation rule symbol. For example, 1500010.

   2. Description: Set the description to what the validation rule will validate. For example, “Intercompany AR matches trial balance?”.

   3. Rule Type: Select Validation.

   4. Rule: Enter the syntax for the intercompany validation rule. For additional details, see “Writing Validation Rule Statements” in the Longview Application Administrator Guide.

   5. Error Message Template: Set this to N/A.

4. Click OK.

Example: Intercompany validation rule syntax:

KLX(VR_1500010,ACTUAL_YTD###,ENTITIES_ALL###,CONS_IC,SCENARIOS_Actual###,CURRENCIES_ALL###) = SCH(ICStandard,AR,ACTUAL_YTD###,ENTITIES_ALL###,CONS_IC,SCENARIOS_Actual###,CURRENCIES_ALL###,#TOTAL)-KLX(AR,ACTUAL_YTD###,ENTITIES_ALL###,MGMT,SCENARIOS_Actual###,CURRENCIES_ALL###)

Where:

• VR_1500010 is the name of the validation symbol that will store the validation results. See Configuring the intercompany validation hierarchy.
• AR is the name of the intercompany account being validated. This can be updated to your specific intercompany account.
• Actual_YTD is the name of the time period being validated. This can be updated to your specific time period.
• All other symbols listed above should remain the same.
• For any customer specific dimensions, use the symbol as defined by system attribute ASIC(X)INPUT