Incoming bank files (electronic bank statements) contain transaction codes, which identify the types of payment contained in the file. These codes are mapped to the system actions Create Customer Payment, Pay Customer Payment, Pay Supplier Payment. Bounce Customer Payment, Bounce Supplier Payment, Create Banking Entry, Acknowledge Bank Receipt, or Other. This ensures that the correct type of automatic payment is created for each transaction.

For example, Wells Fargo uses the code R057 to identify supplier payment transaction messages within the bank files. This code is mapped to the system action Pay Supplier Payment. When you import a Wells Fargo bank file, the system maps all supplier payment transaction messages to the action Pay Supplier Payment. Once the messages are validated and processed, the system performs the action to which the transaction code is mapped. In this instance, the system invokes the Pay Supplier Payment action for all messages that are coded R057. It then retrieves the original supplier payments for these transactions and changes their status from For Collection to Paid.

The system uses the payment format linked to your bank account to store the mapping information. To enable auto-generated payments, you must link a payment format containing the correct mappings to your bank account when initiating the customer or supplier payment process. For example, to process Wells Fargo bank files, you must link the payment format containing the Wells Fargo transaction mapping to your account as part of the initial setup for customer or supplier payments. This ensures that when you import Wells Fargo bank files, the system can automatically complete the payment cycle.

Use Bank File Format Maintain (31.1.9) to view and configure bank payment formats for use with automatic payments from bank files. The transactions within bank files are identified by transaction codes. In order to generate an automatic system payment from these transactions, the transaction codes must be mapped to system payment activities. These mappings are then stored with the payment format, which is linked to the bank account to be used in the payment process.

To configure new mappings, you must have access to your bank’s transaction codes.