Anyone know definitively InventoryItemLocation vs ItemBinQuantity how they are supposed to work together. I have a requirement to show inventory by location AND bin in the same result. I'm finding inventory in both tables, which is leading to duplication unfortunately, I've got a row for than Item @ Location and also Item @ Bin .