Customer Saved search results to show pricing group, result is blank

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue of the customer saved search results showing blank for the pricing group is due to the way NetSuite handles joins in saved searches. When you add joins to your results or criteria, records where those joins don't exist don't appear in the search results. This is a known limitation with saved searches in NetSuite. In the case of items without pricing, when you add the pricing: price level and pricing: unit price columns, it limits the list to only those items that have pricing data. Items without pricing data are not shown, hence the blank results. Moreover, if you had filtered by some of the pricing fields (for example the Price Level field), then you could get blank results for Price Level and Unit Price. This is because an item that only has a unit price for a different Price Level would show up in the results, even though unit price would be empty for the "Base Price" Price Level. To resolve this issue, 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. ******