Understanding the Generate Positive Pay Text File Program

At the end of each day, run the Generate Positive Pay Text File program to create the positive pay text file to submit to your bank. When you run this program, the system selects payment records from the Accounts Payable - Matching Document table (F0413) and populates the Text Processor Header table (F007101) and the Text Processor Detail table (F007111) with information from these payment records.

When selecting records from the F0413 table, the system selects only records that meet the following criteria:

• The payment date is before or equal to the date specified for the Through Date processing option for the Generate Positive Pay Text File program.

• The value in the Positive Pay Flag field (GFL7) is blank (for payments that have not been voided).

  The system includes the payment in the text file and updates the Positive Pay Flag field to a value of 1. The payment is not included the next time you run the program.

• The value in the Positive Pay Flag field is either 1 or blank (for payments that have been voided).

• A value of 1 in the Positive Pay Flag field of a voided payment indicates that the payment was voided after being included in a positive pay text file.

• A blank value in the Positive Pay Flag field of a voided payment indicates that the payment was voided before ever being included in a positive pay text file.

  The system includes the payment in the text file as a void and updates the Positive Pay Flag field to a value of 2. The payment is not included the next time you run the program.

The system creates one header record in the F007101 table for each bank's positive-pay text file and includes the following information:

• Record type code

  This code indicates whether the record is a header, detail, or trailer record. A value of 1 indicates that the record is a header record, a value of 2 indicates that it is a detail record, and a value of 3 indicates that it is a trailer record.

• Bank transit/routing number

• Company name

  The system uses the value specified in the Company Name processing option for the Generate Positive Pay Text File program.

• Creation date

• Creation time

The system creates one detail record in the F007111 table for each payment in a positive pay text file and includes the following information for each payment:

• Record type code

• Bank account number

• Check number

• Payee name

  The system uses the value specified for the Payee Name processing option for the Generate Positive Pay Text File program.

• Check amount

• Currency code

• Check date

• Void date

• Status

The system also prints a report listing the information that was created in the F007101 and F007111 tables. Because this report contains headings for each column on the report, you can use it as a key when reviewing the data in the positive pay text file.

After running the Generate Positive Pay Text File program, use the Text File Processor program to copy your text file to a specified location on your PC so that you can save the text file in the format required by the bank and then submit the file to the bank.