Label Making Software

[btamulis]

My client wants to install a label maker in receiving and print user-defined labels based upon information from Great Plains - example, lot number, receipt, receipt date, vendor, PO, etc.

Does anyone have any positive expereinces or recommended software solutions to share?

 

[dgillz]

Crystal reports.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[jazgeek]

crystal reports

-----------
and they wonder why they call it Great Pains!

jaz

 

[btamulis]

Okay - I got two Crystal Reports and no details.

I'm in Great Plains and I just completed a receipt - now I want to label the material with:

Lot Number
PO Number
Receipt Date
Vendor

Sometimes I want to print one label, other times, 10 labels.

I can picture creating a report in Crystal - I'm having difficulty understanding how the physical label printer (hardware device) will translate the rpt file and I'm trying to understand how I launch the crystal directly from within GP Receipt screen - I would like to avoid user having to launch Crystal, enter parameters, etc. Can I hit 'post' button and trigger the label printer?

More details would be great.

 

[jazgeek]

unless you are adept at programming there really is no other way than launching crystal reports seperately. If you have the know how you could modify the receiving edit list to be a label in report writer (I wouldn't want to do it)

Third party software would allow you to integrate crystal reports into the receiving screen.

As to how to build the report, that's a long drawn out process that wouldn't be answerable on this forum.

Lot Number, Po number, receipt date, vendor ID those are all accessable tables in Dynamics

lot number i believe is IV00103, PO# would be off of the POP10100 table, receipt date would be off of the receipt table which escapes me at the present time and vendor ID would be from the vendor master table (but you probably would be able to pull that from the POP10100 header table just as easily.

as for number of labels, its a report. Printing to a label printer is no different than printing to a normal printer. Tell it how many to print in the printer context screen that allows you to change paper size, trays etc.

Label printers are unique, we use Zebra printers for every day paper labels and we use a heavy duty thermal for printing serial plates to our produced goods. Zebra's are cheaper, the heavy duty one (brand name escapes me right now) was about $4000 and the media is expensive.

If you're looking for someone to do it for you, I'm sure your local var would be more than willing to help you in the process. Alternatively there are members on this board that offer their services for report writing et al.

I know Luvsql freelances and it would be a snap for her to whip you up a crystal report with the desired output. As for integration with the receipt screen... that can get expensive.



-----------
and they wonder why they call it Great Pains!

jaz

 

[dgillz]

This is a simple crystal report, but why do you need 10 labels? Is there a logical way to determine the # of labels? Or is this driven by a parameter?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[cryrep]

I use Labelview 7.0 Here and is link to my GP database to print Product Label For the wharehouse and production i did't print from a PO yet but is certenly possible...

for your 10 label: in Labelview when you hit the print button you could chose a differante qty off lebel per record LV will find in the Database

 

[UserofGP]

Is Labelview integrated with Great Plains for your system, Cryrep? I mean can you print labels from great plains window or do you go to another window outside the system.

 

[cryrep]

Two possible way

1rst Go on label view screen
2nd Built something in GP, Will put your data into a temps table, LV have a function i think is data watch i look into a specefic place, Database.table and print every new record i found

i think you will need the Gold version

http://www.teklynx.com/media/pdf/literature/labelview_80_labelview8buf-en.pdf

 

[jschellenberg]

We use Label Manager from Maximum Data. Works pretty well for printing labels. It's a bit of a pain to setup, but is do-able (I'm no programmer either). It uses Loftware Label Manager, but it all integrates to the GP database pretty well.

Alternatively, there's a product from Rockton Software that lets you launch a Crystal report (or SQL Reporting Services report) from any print button in Great Plains. Problem is, there's no print button on receivings, so that might not help here....

 

[macleod1021]

Crystal Reports can be a pain to work with if you're not adept to how it works. There's also the issue of setting up for various print jobs.

As far as Label Manager, I don't want to break any of the rules (I work for MDS). I'll leave jshellenberg to speak of that. I hope it's not against the rules to say there's an new version going to beta now. If this is against the rules, please delete my post.

 

[BackStageJim]

Segull with Zebra works fine for my exisitng ERP. Not sure if it will feed via GP.
The interface is nice since you can go manual and create labels without using the ERP driver from database.
Fairly nice print too. Our warehouse printer is near door, and winter/summer has not impacted its performance. Once we got a bad roll of labels, but that was unique.

This is why Artemis slew Orion ERP