MWING wrote:We are a midsize Toyota dealer using R&R. We have an ongoing problem with an imbalance in our parts inventory value. After reconciling each month, accounting is showing less inventory then what parts shows. It grows each month. Over a 3 year period we have done 2 inventories and they have verified what R&R shows we have, is what we have. After doing a physical inventory we made a manual correction on the accounting side. We are good for a month and the problem continues. We are not talking small amounts. After a year it’s between $50-70,000. We believe we have gone over every possibility twice and sometimes 3 times and can’t find anything. I have come to the conclusion that somehow something on the accounting side is relieving the inventory twice. This is a shot in the dark for us, but I’m hoping someone out there has had this problem and found the solution.
Do you have an EOM process that accounts for parts on GL not received yet, parts received not on GL , work in process etc?