I need to be able to print Inventory Labels by the Qty on Hand amount. How can I do this?
I need to be able to print Inventory Labels by the Qty on Hand amount. How can I do this?
Your best option is to get the barcode software Bartender, the Enterprise edition. It can do that.
That's an expensive solution. Is there another way?
I have done this before with a Crystal Reports file. I'll try to find the solution and post it.
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).
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).
I have never done anything like that in the past. How is this done? Thanks
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.
*Community Hub is the new name for Sage City