How to Display Multiple Item Price Levels in a NetSuite Saved Search

To accurately display various item price levels in a NetSuite saved search, users should leverage the 'Pricing' join. Instead of relying solely on the 'Rate' field, which typically represents the base price, the recommended approach involves adding the 'Unit Price' field from the 'Pricing' join. To differentiate between various price levels (e.g., Base Price, Online Price, Alternative Price 1), users can either add multiple 'Pricing' joins and filter each by a specific 'Price Level' in the criteria, or use a formula (e.g., a CASE statement) in the results to conditionally display the 'Unit Price' based on the 'Price Level' field. This ensures that each desired price level is correctly represented in the search results.