A/P Integrity Checker Fields

Sage 300 ERP

A/P Integrity Checker Fields

Check

Select the Check option for the records in the list for which you want to check data integrity.

Check For Orphan Records

Select this option to check the integrity of records in all database tables that have become dissociated from their "parent" record.

For example, entry records are nested under parent batch records, and detail records are nested under parent entry records.  These records are "children" of the parent.

Child records that are no are longer associated with a parent are called "orphans."

Delete Orphan Records

Select this option to delete records that have become dissociated from their "parent" record.

Records that belong to a larger collection of records but are no are longer associated with a parent are called "orphans."

For example, entry records belong to parent batch records, and detail records belong to parent entry records.

Fix

Select the Fix option to fix minor errors found in the selected records.

Open And Ready To Post Batches

Select the Open And Ready To Post Batches option to check for errors in all records that belong to unposted invoice, payment, and adjustment batches.

Posting Journals

Select the Posting Journals option to check for errors in posting journals.

If you select the option to fix minor errors, the program will also fix minor errors found in these records.

If you select the option to check posting journals, the program will find but not fix the errors.

Setup Tables

Select the Setup Tables option to check for errors in all A/P setup records, such as Options, Account Sets, and Payment Codes.

Vendor Documents (From Vendor/To Vendor)

Select the Vendor Documents option to check all records that store information for vendor payments for the range of vendors you specify.