Overview

General Ledger > General Ledger Batch Processes > scrubberJob > Data Validation

Overview

Data is validated before being posted to the General Ledger to ensure that it is complete and correct.

Financials transaction documents generate pending ledger entries automatically. Financials validates transactions created via documents in various ways, using the Chart of Accounts and business rules to ensure that the entries generated are complete and without errors. Even so, these transactions undergo the same scrubber validation as entries from other sources to catch anything that may have happened after a transaction is approved.

Transactions that are fed into Financials from an outside system (such as a payroll or external billing system) are more likely to send data in need of correction because they may not be integrated with the Chart of Accounts. For example, an external system might try to apply expenses to a closed account because that external system does not have access to the data in the Chart of Accounts.

The transaction validation process checks to make sure that accounting string values (such as account, object code and sub-object code) are valid. It also ensures that the transaction has proper identifying information (such as a document number, document type and origination code indicating the system it came from.

Because some systems may not be capable of providing all of the information required to post a General Ledger transaction, the scrubber may assign some attributes to complete the transaction.

If necessary, the scrubber can assign a fiscal year, fiscal period, and transaction date to a transaction based on the system date (which is determined by the date on which the batch process is run). It can also assign an object code type based on the object code of the transaction.

Unless otherwise noted, documents associated with any transaction that fails the following validations will not post.

The error records will be placed in the ScrbErr file (For more information about this file and other files generated by the General Ledger batch processes, see Scrubber Files. This file can be retrieved using a General Ledger Correction Process (GLCP) document which allows for the manual correction of errors so the associated documents may be re-posted in a future batch cycle.