Stock Status qty vs Valuation qty
The new version of the inventory balance utility does not allow you to choose which table has the right quantity. In this case the valuation is incorrect and the stock status is correct. The utility forced the on-hand quantity in the warehouse to match what the valuation quantity said. The problem is lots that should have been fully distributed were not. The inventory transaction detail shows the correct total product being issued but lots that should be zero still show a quantity. The issue transactions came from work order material issue. The raw material is lot costed. Started a Sage Case on this one. Will see how it goes.