Saved search to show where pricing is NULL

AI generated answer (using internal Slack threads):

To create a saved search that shows where pricing is NULL, you can follow these steps: 1. Navigate to the saved search creation page in NetSuite. 2. Select the type of search you want to create. In this case, it would be an 'Item' search. 3. In the 'Criteria' tab, add a new criterion. Select 'Pricing' from the dropdown menu, then select 'Price Level' or 'Unit Price' (or any other pricing field you're interested in). 4. Set the operator to 'is'. In the value field, leave it blank. This will search for records where the selected pricing field is NULL. 5. In the 'Results' tab, add the fields you want to display in the search results. This can include the item name, description, base price, etc. 6. Save the search. However, there is a known limitation with saved searches in NetSuite. When you add joins to your results (or criteria), records where those joins don't exist (in this case, items without pricing) don't appear in the search results. This is why when you add the pricing: price level and pricing: unit price columns, it limits the list to fewer items. To overcome this limitation, you could switch to using either a SuiteAnalytics workbook or SuiteQL, depending on your use case. Alternatively, you could join multiple searches via script. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******