NetSuite Blog - July 6, 2023 - Item Saved Search to Display Price Levels as Columns - SuiteAnswer ID 76859

Recently I needed to create saved searches with price levels displayed as columns.  This can be used both as a backup when exported before updating price levels, or as a convenient way for users to do an export before they supply an import file for update.

There are multiple SuiteAnswers on this topic, IDs 76859 and 13928. However I found that neither of these worked as described.

If you have tried these and been unsuccessful, I found that the following formula works:

CASE WHEN {pricing.pricelevel} = 'price level name' THEN {pricing.unitprice} ELSE 0 END 

In your case replace price level name with the name of your price level.

Note this was used on an item saved search, not the pricing saved search described in 13928