Formula Validations

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.