Formula Validation
- 1 Minute to read
- Print
- DarkLight
- PDF
Formula Validation
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
To configure the Formula Validation for Trial Balance and Balance Sheet Report information, perform the following steps:
Access the Consolidation Control Panel and click the Validations process.
In the center pane of the Consolidation Control Panel, click the Add button to add a new Formula Validation.
On the Add Validation page, drag and drop the Balance account to the Left Hand Side, which is mapped in the Consolidation Setup.
Select the equal (=) Operator.
Enter zero (0) in 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 results.
Was this article helpful?