Appendix I: Importing AR Lockbox files

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 import. Refer to the table below for referencing the AR lockbox field to the advanced bank statement import field and/or function.

Use the table below for mapping the AR lockbox file definition to the advanced bank statement import field or function used.

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 to be imported, file type, and field separator.

Use the table below for mapping the AR lockbox file definition used in the NA add-on to the advanced bank statement import field or function used.

AR lockbox	Description	Advanced Bank Statement	Description
Lockbox Code	Must be unique for each lockbox to be processed.	Bank import segment definition	The lockbox designation can be entered on the first line of the definition but is not required. The line is only necessary if the Lockbox code is included in the source file.
Description	Text describing the lockbox.	Bank import segment definition	Segment description
Import directory	Directory containing the lockbox file.	Bank import settings, Other section	Import volume
Import file name	Name of the lockbox file.	N/A	The file is selected during the File upload.
Completed directory	Directory into which this function will copy the lockbox file after it has been processed. The processing date and time will be appended to the file name.	Bank import settings, Other section	Select the Move file after import check box and enter the Move to volume.
Field separator	Single character used to separate individual fields in the lockbox file. This character must not occur within the data itself.	Bank import format definition	Enter the character in the Field separator.
Record separator	1 or 2 characters that indicate the end of each record in the lockbox file.	N/A
Transaction	Payment Type to be used when importing payments for this lockbox.	Bank import settings, Accounting section	Select the Payment entry type.
Site	Site to be used when importing payments for this lockbox.	N/A	The site can be added to any of the bank statement import settings as a search criterion. For payment posting, the site on the invoice is used.
Bank	Bank to be used when importing payments for this lockbox.	Bank import settings, General section	Bank to be used when importing payments for this lockbox.
Currency	Currency to be used when importing payments for this lockbox.	Bank import segment definition	Use constant field type with the currency code in the Formula field.
Destination	Accounting Code (Payment Attribute) to be used when importing payments for this lockbox.	Bank import settings, Accounting section	Payment attribute overpayment (receipts)
Discount destination	Enter the Payment attribute for if discount is to be applied to the payment.	Bank import settings, Accounting section	Payment attribute underpayment (Other than Early discount/Late charges)
Generate discounts	This box needs to be check marked when discount is applied to a payment.	N/A	Discounts are generated based on Early discount/Late charge assigned to the Invoice.