SuiteQL query to get the item’s price level history

The query given below will give an item’s price level history. It is queried using the InvtItemPriceHistory table.

SELECT
	BUILTIN.DF( PriceType ) AS PriceType,
	Version,
	Quantity,	
	Price,
	Discount
FROM
	InvtItemPriceHistory
WHERE
	( Item = 1223 )
ORDER BY
	PriceType,
	Quantity,
	Version

Leave a comment

Your email address will not be published. Required fields are marked *