Items: Aggregate Information by Location

Returns location-specific inventory information for a specified item.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-upsell-items-by-customer/
SELECT
	BUILTIN.DF( Item ) AS Item,
	BUILTIN.DF( Location ) AS Location,
	QuantityOnHand,
	OnHandValueMLI AS Value,
	AverageCostMLI AS AverageCost,
	LastPurchasePriceMli AS LastPurchasePrice,
	PreferredStockLevel  AS PreferredStockLevel,
	LeadTime AS PurchaseLeadTime,
	SafetyStockLevel,
	LeadTimeOffset,
	QuantityOnOrder,
	QuantityCommitted,
	QuantityAvailable,
	QuantityBackOrdered,
	QuantityInTransit,
	QtyInTransitExternal AS QuantityInTransitExternal,
	LastInvtCountDate AS LastCountDate,
	NextInvtCountDate AS NextCountDate,
	InvtCountInterval AS CountInterval,
	InvtClassification AS Classification,
	CostingLotSize
FROM
	AggregateItemLocation
WHERE
	Item = 212
ORDER BY
	Item,
	Location

Click here to return to the list of available queries.