I’m in the middle of determining an unknown DMR variance this month. The only reconciling issues I’ve seen in the past are related to PUR-ADJ transactions, however that’s not the case this month. Does anyone have any obvious areas they would look? We have a good amount of DMR activity to make this a difficult variance to identify.
Have you reviewed the Inventory Hierarchy?
Are the Accounts set up in DMR on the company Inventory COS and WIP GL Control?
What about the Part Class GL Controls?
Assuming you are running Inventory COS WIP reconciliation report filtered to just the DMR transactions.
To dig deeper, turn on logging on the COSandWIP GL transaction type and run the recon report then go look at the log. (Copy and paste it into Excel to read it easier.)
Make sure to turn off the log, or your Captures will take a long time…
Bruce,
I found the issue. One of our DMR’s was closed with a remaining quantity of inventory. The DMR was reopened, our quality department rejected/returned the remaining inventory to our supplier, and the DMR was closed again. This solved the problem. When a DMR is closed with a remaining qty, the DMR GL will always be overstated when comparing to the DMR subledger (Open DMR Status Report).
I can’t think of any situation where a DMR should be closed with an existing remaining qty, so I submitted this example to epicor ideas. I’m hoping epicor will create a BPM that will prevent DMR’s from being closed until the “remaining qty” field has been cleared.
