Un-hemmed Pants Inventory

Trying to figure out the best way to process SO lines with uniform pants on them that we stock.  The issue is we inventory pants unhemmed, that way when a customer orders a 32x32 we hem the pant to the 32 inseam.  So technically we take out of the unhemmed inventory and create a new item code with the 32x32.   We also might have some 32x32 in inventory (from canceled orders) and we get an order for a 32x30, ideally we would want to pull a 32x30 but if there's no inventory I would want to pull the 32x32 and hem it 2" to make a 32x30.

Would this be a situation for a lookup table? Or alias item codes, I knew we would have an issue with this situation when we try to get everything on inventory correctly.  Right now it is a manual process, the order is entered as a 32x32 and when the picker goes to pick the pant, they look on the shelf and pick either the exact size or one with a longer inseam to hem.  Nothing in Sage is accurate on inventory levels right now.

Parents
  • 0

    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.

    P-GRY7 34 UNH
    P-GRY7 34X26
    P-GRY7 34X30
    P-GRY7 34X32
    P-GRY7 34X34
    P-GRY7 34X36
    P-GRY7 34X38
    P-GRY7 34X40
  • 0 in reply to jland47

    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 Slight smile

    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

Reply
  • 0 in reply to jland47

    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 Slight smile

    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

Children