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.
Navigate to https://www.zamzar.com/convert/pdf-to-csv/
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.
โ
โ