Validations

Validations ensure proper data values and general accounting standards exist within the application. For example, a Validation might check to see if an account is zero before making the decision to run the Consolidation Process. Or, that a group of accounts should be equal to another account before allowing data to be saved to the application. Validations also ensure proper adherence before executing the Consolidation Process.

Validation functionality allows you to create Validations that should be successfully passed before subsequent actions can be performed. You can create your own Validation methodology to help you manage your Consolidation Process. Validations can be applied to certain aspects of the Consolidation Process to ensure proper usage of the system and adherence to corporate or accounting standards.

Validations can be made executable by end users at different levels within the hierarchy (including interim rollup levels) to ensure accurate results. In addition, Validations should be executed prior to a Consolidation Process to ensure that accurate results are being consolidated.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Click Add. The Add Validation dialog appears.

3. 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.

4. 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 and functions into the Left Hand Side and 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.

5. 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 box.

6. Click Save.

You manage formulas when adding, copying, and editing a Validation. The following elements are available to manage a formula.

• Left Hand Side and Right Hand Side —The left-hand and right-hand portion of the formula that can include members, functions, or both. You can also click inside the box to edit members and functions directly. A copy-paste is also allowed inside the box.

  If the data entered in the Left Hand Side and Right Hand Side returns no data, the application validates as if the data is equal to zero (no data). After the Validation, the result may be a pass or fail based on each case. For example, if LHS(0)=RHS(0), the status is pass.

• Operator —Contains various operators to build a meaningful formula. Select an operator for the formula. Use a combination of mathematical operators to build full expressions, including multiple components, if desired.

  Example formulas are:

  • Sum(Acct1,Acct2,Acct3)=Acct4

  • (Acct1+Acct2)-(Acct3)=Acct4

  • Acct1*70%=Acct2

  • Acct1>0

  • Acct/Acct2 = Acct3/Acct4

When a formula based Validation is defined using an equal to (=), less than or equal to (<=), or greater than or equal to (>=) operator, the absolute difference between the LHS and RHS is displayed for your convenience. For example, if account 1 is not equal to account 2, the difference between the accounts is displayed.

• Check Syntax —Click √ to verify whether the formula is syntactically correct.

• Clear Formula —Click Clear Formula to clear the formula. The Clear Formula option is available for both the Left Hand Side and Right Hand Side boxes.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Click Add (or Edit or Copy). The dialog to add, edit, or copy a Validation appears.

3. Click the Formula tab.

4. Build a formula by performing the following steps:

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

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

   3. Optional. Click √ to check the syntax of the formula. A status message will appear below the Left Hand Side and Right Hand Side boxes indicating whether or not the syntax is correct.

5. Clear a formula in the Left Hand Side box or Right Hand Side box by performing the following step:

   1. Click Clear Formula associated with the Left Hand Side box or Right Hand Side box.

6. Click Save.

Only the mapped members are considered when you run the Validation Process. You manage mappings when adding, copying, and editing a Validation.

To map and unmap members :

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Click Add. The Add Validation dialog appears.

3. Click the Mappings tab.

4. Map members by performing the following steps:

   1. In the hierarchy, locate members by entering the search criteria in the Search box or expand the hierarchy.

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

5. Unmap 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 box.

      OR

   3. In the Mapped Companies pane, locate the member you wish to unmap by entering the search criteria or by using the scroll bar, then drag and drop the member from Mapped Companies box into the hierarchy on the left.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Select a Validation.

3. Click Copy and select Copy Single. The Copy Validation dialog appears.

4. Complete Code, Name, and all other fields available on the Formula tab and Mappings tab.

5. Click Save.

1. Access the Consolidation Control Panel.

2. Select the scenario you want to copy the Validations from.

3. Select a process and click the checkbox next to the entry you want to copy.

4. Click the Copy icon. Select Copy Multiple. The Copy page appears.

5. Enter a Code and Name and select period dates.

6. Select the Target Scenario.

7. Complete all selections based on process being copied.

8. Click Save.

If you select Validations to copy, the Copy Single option will not be available.

You will want to edit a Validation to add, edit, or delete mapping members, prior to processing a Validation.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Click the Edit icon. The Edit Validation dialog appears.

3. Edit Code, Name, and any other fields on the Formula tab and Mappings.

4. Click Save.

You can delete unused or inactive Validations.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Select the Validation.

3. Click Delete.

4. In the confirmation dialog that appears, click OK. The Validation is deleted.

You can process only active Validations. The Validation is performed on the mapped members to confirm whether the calculations pertaining to those members have produced accurate results.

1. In the Consolidation Control Panel, under Processes, click Validations. The Validations grid appears.

2. Select the active Validation, under Entry Actions, click Process. The Process Setup dialog appears.

3. The Scenario field is read-only and indicates the scenario used when processing the Validation.

4. Select the fiscal Year by using the calendar icon.

5. Select the Period by selecting a month range.

6. Select the Reporting currency type. Available currency types are Common Currency (CC) and Local Currency (LC).

7. Select the E-mail Notification checkbox if you want to send notification about results when the process is complete, and enter email addresses of recipients you wish to notify.

8. Click Process. The Process Setup dialog is exited. A message appears indicating that the Validation is submitted for processing based on the selected periods, and includes a link to navigate to the Detail View for status.

Planful provides you with pre-defined Validations to support your general financial and accounting practices and ensure proper reporting.