Need some help understanding what the adverse impact of only partially using bins is: We have an issue where month after month we have variances between our inventory subledger, and our total inventory GL balances. I think I identified the root cause as being us turning on "USE BINS" for some items but not all, and the ones we did turn on to use BINS, we didn't do BIN putaway worksheets for 100% of the time. I'm trying to understand if I'm on the right track here - How does NS calculate inventory subledger/GL valuations when some items are set to use bins and some are not, given the same location. If I have 100 units of an item that doesn't use bins, then I turn "USE BINS" on, but don't do a bin putaway entry, what happens to the value/quantity of those items? It would appear the $ amount still lives in the GL balance but the units totally disappear - i.e. it shows we have units in a location, but 0 in any bins. Unfortunately we have 3m+ items in our system with all the different size/color/design variants, so running a standard Inventory Valuation report or Stock Ledger report doesn't load for us, so I'm limited to SQL when it comes to looking at the full picture.

Here is a query to get you started

SELECT InventoryNumberInventoryBalance.item
	,BUILTIN.DF(InventoryNumberInventoryBalance.item) AS itemName
	,InventoryNumberInventoryBalance.binNumber
	,BUILTIN.DF(InventoryNumberInventoryBalance.inventoryNumber) AS Lot_number
	,InventoryNumberInventoryBalance.quantityOnHand
	,InventoryNumberInventoryBalance.quantityPicked
	,InventoryNumberInventoryBalance.quantityAvailable
	,InventoryNumberInventoryBalance.inventoryStatus
	,InventoryNumberInventoryBalance.committedQtyPerLocation
	,InventoryNumberInventoryBalance.committedQtyPerSerialLotNumber
	,InventoryNumberInventoryBalance.committedQtyPerSerialLotNumberLocation
	,InventoryNumberInventoryBalance.location
FROM InventoryNumberInventoryBalance