How to Add a Validation

To add a validation, do the following:

1. Navigate to Consolidation to open the Consolidation Control Panel

2. Click Validations under Processes. The Validations grid appears.

   

3. Click Add. The Add Validation dialog appears.

   

4. Complete the following fields:

   • Enter a code of your choice in the Code field. The code that you enter should correlate with your company's accounting identification practices.

   • Enter a name in the Name field.

   • Select one of the following Validation Types:

     • Report Validations —Created for reporting verification and Validation purposes. Report Validations are system-defined and cannot be deleted or edited.

     • Formula Validations —Specific to your operations. For example, create a Formula Validation to determine whether account A plus account B equals to account C.

5. Click the Formula tab. The Formula tab is available if the Validation Type is Formula. In Formula, you create a Validation formula by selecting members and functions. By default, Members are shown. Click Functions to display available functions. Set up a formula by performing the following steps:

   1. From within Members and Functions, drag and drop members into the Left Hand Side and functions into the Right Hand Side boxes as necessary.

   2. Select the operator from the Operator drop-down list.

   3. Optional. Click √ to check the syntax of the formula. For more information, see Manage Formulas.

6. Click the Mapping tab, and map members by performing the following steps:

   1. In the hierarchy, locate the member by entering the search criteria in the Search box or expanding the hierarchy.

   2. Select the checkbox next to the members or drag and drop the members from the hierarchy into the Mapped Companies box.

7. Click Save.