Bank Statement Detail

The system displays bank statement transactions from the F09617 table that correspond to the account number and the date range specified in the header area of the form.

To correct an unreconciled transaction:

1. Select the transaction.

2. Scroll to the top of the Reconcile Bank Statement Detail to Account Ledger form.

3. From the Row menu, select the appropriate program.

   For example, to correct a transaction in which the payment has not been posted, select the transaction and then select Batch Review from the Row menu. On the Work With Batches form, select the unposted batch and then select Post by Batch from the Row menu.

   Note: If you use the Row menu to exit to a program and manually create a receipt or payment, the system assigns the bank statement batch number to the batch that you created. For manual journal entries, the system assigns a new batch number instead.

Statement Date and Statement Date

Displays bank statement transactions based on the beginning and ending dates that you entered in the header area of the form.

To override the those dates, enter dates in these fields and click Find. The system displays transactions in the F09617 table that correspond to the statement dates that fall within the date or range of dates that you enter. To further limit the transactions that the system displays, enter values in the QBE row.

To display the corresponding F0911 information, which is based on the general ledger date, leave the From Date and Thru Date fields blank in the Account Ledger region, or broaden the date range if necessary, and click Find.

No. of Unreconciled Bank Statement Transactions (number of unreconciled bank statement transactions)

Displays the number of unreconciled transactions in the F09617 table that meet the criteria that you specified.

Recon Code (reconciliation code)

Displays the code from UDC table 09/RC that is used when you manually reconcile a transaction. The default value for this field is set in a processing option for the Manual Bank Statement Reconciliation program. You can override the default value.

Payment/Receipt Number

Displays the value stored in the CUSTREF (Customer Reference) field in the F09611 table which is mapped to the CKNU (Check Number) field in the F09617 table. This field allows up to 16 alphanumeric characters and accommodates reference numbers for receipts, payments, bank wire transfers, and so on.

Update Reference 3 Field

Select this check box to optionally update the Reference 3 field on journal entries that you manually reconcile. When you click Reconcile/Unreconcile to update the journal entries, the Reference 3 form appears with a reference number generated by next numbers. You can override the number with the bank statement number or any other number. Then, you can choose to update each selected F0911 record with the same reference number or with a different reference number. If you choose a different reference number, the system displays the Reference 3 form for each transaction.

Reconcile/Unreconcile

Select the transactions to reconcile and click the Reconcile/Unreconcile button, which is a toggle. For transactions that you manually reconcile, the system updates either or both of these tables:

F09617: Updates the reconciliation code and displays the reconciled transactions. If the transactions remain in the F09611 staging tables, they are updated as reconciled.

F0911: Updates the reconciliation code and, if applicable, the Reference 3 field and displays the reconciled transactions in the Account Ledger region of the form.

After you reconcile all unreconciled transactions in the F09617 and F0911 tables, the system marks the header record in the F09616 table with D (reconciled). If all transactions in the F09611 table are reconciled, the system updates the header record in the F09610 table with D.