Editing and updating lockbox transactions

Use these instructions to edit the transmission data in the AR batch file created when you run the Customer Entry Lockbox Import Report. Data remains in the batch file if you did not post/update transactions during the import function. This batch is active until you update it in Customer Entry Lockbox Update Report.

These instructions include an explanation of the batch file creation and update process that occurs based on import option settings.

  1. Select Customer > Entry > Lock Box Entry.
  2. Specify the search criteria, and then click Search.
  3. To maintain these settings, expand the record in the grid:
    • Ready to Process: If the payment transactions have been edited and are ready to update in the batch, ensure this option is selected for each transaction
    • Apply Amt
    • PIF
    • Disc Amt
  4. If the incorrect customer was matched to this check, select the transaction and then select More > Change Customer Number in the window header. You can also add transactions if the payment requires additional supporting data.
  5. To suspend or unsuspend a line, select the transaction and then select More > Suspend/Unsuspend Check in the window header.
  6. If a payment reflects an invoice discount that has expired, select the transaction and then select More > Recall Invoice Discount above the grid. To apply discounts to all invoices paid by the check, select Recall Discount.
  7. If the Customer Transaction Entry record was not found during the import process, the check box in the ARET NF column is selected. To add detail, select More > Replace Detail above the grid.
  8. Click Save when you are finished editing. The Proof must equal zero.
  9. Select the next check/customer. Repeat the previous steps until you finish the batch.
  10. To schedule an update for the batch, click Accounts Receivable - Lockbox Update if it is available. Otherwise, go to the next step.
  11. Select Customer > Entry > ARE Reports > Accounts Receivable - Lockbox Update.
  12. On the Ranges page, specify the batch number in the Batch Range, and then click Next.
  13. Specify U to update your AR and GL files with the lockbox transactions in the batch file. Specify E to print a report without updating.
  14. Select Yes to post only those batches where every check is ready. Select No to post all checks that are ready, regardless of the batch status.
  15. Specify the bank number.
  16. Click Next, and then click Save to generate an update report that provides line item detail of the items in the batch that were processed.
Related topics