I have 3 items out of my entire DB that are out of synch, the Item Ledger Entry table sums up to 60, but when I run calculate inventory I am only showing 30. My real inventory count is 50. How can I get this cleaned and matched up?
Locations may be the issue, especially, if there are entries with blank locations. In long-used systems, where Loc=Mandatory has been switched on/off, Locs themselves added/changed, this may happen.
You are correct. They received the quantities into no location when location was mandatory.
Thanks for pointing me down this road.