Automatic Payment History Reconciliation
To streamline the process of reconciling payments, you can run a program that reconciles the outstanding payments automatically. When you reconcile payments automatically, the system copies the information in the F06561 table and compares that information with the payment history in the F06156 table. The system then reconciles matching entries and generates reports that you can use to verify that the information is correct.
When you reconcile payment history automatically, the system prints the Check Reconciliation - Update History report. Review this report to verify that the information is correct. In some cases, the system also prints the Amounts not Equal and the Issued but not Cleared reports. You use these reports to determine whether errors have prevented any payments from being reconciled.
Before you reconcile payment history automatically, copy the reconciliation information from the bank to the F06561 table and set up the G/L Bank Account Number to G/L Account Number user-defined code (UDC) table (06/BK) with the short account ID in the Code field and the bank account number in the Description field.