Items: Item Group Prices

Returns the price for a specified Item Group.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-item-groups/
SELECT
	ItemGroup.ItemID,
	(
		SELECT
			SUM( ( ItemPrice.Price * ItemMember.Quantity ) )
		FROM
			ItemMember
			INNER JOIN Item AS MemberItem ON
				( MemberItem.ID = ItemMember.Item )
			LEFT OUTER JOIN ItemPrice ON
				( ItemPrice.Item = MemberItem.ID )
				AND ( ItemPrice.IsInactive = 'F' )
				AND  ( ItemPrice.PriceLevelName = 'List Price' )
		WHERE
			( ItemMember.ParentItem = ItemGroup.ID )
	) AS ListPrice
FROM
	Item AS ItemGroup
WHERE
	ItemGroup.ID = 681127

Click here to return to the list of available queries.