What is the source of the “42”? (I know this is your question)
I mean what provides the data for the tracker grid?
Does the PartWIP table act like PartBin, where it doesn’t hold every transaction, but rather the result of the last transaction. And deletes records when Qty goes to zero.
From what I can tell, perhaps it does
// Some random reflected line of code
PartWip.Quantity = PartWip.Quantity - PW_Quantity;
if (PartWip.Quantity <= 0)
{
Db.PartWip.Delete(PartWip);
}
How does that work when WIP Qty would go negative? Like if your received the parts to stock BEFORE reporting a production qty.
@jgiese.wci - quick question about the Part trans for that job.
From your screen shot:
Why the negative STK-MTL transactions?
Also, I always sort parttran by TranNum. Give you a better view of the order things really happened in.
The first two are backflushed why they are negative no idea. The last one they returned the remaining roll of paper from the job.
I tried doing some math to see if any of the ratios (like initial qty issued to Total issued) matched the ratio of 42 / 56 (which happens to be exactly 3/3 or 75%, if that means anything to you).
We don’t track labor or report Qty’s (or even have the AMM module), so I’m not familiar with all the inner workings of those systems.
What happens if a reported Production Qty is changed? (if that’s even a thing).
And do the Labor Types “I” and “P” mean something specific? What was completed on 8/31? There’s no Labor Qty.
When material is backflushed, any change to a labor record (recalling, changing, and submitting again) will cause a negative STK-MTL to back the old backflush qty out, then a new positive STK-MTL transaction with the new backflush qty.
EDIT: As of 10.2.600.3, it looks like this is no longer the case. Back on 10.2.300, this was true, but looking at some part transactions from last week, I’m not seeing the same behavior. Now, Epicor is making a differential entry instead of reversing the old entry and entering a new entry for the total amount.
Labor Type “I” is Indirect Labor (Start Indirect Activity in MES), “P” is Production Labor. Indirect Activity normally isn’t applied against a job I thought, unless that’s from using the Downtime function in MES.
I don’t allow them to change qty in Time & Expense anymore only job adjustment so there is a for sure transaction with it. Otherwise we had cowboys going in and changing qty on labor records to tie things out and we had no idea who or when it was done. Change log of course worked but that’s not easy to read.
Please check the Dimcode and UOM field in PartWIP table. Is Inventory UOM CS for that part?
UOM is CS, DimCode is always empty for us.
