Hello, can we pull the Dealer/Wholesale price in saved search? I tried using the field but not able to find this field Also tried using the field id

price_1_

but it did not worked.

this should help get you there: https://suiteanswers.custhelp.com/app/answers/detail/a_id/13928/loc/en_US

@nikhil angawane It depends on what the base search is. If its an item search, then there is a join to "Pricing Fields", which will pull back the pricing of the item.

its a item search

Yeah, look toward the bottom of the field options for "Pricing Fields...", that will bring up another window to select the fields in the pricing area. In there the field "Price Level" corresponds to the name you see like "Dealer/Wholesale"

I tried the formulas but received the below error ERROR: Field Not Found

OK, the field for the price listed is called "Unit Price" under the same join

OMG.

You're welcome. It's a part of the inconsistency of NetSuite. A field name in the UI, a saved search, and in script don't always match.

Understand. 😅

I found a really helpful formula I use a lot to display specific price levels on an Item Record saved search. In your Results, try this formula: DECODE({pricing.pricelevel},'*Dealer/Wholesale*',{pricing.unitprice},'') ...where "*Dealer/Wholesale*" represents the pretty name of your specific price level. It'll return the item price for the price level. I have reports with 4 or 5 columns of different price levels, which makes it much easier to work with in CSV/Excel than the usual "one row for every price level" return in a saved search if you display anything from the "Pricing Fields..." sub-table. Try it out!