204 results total
Browse practical NetSuite answers in Saved Searches & Formulas, filtered by topic, audience, and difficulty.
Answer
To display the item rate from the sales order in an Item Fulfillment saved search, add a custom Formula (Currency) field. Use the formula {appliedtotransaction.rate}. This formula directly…
Read answer→Answer
To display the latest activity title on a NetSuite opportunity record, create a saved search of type 'Opportunity'. Configure a Formula (text) result `max({title}) keep(dense_rank last order by…
Read answer→Answer
To display the unbilled amount at a line-item level on a Sales Order saved search, use a formula field. Since standard 'Amount Unbilled' fields are not line-level, calculate…
Read answer→Answer
User Notes associated with Sales Orders are not directly accessible in standard NetSuite reports, including transaction reports. To view and report on these notes, users must create and…
Read answer→Answer
The Vendor Bill Due Date is not directly available at the line level. To display it, utilize header-level Date and Terms. Create a formula to calculate the due…
Read answer→Answer
To display the Vendor Name on all lines of a Vendor Bill in a NetSuite saved search, create a Transaction saved search. Use a Formula (Text) field in…
Read answer→Answer
When creating NetSuite saved search filters, use 'internalidnumber' for numerical comparisons like 'greaterthan' or 'equalto'. For 'anyof' operations with 'internalid', ensure the ID list is never null or…
Read answer→Answer
The 'Has Keywords' operator in NetSuite saved searches allows for searching multiple terms using the 'OR' operator. For exact phrase matching, enclose the keyword in double quotes. This…
Read answer→Answer
NetSuite's Global Search for tasks includes both the task title and assignee names by default. For specific custom search requirements, a custom field can be created on the…
Read answer→Answer
To ensure accurate results for NetSuite scheduled saved searches with dynamic date criteria, align the search's execution time with your data needs. If a daily search runs early,…
Read answer→Answer
NetSuite saved searches using CASE WHEN statements with language-specific criteria will yield different results based on the user's language setting. To resolve this, modify the formula to include…
Read answer→Answer
To exclude duplicates, configure your saved search criteria to filter by status and a numeric formula. In the results, use grouping and aggregation functions like 'minimum' and 'maximum'…
Read answer→No answers match those filters.
We use only optional tools to measure site usage and manage HubSpot forms. You can accept, reject, or choose category by category.
Optional tools are off by default. You can change your choice at any time.
Always on. These only remember your consent choice and support site security. No analytics or marketing tool runs in this category.