Setup

This section covers the prerequisites and setup requirements specifically for processing an NA AR Lockbox import file using the advanced bank statement import process.

Bank import segment definition (BSISCT)

Use the Bank import segment definition function (BSISCT) to define the structure of the AR Lockbox file. Some fields originally required to be in the AR Lockbox file are now defined in the advanced bank statement. Refer to the table below for referencing the AR Lockbox field to the advanced bank statement field and/or function.

See the Appendix: Field mapping for the AR Lockbox file definition for a table with specifics on mapping AR Lockbox file definitions to the Advanced bank statement fields.

Bank import format definition (BSIFILFMT)

The segment created in the Bank import segment definition is then assigned to a bank import format definition. Select the segment file imported, the file type, and the field separator.

Invoice number definition (BSIINVDIO)

The Invoice number definition is required for importing. Refer to the complete function help for more information.

Bank import settings (BSIIMPPAR)

Create the import template that will be used for importing.

In the Accounting section, populate the required fields. These fields were originally defined in the AR Lockbox file.

In the Search criteria section, select the check boxes for the Invoice number, Amount, All BPs, All BP types, and All categories is required.

In the Other section, select the File import and Move file after import locations.