So I have not used the Epicor physical inventory before. We want to do a count coming up in about a month. I have no confidence that our inventory procedures are that close to reality. I think overall, the on hand quantities are probably close, but the locations I’m pretty sure are hosed. I’ve tried messing with the cycle count system that epicor has out of the box, and it was overly complicated and too hard to use.
Is physical inventory similar to that?
I’m thinking about simply having everyone use count tags, turn them in then make an entry screen for a UD table (train some monkeys to do the data entry). Two and a half years ago we went live with E-10 and actually had live inventory. Before that, it was walk around and see if you had it. So when they did counts, it was just to get a dollar amount. However, the tag system I am talking about would be what they are used to, so no retraining people there. They had an access database for keying in the tags. I would just replace that with a UD table entry screen.
Once I had the data into the database, I would attack the reconciliation on the parts with the most off on the on hand and just doing adjustments with inventory adjust. I’ll get as much as I can done until we have to start again, prioritizing with part numbers that have planned usage first, then fix the ones with no usage after they start up the shop again, and just get as much done as we can.
Does this sound like a better plan then trying to use epicors physical inventory? At least until we get a better handle on inventory? I’m worried that the epicor process is too rigid and to transaction heavy to work for a poorly organized facility.