Understanding the Copy Bank File to Interface File A/R Program

You use the Copy Bank File to Interface File A/R program (R74W0010) to upload bank files that contain receipt information into the F007101 and the F007111 tables. You use country-specific bank format programs to transfer the receipt information from tables F007101 and F007111 to the F03B13Z1 table. After the information is transferred to table F03B13Z1, the information can be uploaded and matched against outstanding customer invoices.

Uploading the information in the text file processor enables data to be managed efficiently with automatic maintenance of the processing status of each tape record, including purging capability.

Complete these steps to upload a text file from the bank to the F03B13Z1 table:

1. Receive a text file containing payment information from the bank.

2. Run the Copy Bank File To Interface File A/R program (R74W0010) to load the bank information into table F007101 and table F007111 in the correct format. You then run the appropriate bank format program (R74W001, R74V001, and so on) to transfer the data from tables F007101 and F007111 to table F03B13Z1.

3. Run the standard automatic receipts matching process.

   Note: Alternatively, you can run the appropriate bank format program (R74W001, R74V001, and so on), configuring the processing options on the bank format program to first upload the bank information into tables F007101 and F007111, and then transfer that data into table F03B13Z1. This process does not use the Copy Bank File to Interface File A/R program and is well-suited to small businesses in which the person who uploads the file from the bank is also the person who processes automatic receipts.