This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Does anyone know a way to get an Item saved search to display the Sales/Pricing table for an item?  I almost have it but for some reason I can't get one of the price level rows to display for an item if it doesn't have any values specified for it.

Hmm I normally don't want/need the price level to show if value is null, in which case I use Pricing Fields... join. Not sure what your use case is, but you could try Formula (currency) with `CASE WHEN {pricing.pricelevel.id}=## THEN {pricing.unitprice} END` 

So then a column for each price level that you have. Summarize it on maximum and your SKU on group.

<@URD6Z862W> The problem is that it isn't even detecting it exists because there is no value to link it from the item table to the pricing table. I'm trying to get Price Level 3 to display

I'm wondering if there is a way to utilize the Other Prices field to populate the row that doesn't have any values.

I've encountered this issue, LMK if you find a solution.
I ended up just using a SuiteAnalytics workbook, which can handle this type of "left outer join" properly

At the moment the only thing I can think of is probably utilizing SuiteScript