Skip to main content

Export your List of Suppliers from H&L

J
Written by Jessica Callaly
Updated over 3 weeks ago

H&L Sysnet requires a 'Customer Account Number' from each supplier. This is how H&L Sysnet knows which stock location to import purchases into.
โ€‹

First, good housekeeping...

  • Please ensure ABN numbers and Customer Account Numbers are up to date in H&L Sysnet. If Account No. is not populated, you can replicate the Supplier Code

  • Generate a list of ALL suppliers from H&L, to upload into Lightyear ('Supplier Name', and 'Account #')

  • While in Beta testing, this is not the most elegant exercise and has been mentioned to H&L for improvement.

  • The workaround is to generate a PDF list to then convert to a CSVโ€‹

  • Navigate to Sysnet > Suppliers.

  • Across the toolbar at the top, select 'Reports'

  • Choose 'Supplier List'

  • Generate a PDF of the report

  • Ensure 'Account #' is one of the fields in the list of course.

    • Drag and Drop the PDF onto their website (or upload, your choice)

    • Click 'Convert Now'

    • Wait for the file to convert, and click Download.

  • Open the CSV file and edit the file so you have only 2 columns remaining:

    • Column A = Supplier Name

    • Column B = Account #

  • Save changes as a CSV file.
    โ€‹


โ€‹

Did this answer your question?