Export your List of Suppliers from H&L

Export your List of Suppliers from H&L

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.



      

    Check out our
    Product Blog Series
    to stay up to date

      • Related Articles

      • H&L Sysnet

        Whatever size your venue, H&L have got you covered. H&L has been at the forefront of technology in the hospitality, food and beverage industry for over 30 years. The intuitive and customer-centric approach behind their innovative products is why so ...

      • How to Import Inventory Bills into H&L Sysnet

        How to Import Inventory Bills into H&L Sysnet On your Sysnet device's desktop, double-click H&L's app called 'Lightyear Invoice Importer' Enter your H&L credentials Drag and Drop the downloaded CSV file from Lightyear (this will be in your chosen ...

      • H&L Sysnet - Known Error Codes & Resolutions

        H&L Error Reason Resolution Notes Files Client ABN: XXX XXX XXX XX Does not match your Company ABN (XXX XXX XXX XX) please ensure this file is for you. Do you want to continue? The ABN being populated by Lightyear via 'My Company Profile' doesn't ...

      • Choosing "Other" as your Inventory Software

        While Lightyear supports many different types of inventory software through a predefined export, you may be using one that isn't yet formally supported. Well, good news! If your inventory software supports either a .csv or .txt upload, you can now ...

      • Import Supplier Cards from MYOB Desktop

        In MYOB VERY IMPORTANT: Firstly please ensure there are no duplicate suppliers in MYOB. If there are, rename them all to be unique. File > Export Data Choose Cards from the drop-down list, then Supplier Cards You can ignore the other options, and ...