Un-hemmed Pants Inventory

Multi-bin might work for this.  Have one item code (and UDF for ordered length), with bin's for the different lengths... and you'd just be looking at which bin's have stock.

I would think you would have separate item numbers for unhemmed pants and hemmed pants. You should have bill of materials and have a bill for the hemmed pants that include labor or hemming charges. Then do a production entry to create the hemmed items. 

Or you could use Sales Kits if you don't have Bill of Materials, if labor charges aren't a concern.  Either BOM or Sales Kits you would have a choice of pulling the components or the item from stock.

That would certainly work for managing the inventory... but I think the question is related to quickly knowing what they have on-hand for the different possible lengths.

We did look at BOM but we didn't feel it benefited us to track all the labor expenses on a "job", mainly looked at it for decorating garments but I see where the hemming could fall under that too.  So on the Sales Kit option, the components of the kit item code would be all the different lengths? This is an example of our item codes for a 34 waist pant,  all these lengths are options to sell but we only have inventory in the P-GRY 34 UNH.

I was thinking you'd have those items but the ones that are not hemmed would be Kit items.  The kit would basically consist of something like (and don't laugh at my simplicity):

P-GRY7 34x26 Kit - components P-GRY 34 UNH, and THREAD

When you use in Sales Order you'd choose the item P-GRY 34x26, and if none existed in stock the Prompt to explode the kit item would appear, which then you could explode into P-GRY34 UNH and THREAD.  This would then take those components out of inventory.  If the original item existed in stock it would take that out of stock.

Again, I would defer to the gentlemen above as they are the experts, but just thinking if it's about knowing your inventory I think this would work maybe? (Thinking out loud) 

(Example of exploded kit, where the components would be taken from inventory when parent is not in stock)

E

Also, this method would allow you to even change the component to a larger size that can be hemmed down, if you have no UNH in stock.

Alternate Items might work for that... but I haven't really used the feature so I can't comment on functional details.

Will definitely keep this option in mind, thanks.

This almost states exactly what we are trying to do, I will check into this and should be easy to associate the alternate items through a VI import I would think.