Versions Compared

Key

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

...

  1. Access the Receivables module.
     
  2. Click on Custom.

  3. Click on Lockbox Import.

  4. If using the Loblaws file format (
    View file
    nameLoblawLockboxSample.xlsx
    height250
    )LoblawLockboxSample.xlsx), click on the Load Loblaws File button.

    1. Locate the file on your local machine, and click Open.
      Image Added

    2.  If the file reads correctly, the screen should appear as:
      Image Added 

    3. The Detail Amount text should appear in green.
      This means that the first row in the Lobloaws file (the Check # and Check $ Amount) match the details provided.
      If the Detail Amount is red, then there is an issue with the details not matching the first row in the file.

    4. Specify a valid Reference Field option.
      The Reference Field tells the system what field within ERP was provided by the client. Is the Reference # on the lines the ERP Invoice #, the ERP Order #, or the ERP PO #?
      During initial implementation / migration, this will most likely be the ERP Invoice #; once but may become the ERP PO # or Order # over time. 

    5. Click the Create Lockbox Records button. A confirmation dialog should appear.
      Image Added

    6.  You can now close the Lockbox File Import screen and access the standard ERP Lockbox Processing screen to apply the payments.

  5.