View Lockbox Payments

Accounts Receivable Menu -> Payments -> Bank-to-Bank Payments -> Import Lockbox Payments -> View Lockbox Payments

After the electronic data file from the bank has been imported using Import Lockbox Payments, the following information screen is displayed. Records can be deleted to prevent further processing, but additional records cannot be added.
Only the Division, Method of Payment, Currency, and the total Payment Amounts, can be adjusted prior to posting to the customer's account.

The prompts are:

BATCH

Enter the Batch Code to post, or select it from the drop-down list.

Payment Details:

SEQ

The sequence tracks the number of records in the file.

CUSTOMER#

The customer number displays.

Note: It is important to only include Customers with the same Currency as the pMethod Of Payment Code selected for the import also determines the currency of the payments.

NAME

The customer name displays.

DATE

The date of the payment to the bank is displayed.

DOC#

The check number entered by the bank is displayed.

PAID

Window to view the payment details, including the invoices, amounts, and discounts, that are to be paid by this payment.

Note: Trade Discounts are not respected using the Lockbox payment process, as they need to be reviewed manually to confirm the payment terms have been met.

CURR

The currency code defaults to the customer's currency.
This can be modified as required, but should match the Payment Method.

DIV

The division is displayed.
This can be changed if required.

METHOD

The Method of Payment as entered in Import Lockbox Payments is displayed.
This can be modified but should match the payment currency code. A window is provided to select the correct method.

AMOUNT

The total payment amount is displayed.
This can be modified.

Expanded Record

Click EXP/CON or press <F9> to expand the payment record to view any over or under payment amount.
An over or under payment amount is caused when the sum of the invoice details to be paid (that can be viewed in the Paid window) do not equal the total payment Amount.
The over/short amount prints on the "Customer Payments Summary" report generated from Post Customer Payments.

To enhance processing efficiency, a Variance can be set by customer to allow for a pre-determined over or under difference as explained in Customer Lockbox Variance.
Using a Variance prevents undue time and effort spent balancing minimal over/short payment amounts.

Finished?

Click ACCEPT to accept the payment information.

To complete the Lockbox process, the payments can now be applied against the customers' invoices in the A/R sub-ledger using Apply Lockbox Payments.

Posting Control
The Bank-to-Bank Payments programs including Import Lockbox Payments, View Lockbox Payments, and Apply Lockbox Payments are designed to be run by one operator at a time.
If record locking is experienced using these Lockbox programs and no other user is actually using them, refer to Reset Lockbox Payments for instructions on resetting the control flags.