Formula Validations
  • 1 Minute to read
  • Dark
    Light
  • PDF

Formula Validations

  • Dark
    Light
  • PDF

Article summary

To configure the Formula Validation for Trial Balance and Balance Sheet Report information, perform the following steps:

  1. Access the Consolidation Control Panel and click the Validations process.

  2. In the center pane of the Consolidation Control Panel, click the Add button to add a new Formula Validation.

  3. On the Add Validation page, drag and drop the Balance account to the Left Hand Side, which is mapped in the Consolidation Setup.

  4. Select the equal (=) Operator.

  5. Enter zero (0) on the Right Hand Side.

If the Validation is successful, meaning that the balance of the balance account in local or common currency is equal to ‘0’ then the Balance Sheet is balanced. If the Validation fails, meaning that the balance of the balance account is not equal to ‘0’, the Balance Sheet is not balanced.

Note:
This Validation must be run after the Consolidation Process is complete. So, first, you will run the Consolidation Process, then you will run this Formula Validation to check the results.

Was this article helpful?