This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

SELECT
	BUILTIN.DF( InventoryNumber.Item ) AS ItemID,
	InventoryNumber.InventoryNumber,
	BUILTIN.DF( INL.Location ) AS Location,
	INL.QuantityOnHand

FROM
	InventoryNumber
	INNER JOIN InventoryNumberLocation AS INL ON
		( INL.InventoryNumber = InventoryNumber.ID )
where
	inventorynumber.item=429 and
	inventorynumber.inventorynumber='L21221010'