MES Report Qty - Removing Twice as many parts from WIP

Epicor ERP 10
1

Hey all, I’m doing some testing with jobs on the MES for Epicor. I’ve set up some parts and BOMs from scratch.

There are 2 processes to manufacture this part.

The way the BOM is setup, three pieces create a subassembly, and then that subassembly is used on the next process to create an assembly that is shipped to a customer.

The process I’m following in MES after job creation:

Clock In
Issue 3 Child Materials to job
Report Quantity
End Activity

(This seems to move the 3 pieces into WIP correctly, and after reporting puts the manufactured piece into WIP)

For the second operation on the job:
Clock In
Report Quantity
End Activity

Final Operation/Auto Receive into Inventory is checked.

This puts the correct quantity into Inventory, but looks like it subtracts double the amount from the previous piece put into WIP.

As an example, if I have 50 WIP pieces and report a quantity of 10, 10 pieces are put into Inventory/Stock, but 20 are subtracted from the WIP.

image
image.png783×360 16.7 KB

All the quantity/parent are set up as 1, what do I need to double check so I can correct it?

Thanks!

:slight_smile:

2

I don’t think I’ve ever seen results like those you describe from a setup like that.

Just curious where are you checking the “amount”?

And if you can give us any more details…what the job tree looks like, material types, MES processing sequence?

e.g.

image
image724×462 112 KB

3

Here is the Job Entry:

image

These parts should are not set to backflush, but lot tracked using the Job Number.

What needs to happen (at least for this part)

Is that the 3 Materials are used in one Operation to create ASM 1.

Then that material (ASM1) is used at a different operation to create ASM 0.

At that point, ASM is set to auto receive into Inventory.

4

And just wanted to verify where you are seeing the doubling?
The finished part number?
PartTran qtys or are you looking at some other report or tracker?

5

I’m looking at the quantities using Part Tracker, I’m not 100% sure if it is doubling.

Here is what seems to be happening, hopefully more broken down now.

Job:

image

50pcs of each mtl issues to job

image

Reported Qty of 20pcs outs ASM into WIP of next seq:
image

WIP Qty for mtl pieces:

image
image
image

It looks like it pulled 20 pieces from only 1 material, but left the other material for the other pieces instead of subtracting 1 pc from each mtl.

This ASM should have consumed 20 pieces from each mtl

6

How do the quantities for the finished part look in the Part Transaction History?

I don’t always trust Part Tracker

  • it is using a summary table that occasionally get out of whack.
  • and when something does look weird I might run the built in process to recalc the part quantities ( I can’t remember the exact menu path off the top of my head ).
7

PartTran table looks good. How do I run that to recalculate part quantities?

PartWIP looks correct as well.

Edit: I’m running the Recalculate Quantities now on our test database.

With this getting so out of wack so often, is it easier to just create a BAQ referencing the partwip table to display the pieces that are assigned into WIP, and then the On-hand table for Finished Goods/Child pieces?

8

It has moved around with different versions
You can try looking here

System Mgmt --> Rebuild Processes --> Mfg/Dist -->

  • “Refresh PartBin QOH from PartTran”

You might want to run the report only for starters… so you want to verify any changes before committing.

9

I found it shortly after commenting, that is definitely the problem. Now my last question, hopefully!

With this getting so out of wack so often, is it easier to just create a BAQ referencing the partwip table to display the pieces that are assigned into WIP, and then the On-hand table for Finished Goods/Child pieces?

10

is it easier
TBD,

  • after running the refresh process and I might start with a simple BAQ that would list exceptions
  • If you can get an idea of how many parts/how often things are diverging, then maybe all you need t do is make the refresh process a part of regular routine maintenance?