Sage 100

Looking for options for printing item labels in MAS 90/200 4.5. Working with a prospect who's in the linen industry. Upon packaging, they scan the appropriate barcode on the wall-board at the packaging station, and that generates a label - which they affix to the package. The information printing on the label comes from the Inventory masterfile (e.g., item #, description, a few pieces of specific info like size and color, barcoded item #, today's date, and qty - which I believe is always 10). Currently their process is: scan the barcode, label prints out, stick on package; repeat. Since I have some doubts about using the MAS 90/200 Inventory Label Printing function or a custom Crystal Report - as I don't think either would be efficient enough and flow well enough, I'm wondering if a program like BarTender would work for them - or some other label printing program that can read MAS 90/200 data.

Bar Tender or Label Matrix should work for this situation. Link the label template to the MAS table, scan the bar code into the item # field and it should pull and print the requested label. BUT.......... The odbc connection may not be fast enough so you would have to use an Excel or Access db (PTQ table if you wanted to avoid refreshing) to link BT or LM to.

I've used Access to generate barcode labels before. I've also used Bartender. Both type applications work well. A code39 barcode font is free.

I have Label Matrix set up at two MAS 90 sites. First site uses...get this...Report Master to export info from Purchase Order to a CSV file and Label Matrix reads the csv file like it's a database and prints labels from this csv file. My second installation uses an Excel spreadsheet, which is the plant Production Schedule that is displayed on big monitors in the plant. Near the end of the day the Production Manager prints two different bar code labels for each inventory item produced. The Production Schedule is NOT from MAS 90 but it could be, because it contains, customer Name, part #, description, color, size, serial number, etc.

@MichaelMcDonald - Great way to bring them into the modern world by using an Access table linked Label Matrix. No need to export anything. Just generate the labels.

I like Bartender a lot. Very powerful and can print a wide variety of forms and sizes. Lots easier than trying it in MAS. ODBC compliant. At Safety Vision we had labels reading Excel files, Access databases and MAS. Depended on the needs. It does not require the installation of bar code fonts or function librarys.

We have a custom solution at several food distribution companies that print thousands of 4x2, 6x4, 4x6 labels per hour. This is done out of the BOM production entry area. User simply does a production entry for every pallet produced (item, qty). We have customized the MAS system with three buttons that allow for a single pallet tag to be printed along with the produced qty of SKU labels (no update required - the labels print instantly). The customization includes 3 tabs at the item maintenance level for pallet tag and 2 sizes of SKU label allowing for custom setup by sku for things like (barcode type, date formats, kosher/organic symbols, etc). Clients are able to meet 95% of customer requests on SKU label requirements using this. Custom Lot based on date, shift code, location also auto generated along with a unit count drum/pail/box 1,2,3,4,...

Leaning toward a VBScript running a Crystal Report/label loop.