Description of Issue

Payments imported via Lockbox file are paying future unpaid installments and skipping older unpaid and due installments.

Context

Accounts Receivable
Process Lockbox File (arpmtimp)

Cause

The Standard Lockbox Layout is being used and the records in the file are accidentally or intentionally specifying an installment to pay.

Resolution

The Standard Lockbox Layout allows for the payment records in the file to specify an installment. When specified, the payment will be applied to the listed installment only.

In the Standard Lockbox Layout, installment number can be specified in positions 32-33. Open the lockbox file and check these positions to verify that this is the cause of the issue.

The easiest way to correct this issue if the file has already been processed is to run Payment Redistribution. For a guide on how to complete this function, please see: How to use the Payment Redistribution program

Additional Information

A full copy of the Standard Lockbox Layout can be obtained here: Standard Lockbox Import Layout
All resources for working in the Process Lockbox File program can be found here: Master Article - Process Lockbox File

Browser not supported