Discussing Group Reporting Validation and Substitution

Objective

After completing this lesson, you will be able to explain group reporting validation and substitution

Group Reporting Validation and Substitution

Substitution and Validation - Journal Entries

Before a group journal entry is posted, the system performs checks to make sure that the data is complete and correct.

You can define your own substitution rules and validation rules for this data check in the Manage Substitution/Validation Rules - Group Journal Entries app to validate, derive, or replace values for the relevant fields of a business context at the time of entry.

Validations check the values entered for the relevant fields or functions defined in the group reporting validation rules. When a value entered doesn't comply with the rule, a warning or an error message can be raised which helps to correct the values entered if necessary.

This screenshot shows the validation screen in the Manage Substitution/Validation - Journal Entries app.

A substitution derives, replaces, or clears values for the relevant fields or functions defined in the substitution rules. The substitutions take place at the time of data entry with no system messages.

This screenshot gives an idea of the substitution screen in the Manage Substitution/Validation - Journal Entries app.

You can create substitution rules, for example for the following business processes if you select the GR Journal Entry Item context in the Manage Substitution/Validation Rules- Group Journal Entries app:

Consolidation Process
Analytics for Group Reporting
Journal Entries.

Summary

Validation rules check field values against defined conditions during data entry.
Substitution rules automatically derive, replace, or clear field values.
Validations raise messages; substitutions execute silently at data entry time.

Next lesson