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

How can you get the name of the price level instead of the internal id? 

<@U0192EPLECU> If you want to use SuiteQL, you can do this: `SELECT * FROM ItemPrice WHERE Item = 18`

If I use getSublistField, the get the label, it just returns “Price Level” I was expecting it to return the name of the price level 

For any given item, I have 10 different price level. Base price, dealer, contract price level etc. I’m trying to get “Base price”, “dealer” but I seem to only can get internal id of the price level

load the record in a debugger, and log the record to see what fields you have available

if you can see the name in the ui, there is probably a field for it

Another hack I see... that has to be used 

It's not a hack, the name might not be there on the price sublist, its a pretty special/weird one

the probable answer is that netsuite didnt implement the field as a select field

which means it uses another field for the name

Haha, there seems to be a lot of these special cases

Thanks guys, guess I’ll have to load the list first to get the name

there are multiple ways to see the data you are working with

low effort is adding &amp;xml=T to the url of your record to see what data there is

medium effort is loading the record in suitescript and printing the record's .toJSON form

lower effort extension based approach is the <https://chrome.google.com/webstore/detail/netsuite-field-explorer/cekalaapeajnlhphgdpmngmollojdfnd|NetSuite Field Explorer>

all would give you an idea on which field you should be getting instead of pricelevel