When a Line item Validation task is executed in the data monitor, all the validation rules of following two validation rule types are always run:
- Standard Validation: contains delivered validation rules. For example, released data, uploaded data and group journals are automatically checked against the breakdown category, i. e. are there missing or incorrect sub-assignments for FS items? Is there a subitem for the cash FS item? Is a partner unit missing for an intercompany FS item?
- Custom Validation: contains validation rules created by the customer. Released data, uploaded data and group journals are checked against custom validation rules. For example: is there a trading partner in an intercompany posting.
So all Line Item Validation tasks check the same validation rules!
Custom validation rules are maintained with the Manage Substitution/Validations Rules - Group Journal Entries app.
The following figure gives an overview of line item validations during the consolidation preparation process.
For the Line Item Validation of the Reported Financial Data and the Manual Postings according to the figure above, no task has to be defined, assigned and executed in the data monitor since the validation is automatically done in the background when data is provisioned.
For the Line Item Validation of the Data to Release, Released and corrected data and Rep. Data for staggered close according to the figure above, different Line Item Validation tasks have to be created and executed from the data monitor.
Especially for the Released and corrected data it is strictly recommended to run a subsequent line item validation task to check the data consistency since these data records are not checked during the entry on these posting levels.
To detect missing mappings between G/L accounts and FS items, assign content task S015 - Line item Val. on Acct. LIs to the data monitor and execute this Line Item Validation task before the data release task in the data monitor. You can then correct the missing mappings between G/L accounts and FS items and finally execute the data release task.
For example, you have the following entry in ACDOCA:
- Debit to account 10010000 that is mapped to FS item 111100.
- Credit to account 41000000 that isn’t mapped to an FS item.
- The data release task execution would bring in the 10010000/111100 line item but not 44000000 ... causing an out-of-balance.
- Correct the mapping: account 41000000 is mapped to FS item 411100.
- Execute the data release task.
The Line Item Validation task can be run in the data monitor or using the Schedule Jobs for Consolidation Tasks app.
Note
If there’s an error result when executing the Line Item Validation, subsequent tasks can't be blocked in the data monitor.