Item Counts in SuiteQL such as QuantityAvailable

Depending on your account settings, some fields such as quantityavailable may have moved off of the item table and may be found in itemCounts .

If you are getting “Field ‘QuantityAvailable’ for record ‘item’ was not found. Reason: REMOVED - Field is removed” you might find your counts on the inventoryitemlocations record.

In order to get a count of available accross multiple locations you need to pull from inventoryitemlocations.

To get a sum across all inventory locations:

Select 
	Item.itemid, 
	Item.description,   
	QA as "Avail", 
	QC as "Committed", 
	QOH as "OnHand", 
	QOO as "OnOrder"
	from item left outer join
		(
				SELECT 
					item, 
					SUM(quantityavailable) as QA, 
					Sum(QuantityCommitted) as QC, 
					Sum(QuantityOnHand) as QOH, 
					SUM(QuantityOnOrder) as QOO 
					FROM inventoryitemlocations group by item
		) as itemCounts
		on (itemCounts.item = item.id)
	order by Item.itemid