Hi 👋 Is it possible to use SuiteQL to brows the inventory to see what is in stock etc? I see there is a

inventorynumber

table, but that seems more like a mapping from inventoryId to kitid

Depending on what you're trying to do, this might help get you started.

SELECT
	Item.ID,
	Item.ItemID,
	BUILTIN.DF( AggregateItemLocation.location ) AS Location,
	AggregateItemLocation.quantityavailable	
FROM 
	Item
	INNER JOIN AggregateItemLocation ON
		( AggregateItemLocation.Item = Item.ID )
WHERE
	( Item.IsInactive = 'F' )
ORDER BY
	ItemID,
	Location

I've had success with the

inventorybalance

table, although I don't know whether certain features are required to be enabled in your environment in order to access it.

Thank you. I found most of what I needed in

inventorybalance

but will check out the

AggregateItemLocation

👍

You need

Advanced Bin/Numbered Inventory Management

to access InventoryBalance