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. In the window header, select More > Change Customer Number. You can also add transactions if the payment requires additional supporting data.
  5. To suspend or unsuspend a line, select the transaction. In the window header, select More > Suspend/Unsuspend Check.
  6. If a payment reflects an invoice discount that has expired, select the transaction. In the window header, select More > Recall Discount and click Recall Invoice Discount. To apply discounts to all invoices paid by the check, click Recall Discount.
  7. If the Customer Transaction Entry record was not found during the import process, Y is displayed in the ARET NF column. To add detail, select More > Replace Detail from 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. Select Customer > Entry > ARE Reports > Accounts Receivable - Lockbox Update.
  11. On the Ranges page, specify the batch number in the Batch Range, and then click Next.
  12. 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.
  13. 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.
  14. Specify the bank number.
  15. 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.