We have recently discovered that the field Inventory in Items is not directly linked to bins, which can cause confusion when checking the number of items available in stock.

Let me give you an example. When someone wants to verify the number of items available in a particular bin, they can go to Bin Content, filter the item by a specific Bin Code and the system will show you the correct number of items for each line (bin).

However, if the same person tries to get the same outcome by filtering by bins directly in Items, the number they get will not reflect the number of items currently available in the given bin, but the system will show them the total amount of items in all bins instead.

We discussed the issue with Microsoft Support and they admitted that it really is a limitation of the current Business Central version but they do not plan to improve it any time soon. Instead, we got a recommendation to post it here.

Maybe you came across the exact same issue as we did and you would like to see it resolved too.