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 ...

      • 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 ...

      • 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 ...

      • SwiftPOS

        With over 23 years of experience as a POS Software Solutions Provider, SwiftPOS is world renowned for its total Point of Sale solution. Lightyear is able to provide an export file to SwiftPOS that allows for easy Inventory updates. For more ...