Appendix: Field mapping for the AR Lockbox file definition
Use the table below for mapping the AR Lockbox file definition used in the NA add-on to the Advanced bank statement 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, |
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, |
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 field. |
|
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, |
Select the payment entry type. |
|
Site |
Site to be used when importing payments for this lockbox into. |
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, |
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 a 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, |
Payment attribute overpayment (receipts) |
|
Discount destination |
Enter the Payment attribute for if discount is to be applied to the payment. |
Bank import settings, |
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. |