Overview of Cross-Validation Rules in General Ledger
You can use cross-validation rules to determine the valid account combinations that can be dynamically created as users enter transactions or journal entries.
Once enabled, a cross-validation rule determines whether a selected value for a particular segment of an account combination can be combined with specific values in other segments to form a new account combination.
For example, your organization has determined that the company Operations can't use the Marketing cost center. You can define a cross-validation rule such that, if the company is Operations, then validate that the cost center isn't Marketing. New account combinations have to satisfy all of the cross-validation rules enabled for the chart of accounts before they can be created.
Entry and Maintenance
This table describes the different methods that you can use to enter and maintain cross-validation rules.
Method | Navigation | What You Can Do |
---|---|---|
Manage Cross-Validations page, Rules tab | In the Setup and Maintenance work area, use the Manage
Cross-Validation Rules task in the Financial Reporting
Structures functional area. Note: As an alternative navigation,
select the Manage Cross-Validation Rules action on
the Manage Chart of Accounts Configuration page. |
|
Cross-Validation Rules Import file-based data import (FBDI) | Access the FBDI template from either of these locations:
|
Create and edit large volumes of cross-validation rules |
Create Cross-Validation Rules desktop-integrated spreadsheet | In the Setup and Maintenance work area, use the Create Cross Validation Rules in Spreadsheet task in the General Ledger functional area. | Create a large volume of cross-validation rules. |
To edit error messages for cross-validation rules, use this task in the Setup and Maintenance work area:
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Manage Messages for General Ledger
When you export or import cross-validation rules to a new instance using an export or import project in the Functional Setup Manager, you must add the Manage Messages for General Ledger task before the Manage Cross-Validation Rules task. You must export or import the messages before exporting or importing the cross-validation rules.
Existing Account Combinations
If existing account combinations violate newly enabled cross-validation rules, those account combinations continue to be valid. Before you disable existing account combinations that violate your rules and that you no longer use, move the balances in those accounts to the correct accounts. Then disable the account combinations to prevent further posting. Best practice is to define and enable cross-validation rules before account combinations are created, transactions or journal entries are imported or entered, and balances are loaded.