WIP Report shows negative quantity to inventory but zero is completed

We have a job in production that had an unneeded operation (op 30) as the last operation.There was a quantity of 12 completed for op 20 and nothing for op 30. We deleted op 30 off the job and flagged op 20 as final operation and auto receive to inventory. At that point we realized that some material didn’t get backflushed so we undid the labor for the quantity of 12 on op 20.
This has now thrown the job into disarray. We have zero quantity in inventory but our WIP report and the production detail report show zero completed but -12 to inventory. This is causing about $25k to go into variance and is altering the completed costs of the units.
I’m not sure how better to explain this. Has anyone ever had this happen? Is there a conversion or datafix that can realign those numbers?
TIA

How did you do this?

We went into Time and expense entry and changed the quantity of the labor entry from 12 to zero. We saved and submitted it. After correcting the material errors and re-completing the labor entry there were 12 in inventory but History tracker showed the costs were about 30% of what they should be and both the WIP and production detail reports show 12 complete but zero to inventory.

It’s been a while since I dealt with Auto Receive, but I remember that when errors happen they are hard to fix. I would mark the final operation as complete and just do Job Adjustments to get everything to equal out. Trying to backtrack the transactions that happened will be difficult since so much changed.

Yeah I’m not sure our CFO will go for that. This is a high dollar job and he is beside himself with the variances. I’m going to make a case with Epicor about to see what else we can do. Thanks

I know I’m late but I can shine a little light for the next person who might stumble across this looking for help. When you uncomplete an operation in Job Adjustment, it will unbackflush materials associated with it and unreceive it (if that operation was auto-receive = true).

So what it sounds like happened: you completed op 20, then marked it Auto-Receive which would not have brought that assembly into inventory. However, when you did the job adjustment to “uncomplete it”, it was marked Auto-Receive so it unreceived 12 assemblies from inventory (which hadn’t actually gone into inventory yet).

I don’t remember exactly how to get out of it but the solution lies in that Auto Receive flag. You basically need to undo the steps you did in the reverse order. Then get back to “neutral ground” and do the change you intended to do.

2 Likes

That’s sounds correct. I can’t remember exactly what we did to correct this but that sounds like the right workflow. We also might have made a journal entry to correct the variance.