We are wondering how companies using Epicor 10 coordinate and verify their year-end physical inventory of WIP parts with the Epicor 10 WIP Report. For example, you can print tags for the physical inventory of parts on stock status and reconcile the counts but not for any WIP inventory items.
WIP is not “really measureable” is it? Or is it not accurate… or both?!
Just kidding!
What I meant was, the JOB/PDR report has ESTIMATES on it… and actuals are collected.
Bottom of PDR will show EST $ and Actual$
The details of the transactions should sum to the ACTUAL$ and the actuals will be in the aligned WIP accounts.
The GL Controls will target WIP accounts (hopefully you do not have just one WIP account, too short-sited). Once the Capture COS WIP process is run, the GL Accounts should have up-to-date-balances.
The problem is data-accuracy of transactions to jobs!
I presume your company endeavors to be sure the delta of actual $ to estimate $ is not absurd per JOBs and transactions, etc.
IF the Mom’s are not close to being accurate… and transaction reporting is not reliable, then any effort to reconcile WIP… is a waste of time.
Ultimately, just trust the #'s in the WIP accounts.
Also audit your job/production execution with focus on excessive variance!