Good chance that functionality was something from V8 - that was replaced by multiple UOMs.
When we were on V8 we looked into a solution to track cable that we use. It wasn’t rare to have several reels with a few hundred feet each. Jobs could require anywhere from 10 to 1,000 feet - but it had to be continuous. So we wanted something that direct us to which reel to use to minimize the scrap.
Hmm, didn’t think it through very well. I was just thinking a configurator could automatically select the lot number / serial number suitable for the job. But it sounds like you haven’t even got to the point were you are trying to select materials. Sorry.
How about by Bin? Make as many bins as you need, and do some BPM magic to prevernt receiving or issuing qtys to/from bins that don’t match the bin’s “length”
Wouldn’t even need to physically separate the parts
hmm that’s not a terrible idea… so have them sotore all the pieces of the same size in the same bins… I mean 11K bins… LoL but … could work…
Though I wonder what having 11K bins would do to Epicor …
What do you think the main issue with 11k bins would be? I wonder if you could set it up so the bins were automatically created when there was pieces of the correct size and then deleted when empty… If there were only a few sizes at a time that might help keep the bin count low.
I would guess a similar performance issue… but maybe in different areas… maybe worth a shot.
IE Part Tracker… would have to load (ostensibly) 11K records per warehouse , per plant…
The idea situation is if we could have “arbitrary” attribute at PartBin / PartTran level… (like Length, Width etc)
Kind of like Lot , PCID do… You can same SKU, same UOM but different partbin record for each different Lot , PCID
To understand this better, you’re saying they have something like a single part, that may be one of 11,000 unit lengths, and want:
To be able to track the QOH of each length independently
Only allow single lengths to fullfil a job requirements
a. A job needs a 10-1/6" length of this tube, so any QOH of shorter lengths would not be able to satisfy this demand
Are the tubes “made” to a desired length, or is it a semi-random output from the manufacturing process
Right! And the tubes are bought in whatever length and stored in inventory. Once cut you get now 2 pieces of length x and y which needs to be inventoried / available to a job that may need something of equal or lesser length.
You could suggest storing them vertically with a height strip next to them. Then when they need something for a job they can just eyeball whats in stock.
I have in the past suggested just tracking whole feet… or even half feet… so you always go to the pile that is within ± a foot… but that’s never been accepted as a solution…
If they have people there that can follow directions to that level of detail, I wanna work there! I can’t even get people to pick a bin to ship something from. I can’t imagine trying to get them to pick a specific stick out of a pile.
I’ll be interested to see what kind of solution you come up with. Personally, I think that you need to integrate a nesting software. There are ones out there that will track individual pieces.
We actually had a part number for a cable that had the suffix “-SHORT PIECES” where the useable scrap from a 5000 FT reel would be transferred to. It was a nightmare. Nobody ever bothered to find a useable piece. But accounting didn’t want to take the Inventory hit.