Find NetSuite Field IDs: Tips and Tricks

How do you find the field ID on a Netsuite record? Whether you’re using SuiteScript or Saved Searches you will at times need to know the Field ID to use in your code or formulas. To ensure you can find the field ID on a record check your Preferences first. On the General tab make sure the Show Internal ID’s checkbox is ticked: ...

June 10, 2023 · 2 min · 278 words · Ryan Sheehy

Can't Find altemail In Saved Search Filter

Why can’t you search for altemail in a Saved Search filter? Whether you’re coding using SuiteScript or just using the Saved Search feature in Netsuite you might find it difficult to use the altemail field in Netsuite, as it doesn’t exist as a search feature in the Filter section of Netsuite’s documentation. So how do you search for this email address for your Individual Customer records where this field is used? ...

June 10, 2023 · 1 min · 88 words · Ryan Sheehy

NetSuite's IF Formula In Saved Search

Where is the IF function in Netsuite’s saved search area? It can seem quite odd at first trying to find the standard IF function in Netsuite’s saved search area, but you are not losing your eyesight, there is no IF function in Netsuite’s formulas. Instead of using an IF function you have two other types of functions available: CASE statement DECODE function Let’s explore these in a little more detail for your use case. ...

June 10, 2023 · 4 min · 720 words · Ryan Sheehy

NetSuite Saved Search Formulas: Getting Started

How do you use a formula in a Netsuite saved search? There are several different types of formulas you can use in a Netsuite saved search. They vary according to the result you are seeking to produce from numbers, text, dates and even HTML. You would use a formula when trying to calculate something that needs an operation or filter applied to a field that cannot be obtained from other fields or sources. A formula can be used created in the Criteria, Result and Highlight areas within a Saved Search. ...

June 10, 2023 · 6 min · 1139 words · Ryan Sheehy

How To Pronounce NetSuite?

How do you pronounce Netsuite? Is it Net-Sweet? The Correct Pronunciation NetSuite is pronounced as “net-sweet”. Here are some essential details you should know about the correct pronunciation The first syllable: It’s pronounced like the last part of the word “Internet“. Therefore, you should stress the “net” part and pronounce it like you would in the word Internet. The second syllable: The second syllable is pronounced like the noun “sweet”, which rhymes with the word “treat”. So, when you pronounce NetSuite, you should stress the “sweet” part and say it like you would in the word “sweet”. The emphasis: The emphasis should be on the second syllable. Therefore, you should de-emphasise the “net” part and make the “sweet” part a bit louder and with more intensity. It would be best if you didn’t make the mistake of pronouncing it as “Net-Sootee” or “Net-Sue-It.” These are common mispronunciations, and they might mislead the audience. ...

June 10, 2023 · 4 min · 709 words · Ryan Sheehy