As a result of the Check Reconciliation process, the following tables are updated:
The Check Exception table is used to store records of disbursements that are not successfully matched with a bank's record during the automated Check Reconciliation process. Each record on the Check Exception (CHKEXCP) table includes a corresponding Exception Code and Exception Reason, indicating what caused the record to fail during the reconciliation process.
Conditions that cause a disbursement to be written to the exception table include:
Instrument Not Found in Financial System (the check information sent by the bank cannot be located in the Advantage application)
Bank Amount Greater than Book Amount (from system's records on the Check Reconciliation table)
Book Amount (from system's records on the Check Reconciliation table) Greater than Bank Amount
Check Cancelled in Financial System
Check Stale Dated, Escheated, or Voided in Financial System
Record Deleted from Exception Table
Non-Sufficient funds
Check Stopped in Financial System
Check Undeliverable in Financial System
The Check Reconciliation process moves records from the Check Reconciliation table to the Paid Checks table if the Cleared Date is populated and the Status is not Disbursed/ Warranted. Records are moved to the Paid Checks table with their current Status (for example, Paid or Cancelled) on the Check Reconciliation table. All fields of this table are protected. Records can only be moved from the Paid Checks table to the Check Reconciliation table, by using the Move to CHREC action on the Paid Check Restore Mass Update page. Please refer to "Paid Check Restore" topic or the "Restore a Record on Paid Check Restore" topic for more information.
This report lists all records and corresponding exception codes resulting from the automated Check Reconciliation process.
For more on the Check Reconciliation process, please refer to the CGI Advantage - Accounts Payable Run Sheets guide for Check Reconciliation chain jobs.
This report summarizes the number of records reconciled and the exception records that were generated by the current run of the Check Reconciliation process.
For more on the Check Reconciliation process, please refer to the CGI Advantage - Accounts Payable Run Sheets Guide for Check Reconciliation chain jobs.
The Warrant Reconciliation Transaction Exception Report provides a list of the Warrant Reconciliation transaction records that was not submitted to Final generated by the current run of the Generate Warrant Reconciliation Transaction process.
For more on the Generate Warrant Reconciliation Transaction process, please refer to the CGI Advantage - Accounts Payable Run Sheets Guide for Check Reconciliation chain jobs.