Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Access the Receivables module, click on Utilities, then click on Lockbox Import.

    You will see the following screen:


    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 the location it is at. Note that only one file can be imported at a time:



  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.