Here is the list of questions sent out during the webinar rerun on September 9, 2025, along with the answers provided.
Can the CONTAINS function be used to test a list of values? similar to the list function in SQL
In NetSuite Saved Searches, the CONTAINS function is generally used to determine if a field contains a specific substring within its value for example, to see if an email field contains gmail. However, CONTAINS itself cannot test a field against a list of multiple possible values in a single function call.
You may use multiple CONTAINS (or LIKE clauses) with OR logic to test for several possibilities.
Is there a way to get a list of all formula?
You may use this SuiteAnswer for all the SQL expressions and formulas: 10101
Can we convert Standard /Custom your report to Saved Search?
No, NetSuite does not provide an automated way to directly convert a standard or custom report to a Saved Search. These are fundamentally different NetSuite features, each with its own structure, underlying data sources, and capabilities.
Can we use SuiteQL queries in Saved Searches?
No, you cannot directly use SuiteQL queries inside standard NetSuite Saved Searches.
Is there somewhere to test formulas? Sometimes they don't work for me and I don't know how to check how to correct them?
Unfortunately, we can only test the formulas on the actual saved search. I would advise to review SuiteAnswers IDs: 8450, 10101 to assist with troubleshooting as most common errors on formulas is related to the syntax used.
How do you remove all the decimal places in the results?
You can remove the decimal places in result by first converting the result to character TO_CHAR({amount},'9,999,999'), then if afterwards, you can convert again the value to numeric by using TO_NUMBER().
I have a SS where I am trying to compare the sum of expenditures against a preset spend cap, but I am struggling to include formulas that either shows the difference and/or highlight when the spend cap is close to being reached or is overspent. Can you show an example of a mathematical formula comparing a set amount vs a summary amount?
For comparison, you can use Condition function CASE {state}
WHEN 'NY' THEN 'New York'
WHEN 'CA' THEN 'California'
ELSE {state}
END
CASE WHEN {field} = {field} THEN 1 ELSE 0 END or you can customize the Condition function
After creating a new search, can the column be used as a filter?
Are you pertaining to one of the result columns? If yes, this can only be further filtered if the search is Grouped (e.g you have set a Summary Type). You would need to specify the column criteria under Criteria tab > Summary subtab of the search.
Can you decode the inventory location type? For example, I want to see a sum of on hand inventory in a location type 'Warehouse' in one column, and another for location type 'Store'
1.Base Saved Search
Start a Saved Search on the Item record, then add Inventory Location as a joined field if needed.
2.Formula Columns
Add two formula (numeric) columns:
a. Items On Hand - Warehouse
sql
⌄
CASE WHEN {location.custrecord_location_type} = 'Warehouse'
THEN {locationquantityonhand}
ELSE 0
END
b. Items On Hand - Store
sql
CASE WHEN {location.custrecord_location_type} = 'Store'
THEN {locationquantityonhand}
ELSE 0
END
{location.custrecord_location_type}
Does the character limit for CONCAT apply to the results or to the actual condition statement?
The character limit for functions like CONCAT typically applies to the result produced by the function, not to the condition or formula statement itself. In addition, when using CONCAT in conditions, the field storing that output (like Formula (Text)) will be subject to the field character limit.
Can you give an example on what you mean by ""In addition, when using CONCAT in conditions, the field storing that output (like Formula (Text)) will be subject to the fields character limit.""
Like for example, the character limit on the PO # field reflected on a Sales Order transaction is 45. Or the character limit of Long Text field type is 100,000 characters.
What if the information I am looking for is not on the list in the criteria? This is to show PTO bal per employee which is a report already available but I cannot pull as saved search as I only show 3 other options
If the the information is not in the list in the Criteria tab of the Search, it can still be pulled in the Results tab, as long the source record of the information you need to pull is not filtered out in the Criteria tab. However, if the information is also not available in the Results, then you can check the source record if the information is available. Since if it is not available on the source record, it cannot also be pulled on the search. It is possible to create custom field, if the information is not included in any of the fields of Employee record
Would a formula be the best way to show how many of a product has sold in last 30 and last 60 days on a re-order saved search?
Formulas alone typically aren't enough to directly calculate product sales quantities over specific rolling periods (like last 30 days and last 60 days) in a single saved search result row in NetSuite. However, there are best practices to achieve this for a re-order (inventory) saved search.
1.Use a Transaction Saved Search (or an Item Saved Search with Joins)
2.Calculating Quantities Sold in Specific Periods
You typically use Summary Types and Criteria:
For Last 30 Days:
Add a filter: Date on or after = today - 30
Group your results by item
Use the Sum aggregate on the quantity field
For Last 60 Days:
Repeat with filter: Date on or after = today - 60
The best recommended approach would be to use the suiteanalytics workbook in this type of scenario
Is there a way to use formulas with customized fields? Whenever I try to use a custom field in a formula, I'm getting an error ERROR: Field Not Found