Lockbox Import

You can use the Lockbox Import screen to import a .csv file that populates the Lockbox Processing screen.

Pre-Requisites

  To use this feature, you will require:

• Wegmans File 

• Security Permissions to AR, "Lockbox Import" 

Step-by-Step Guide

1. Access the Receivables module, click on Utilities, then click on Lockbox Import.
   
   You will see the following screen:
   
   

   Open

   

   
   
   When the form first loads, the screen will be empty. You'll need to first Import a File to commit records.
   
   
   

2. At present, the only format supported is the Wegmans format, which supports csv files. Excel is not required to read these files. You will first click the Import File button then select your file from its location. Note that only one file can be imported at a time:
   
   
   

   Open

   

   
   
   
   

3. When the file loads any field that is required but not populated will have a red X. Fields that are required, but not provided in the file, can be entered right into the grid. When they are, every row on the grid will be updated with that value. To enter values one at a time, uncheck the "Update all user-defined fields..." value near the bottom of the screen:
   
   
   

   
   
   Once the values have been updated, you can click Test Commit to test for any additional errors or Commit to commit the file. The file will now appear in the Lockbox Processing sceen.
   
   *NOTE - There is a configuration called Invoice Field Contains Order Number.  
   
   
   

   
   
   Configuration is checked - The import will first look for order number associated with the invoice to be paid.  If there is no order number associated with an invoice, (credit or debit memo), it will look for the invoice number. 
   Configuration is unchecked - The import will only look at invoice numbers.