Items By Location

Hi there.

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

The Item ledger calculates the balance from IN and OUT transactions, while the Item Availability By Location will consider the projections too (any Incoming or outgoing)