Category

Netsuite

5 guides in this category.

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 : Check your Preferences to see if…

Read guide

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…

Read guide

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…

Read guide

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…

Read guide