Where CLIENT or WORKSTATION is used below, it refers to the Dynamics GP workstation which will be used to print labels. You do not need to install the labeling software (i.e. NiceLabel), or LabelLink, on ALL GP workstations.
|Purchase labeling software||We recommend NiceLabel. Approximate cost is $500 per copy. You will need one license per label printing workstation.
|Purchase barcode printer||There are many options. Approximate cost of a mid-range roll label printer is $300. You will need one printer per workstation.
Check Amazon for barcode printers.
|Purchase label printer roll||Approximate cost is $15 per roll.
Check Amazon for label printer roll.
|Install labelling software (i.e. NiceLabel) on each client||You will need Windows Administrator level permissions to install the software.|
|Install label printer on each client||You will need Windows Administrator level permissions to install the printer drivers.|
|Configure labelling software to work with printer||Execute a printer test from the print driver.|
|Create a SQL User for the labelling software||Create a SQL user with NO PASSWORD, and read only permissions on the SQL table LabelLinkSL, and the SQL view LabelLink.
We suggest that the User ID be LABELLINK.
NOTE: unique reporting requirements may require creating a custom sql view, and/or linking to other sql tables. Full access to the SQL server will facilitate quicker deployment of the label printing solution.
|Create ODBC connections on each workstation||Create an ODBC connection on each workstation using the LABELLINK SQL User ID. Set the default database to the Company Database.|
|Create a network share for the reports||Create a pathname with no spaces. For example:
Grant EVERYONE full read/write permissions to the folder.
|Install LabelLink on the Server||Log-in as Administrator. You will need the SQL SA password.|
|Install LabelLink on each client||Log-in to the client as Administrator (or a user with Domain Admin permissions).|
|Create a label report||This can take about an hour for a simple report, to 3-4 hours for a complex report.
You may need multiple reports if “Receiving Labels” are different than “Manufacturing Labels”.
Save the reports into the network share.
|Create a User Copy of each report||The report will have a User ID restriction in it so that it only pulls data for a specific GP User ID. Each user will have their own copy of the reports.
We suggesting naming the reports with the User ID. For example:
|LabelLink Setup||Use the LabelLink Setup window to map each GP User ID to their label report.|
Article is closed for comments.