Print Inventory Labels by Qty on Hand

SUGGESTED

I need to be able to print Inventory Labels by the Qty on Hand amount. How can I do this?

  • 0

    Your best option is to get the barcode software Bartender, the Enterprise edition.  It can do that. 

  • 0 in reply to BigLouie

    That's an expensive solution. Is there another way?

  • 0 in reply to Terry Bumgardner

    I have done this before with a Crystal Reports file.  I'll try to find the solution and post it.

  • 0 in reply to BShockley

    We've done this with a dummy sequence table, outer join, and creative custom Crystal Reports design (with a report selection criteria formula to control the quantities per item).

  • 0 in reply to BShockley

    That would be great. Thank you.

  • 0 in reply to Kevin M

    I have never done anything like that in the past. How is this done? Thanks

  • 0 in reply to Terry Bumgardner

    The Seagull Scientific BT-EA3 Bartender Enterprise Automation can be found for as low at $570.00. With one client wrote a simple script and put it on a button on the menu bar so they could print out the labels by clicking the button.  Yes you can do it with Crystal but it ain't easy.

  • 0 in reply to Terry Bumgardner

    Set up a UDT with a single column and add values 1,2,3,4... up to the maximum number of labels you'd need.  Then in the .rpt set up an open link from your label data to this sequence table (link with an =! on unrelated data, so there is no filter), and use a report selection formula so that the sequence table value is <= your item quantity.  This should repeat each line the correct number of times, so then you just need to do the label design.

  • 0
    SUGGESTED

    I must not have the whole picture as to what you are trying to do?

    When you go to IM - Reports - inventory label printing,  you can specify the number of labels you want.  Just enter the quantity you need for that item.

    If you are printing labels at the time of receiving - individual inventory items can be specified in Item Maintenance to print one label for each unit received or to print one label in total.  Item maintenance - Tab 2 - Print receipt labels.

    Or maybe your issue is that the labels do not cooperate with your label printer (as opposed to sheets of labels on 8/11 paper).  The standard label templates supplied with Sage 100 do not work well with label printers.   I create a label with crystal that is set up as a standard report (do not select the label option),  then I copy it over a previously created label template.   It's actually a pretty simple fix.  Don't know why Sage hasn't created a template that is compatible with label printers out of the box.

  • 0 in reply to Terry Bumgardner

    Create a UDT (User Defined Table) with incremental values, starting with 1.  For example, the first record has a field equal to 1, and the next record has a field equal to 2, etc.

    Link CI_Item or whatever table you're using to the UDF.  Change the Link Type to "!=" in the Crystal file - Database Experts - Links tab.

    Create a record selection formula, using similar logic as follows:

    {@number of labels} <= {?number of labels} and
    {CI_Item.ItemCode} = {?item #}

    In my example, I have two parameters:

    1 - item code

    2 - number of labels to print (number parameter type)

    With the "number of labels" parameter, the user can decide how many labels to print per item selected.

    You can create variations of this report, using the S/O detail and P/O detail qty ordered or qty received fields.  Just change your record selection formula to the field you're using instead of the number of labels parameter.