I have a surprising issue with Items By Location. This particular item has item ledger entry quantity amounting to -30 for location A, however the Items By Location is showing quantity as 95 that same location (location A).
I have tried to test the keys and optimize the database, but no help. The Item availability by location is showing the correct amount of -30, but items by location is showing 95.
Thanks in Advance