Select this option if you want the program to check unposted documents in Accounts Payable to ensure that no entries are for contracts that have Closed, Completed, or Estimate status.
Select this option if you want the program to check unposted documents in Accounts Receivable to ensure that no entries are for contracts that have Closed, Completed, or Estimate status.
Select this option if you want the program to check unposted documents in Canadian or US Payroll to ensure that no entries are for contracts that have Closed, Completed, or Estimate status.
Select this option to check that the sum of category totals equals the project totals, and that the sum of the project totals equals the contract total for each contract in the range of contracts that you specify. The program also checks the validity of some fields, such as Invoice Type.
Select this option to have the program check that the next transaction number for a contract is correct, for the range of contracts that you specify.
(The program maintains a sequence of transaction numbers for transactions have affected the contract totals.)
Check this option to ensure that transactions, worksheets, and other records use valid line numbers.
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 that are nested under parent batch records, and detail records that are nested under parent entry records, are "children" of the parent.
Child records that are no are longer associated with a parent are called "orphans."
Select this option to check for any remaining closing entries for contracts that have been deleted.
If you also select the option Fix Minor Errors (on the Data Integrity screen), the program deletes the closing entries.
Select this option to check that the sum of commitments in a contract equal the sum of all the detail lines in purchase orders processed for the contract.
Select this option to check for projects incorrectly marked as listed on revenue recognition worksheets.
Select this option to have the program check that unposted Project and Job Costing transactions do not affect audit data, which could prevent posting of new transactions.
The program also checks that all unposted transactions are valid.
Overview
This screen opens when you select Project and Job Costing on the Data Integrity screen (in Administrative Services), then click Application Options. It lets you limit the scope of integrity checks to fit the time available.
The PJC Integrity Checker lets you specify:
- The type of data to check.
- Whether to check for or delete orphan records.
- Whether to check records sent from other Sage 300 programs to Project and Job Costing.
- Whether to check closing general ledger entries.
- Whether to check revenue recognition entries.
- A range of contract records to check.