Stock Count

Kinetic ERP
1

Hi,

I’m preparing for our first stock take in Epicor in February and would appreciate some advice.

What’s the best approach for stock that is in WIP or EOL bins?
Is generating tags for the shop floor recommended, or is that process intended only for the warehouse?

Alternatively, should we use quantity adjustments after the counts have been completed?

Thank you in advance for any feedback?

2

I can’t answer the other questions. Yes. Use Quantity Adjust to correct your inventory counts. Unless things have been misplaced. Sometimes I have to use Inventory Transfer to move materials from one bin to another, or between warehouses.

3 Likes
3

If the WIP is truly WIP and issued to or sitting on open jobs, you will not be able to count it as part of a cycle count or physical inventory in Epicor. The count process in Epicor only counts parts in inventory locations.

If you use the Physical Inventory process, it will post the quantity adjustments for you when you finish the count. If you’re manually creating tags and counts outside of Epicor then you will need to post quantity adjustments. Or, like Nate said, you can use Inventory Transfers to just move parts if the overall count is correct and you’re just changing locations.

4 Likes
4

Counting Materials in WIP (or even finished product in WIP) is probably one of the most common questions asked about Physical Inventory (And Cycle Counting). And… The answer is “NO”. you cannot do that.

So here is the challenge.

  1. I have a job to make 100 transformers. due to predefined scrap rate, the job requires 110 bobbins, and 2200 feet of wire.
  2. SO… i issue the material to the job. 110 bobbins, and one five pound spool of wire. (whoops… we already have a challenge.
  3. Manufacuturing starts winding parts. They have finished 75 of the bobbins. OH.. did i mention that 25 of those have gone forward to the next step, and started getting Soldered to their base? Did i mention that this assembly step also scrapped 3 of the units?
  4. NOW… someone starts the Physical Inventory

Question? How many bobbins do I have “in wip”… there are 36 unwound ones, 25 have been forwarded and partially soldered, but some scrapped…
So.. It is very difficult to tell… and WIRE is even worse? How much wire do i have? I cannot tell without weighing it, and even then, it will change 5 minutes from now.

SO… the Answer is:

  1. You only count STOCK ROOM LOCATIONS (or BACKFLUSH LOCATIONS that are on the shope floor).
  2. You also AUDIT your WIP. This means that you get a list of jobs, and verify that all the material that was supposed to be issued to the job has been issued, and is somewhere in WIP.
  3. Make sure that every job that is supposed to be in wip actually is there (no missing jobs).

OK, I will get off my

3 Likes