ANS-0069 · SAVED SEARCHES & FORMULAS
How to Export Item Price Level Data in NetSuite
NetSuite users can extract detailed item pricing information by leveraging saved searches, either directly or by joining related records.
Short answer
To export item price level data in NetSuite, users have two primary methods. They can either create and run a dedicated Pricing saved search, or alternatively, they can initiate an Item saved search and then join it with the Pricing record to include the necessary price level details for export.
Scenario
Organizations often need to extract comprehensive item pricing information from NetSuite for various analytical or reporting purposes. This frequently involves exporting the data found within the Price Level sublist of individual item records. Users seek a method to efficiently retrieve this specific pricing data for multiple items.
Solution
To export item price level data, users can employ NetSuite's saved search functionality through two distinct approaches. The first method involves creating and running a dedicated Pricing search. Alternatively, users can initiate an Item search and then establish a join with the Pricing record to incorporate the relevant price level details into the search results for export.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support