Understanding the G/L Account Reconciliation Program (R09150)

The R09150 program selects records from the F0911R table based on the processing options for the program and the data selection that you enter. You specify whether to reconcile accounts payable trade accounts, accounts receivable trade accounts, voucher logging accounts, RNV accounts, or Performance Liability accounts using the Type of Account to Reconcile processing option.

You then specify accounts within this type in the data selection for the program. The system uses a different algorithm for reconciling each type of account. Therefore, the account type that you specify in the processing options must match the account type of the accounts that you enter in the data selection. The system executes the reconciliation algorithm based on the account type that you enter and reconciles the accounts that you specify in the data selection.

Before reconciling transactions, the R09150 program first reviews the GLOFM (G/L offset method) field for transactions in the Account Ledger table (F0911). This field identifies which offset method is specified in the JD Edwards EnterpriseOne Accounts Payable and Accounts Receivable system constants. If the value in this field is B (one offset for each batch of transactions by account) for either Accounts Receivable or Accounts Payable, the system does not perform account reconciliation for the transactions for that system. You cannot use the R09150 program to reconcile transactions for which the value in the GLOFM field is B. The GLOFM field must contain a Y (offset by document) or S (offset by pay item).

Note: If you are using offset method B for either Accounts Receivable or Accounts Payable and you want to use the R09150 program for the trade accounts, you can change the offset method constant to either Y or S. The R09150 program then performs reconciliation on any new transactions for which the GLOFM field contains Y or S.

To indicate that transactions are reconciled, the system updates these fields in the F0911R table:

Reconciled Code (RCND): the system updates this field with the reconciled code that you specify in the processing options for the R09150 program.
Reference 3 (R3): the system updates this field with a reconciled identification (ID) number that contains leading zeros. The system uses the Reconciliation number in the General Accounting next numbers.
Check Date (DKJ): the system updates this field with the most recent G/L date of the group of entries.

The following subtopics describe how the system determines whether transactions are reconciled.