This article explains how to retrieve price level mappings and fetch price change details for inventory items using a combination of saved search and SuiteQL queries in SuiteScript 2.x. The approach compares pricing records of different versions to highlight pricing updates. Overview of Key Functions getPricelevel() Retrieves all price levels from NetSuite pricelevel record type… Continue reading How to Get Price Changes Using Saved Search and SuiteQL Queries in NetSuite
Tag: item price level history
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