Has anyone had any success with tracking various lengths of wire and cable in your inventory? What method or changes to NS did you use to keep an accurate account for the total length available as well as all the cut pieces?

Lot numbers are a good way if you are looking for the total length by spool. Not sure if you use a WMS but RF-SMART has some auto lot generation during your receiving process that may help. This would assume your stocking unit is feet, than each roll would be lot controlled. You would than see total lots on hand = total spools and than than the stocking unit (feet) would provide the total length by roll.

That could work, thanks. We do use WMS and RF-Smart. Our biggest issues is the various pieces of cut length wire and cable that accumulate over time from being cut off spools or other pieces of longer length. So by doing so we end up with a bunch of various lengths that get tagged and thrown in a giant box. We tag them so we can visually see what is what, but when looking in NS, all we see is overall (feet) available, so our sales reps are always calling the warehouse to find out what's actually available in continuous lengths, which is just time consuming and tedious. Lots could solve that though, as we cut and have remainder, we could possibly assign a footage to each lot. It needs to be visible to the sale reps when viewing the item stock, so that's the other trick as well.

I have also seen people do work orders for the cut and then the new cut piece would get a new lot, for example if the spool lot is 123, than the cut piece may be 123-A. If all depends though on operational process though as that could limit efficiency.