Not in the count variance but in the “Count parts not posted” it does. Its says Ready for posting as the reason not posted
I have screen shot the reportHmm. You might have to open an EpicCare ticket on that one. I don’t recall if there’s a log created (don’t think so) but if there is, maybe there’s something in there. Once reason codes are set, you should be able to post.
Mark W.
I figured it out. Those parts are allocated which stops me from posting those parts.
Do you know what drives the ABC codes? I know that it classify parts in inventory based on usage and cost criteria but I was hit with the question “What drives the ABC codes?”
Epicor is pretty APICS standard in this respect. Multiple the part quantity[1] by the part cost, sort from highest extended value to lowest then use the percentages given in ABC Code Maintenance to assign the code. First assign the A parts to that percentage of inventory value, then assign all parts not yet assigned to B up to its B’s total percentage and so on.
Mark W.
- Where quantity is determined by what you include: quantity on hand, historical values, and/or future usage based on demand.
could you give me an example of what you mean?
Last question I believe. If I have multiple warehouses how can I pick which warehouse to cycle count?
When you schedule your cycles, you can only schedule by a single Warehouse. We have three (internal) warehouses so we have to schedule three cycle counts per day.
Because you ran the Calculate ABC report with the options to include past usage. It’s adding some historical quantity to the 596 QOH. (While you asked for future demand, the cutoff was for yesterday, so I’m guessing not a lot was added to the quantity in the future.)
Mark W.
That makes sense. So how should the ABC codes be set up and how often should you run the ABC report?
We are a customer demand manufacturing job shop, so I raw materials moves a lot and I’m trying to figure out what would be the best approach for us to take to cycle count.
Any suggestions or advice?
It’s really up to each company. The general rule is: count your most critical parts more often than the less critical. The ABC system is one way to do it. We do a daily cycle count that includes every part transacted in the previous day (because that is the most likely places errors would have occurred and we still remember those transactions) plus a smattering of parts that haven’t been counted in 180 days. We don’t even use the ABC for Part Selection but we do for some inventory evaluation reports. The goal is inventory accuracy and since you can’t do a physical inventory every day, a thoughtful system that counts the critical parts more often than the less critical is what you’re after.
Mark W.