Lockbox payments skipping unpaid due installments
Payments imported via Lockbox file are paying future unpaid installments and skipping older unpaid and due installments.Â
- Accounts ReceivableÂ
- Process Lockbox File (arpmtimp)
The Standard Lockbox Layout is being used and the records in the file are accidentally or intentionally specifying an installment to pay.Â
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
- 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