Generating the TXT Payments File

The TXT Payment Generation program (R76A0441) writes records to the Text Processor Header (F007101) and Text Process Detail (F007111) tables. You use the Text File Processor (P007101) to copy the text files from the F007101 and F007111 tables to text files that you can submit for tax reporting. These records contain information about payments from the F76A0440 table.

When you run the TXT Payment Generation program in proof mode, the system generates a report of payments and errors found.

When you run the TXT Payment Generation program in final mode, the system generates a report that includes information about the total payment with information from the processing options and from the standard payments tables. The system marks records in table F76A0440 as processed. The system includes records that have errors.

The system retrieves the following payment data:

• Check number

  The system retrieves check numbers from the F76A0440 table, if possible. If the information from the F76A0440 table does not equal the total amount of the payment, the system uses the document number from the payment as the check number for the remaining amount.

• Bank tax ID

  The system retrieves the tax ID of the issuing bank from the F76A0440 table, if possible. If the information from the F76A0440 table does not equal the total amount of the payment, the system uses the CUIT number from the bank's address book record for the remaining amount.

• Payment instrument

  The system retrieves the payment instrument from the F76A0440 table, if possible. Otherwise, the system uses the payment instrument that is specified in the processing options of the TXT Payment Generation program.

• Signer tax ID

  The system retrieves the tax ID of the signer from the F76A0440 table, if possible. Otherwise, the system uses the signer tax ID from the processing options of the TXT Payment Generation program.

• Gross amount

  The system uses the total of the checks that are associated with the payment in the F76A0440 table. If no checks are listed in F76A0440 table, the system uses the total payment amount. If the total of the checks is less than the total payment amount, the system records the difference using the document number from the payment.

• Currency code

  The system uses the value from the Special Handling Code field of the Foreign Currency Codes (00/CC) UDC for the payment currency. If UDC 00/CC is not set up, the system issues an error message.

If you use multiple versions of the TXT Payment Generation program for different payment instruments, the first version that you run must be set to clear the file, and the subsequent versions must be set to write additional information to the file. You specify in a processing option whether to clear the file. The data selection of the different versions does not have to be superimposed to avoid duplicate records. You have to run everything from the beginning when a subsequent version runs incorrectly.