Items By Location

Business Central/NAV Developers Forum
1

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

2

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)