Sage 100

I have an end user asking if there is a way for them to print parts labels for each component on a BOM. Although I believe there are workarounds (and I have questions on why the labels aren't printed at the ROG level) the customer says that during certain times a label may wear off a part or they keep all the parts for one BOM in a specific area and it would be easier to just flag a BOM and have it print off all the labels for each component.

Could someone write a Crystal report to print the labels?? RE: ""during certain times a label may wear off a part"" - This could probably be resolved by buying higher quality BC media..... Sounds like they are trying to fix the symptom, not the problem....

Same thoughts here re: symptom fixing.

I would use Crystal Reports to select the BOMs and then export the component information to an excel or .csv file. Then use a product like Label Matix to read the file and print the labels.

@MichaelMcDonald - Let's take that a step further with Pass Through Queries and Access. PTQ the BOM and CI_item tables required. Create a Select Query combining the multiple tables to address the Label Matrix limitation of pulling from one table only, then create the Label Matrix form to print the label pulling the data from the select query. I have several installs where this works well with ROG labels. BTW, I suppressed my PTQ thoughts on my first post (didn't want to be accused of constantly talking about PTQ's) but since you mentioned Label Matrix, I could not hold back any longer......

I have played around in older versions Access, so it's not completely foreign to me but @JeffSchwenk can you recommend ""PTQ for Dummies"" reference or training material?

As an aside - Scanco labeling is about $6,000. I like Access solutions but I have been burned (badly) by them in the past. When they suddenly stop communicating by SOTA ODBC it's a very sticky situation. I've seen this multiple times and unfortunately the customer doesn't remember you did the a favor trying to do a quickie Access report.

Sorry, @MichaelMcDonald all I can recommend is summer camp at Midvale. PTQ's and Pivot Tables have pretty much been self taught over the years. Pick up a nugget of knowledge here and there and it all starts coming together in the middle of the night during my cold sweats...... @WayneSchulz - Really depends on the customer and the need. I have about 7 customers printing labels this way and I really don't have issues that I get burned on. In the past year, I have had two calls when the label has stopped working. Took less than 10 minutes to fix each time. Bigger issue is getting the client to let me know there is an issue. If I had a client that had a need turn key solution for data collectors and uploading into MAS, I certainly would steer them toward Scanforce (and now maybe Scanco). For the most part, my client needs are simple.... And this simple solution works for them.