Understanding the Refresh Reconciliation File Program

Before you reconcile your accounts, you must run the Refresh Reconciliation File program (R09130). Typically, you run this program at the end of each period to reconcile transactions for the period. The Refresh Reconciliation File program copies the unreconciled transaction detail for all reconcilable accounts from the F0911 table into the F0911R reconciliation table.

Each time that you refresh the F0911R table, the system removes all previously reconciled transactions in the table and replaces them with new transactions that meet the processing option and data selection criteria for the Refresh Reconciliation File program. For example, if you run this program for the month of January and reconcile all transactions for that month, and then run the program again for February, the program removes all the reconciled transactions for January from the F0911R table and replaces them with the unreconciled transactions for February.

Transactions must meet these criteria for the Refresh Reconciliation File program to select records:

• The account that you are trying to reconcile must be within the AAI range for GLRCxx.

• The general ledger date for the transaction must be within the date range specified in the Beginning Date and Ending Date processing options.

• The GLRCND field for the transaction must be blank (unreconciled).

When you run the Refresh Reconciliation File program, you can refresh the information for all accounts in the AAI ranges for GLRCxx at one time, or you can use data selection to refresh a specific account.

The Refresh Reconciliation File program is designed to build only one F0911R table. However, you can allow separate workfiles for specific accounts by using the Configured Network Computing function to point to the F0911R table locally.