204 results total
Browse practical NetSuite answers in Saved Searches & Formulas, filtered by topic, audience, and difficulty.
Answer
To build a consolidated A/R aging saved search, start with the Transaction record type, filter for Invoices with an Open status, and use formula (currency) columns to calculate…
Read answer→Answer
NetSuite currently does not permit direct modification of options within native 'available filters' for saved searches, particularly for type fields. For type fields, the visibility of '-None-' depends…
Read answer→Answer
No, available filters in a NetSuite Transaction Saved Search cannot display the status of a specific transaction type exclusively. This limitation occurs because the saved search is designed…
Read answer→Answer
Directly sorting a NetSuite Saved Search column that displays customer numbers as clickable URL links, while also ensuring no duplicate values and stable sorting behavior, is not fully…
Read answer→Answer
Yes, wildcard characters can be used when filtering results in NetSuite using a custom field of type Free Form Text. The Oracle PL/SQL LIKE operator allows for conditional…
Read answer→Answer
To differentiate between Drop Ship and Special Order Purchase Orders originating from a Sales Order in NetSuite saved searches, utilize the `Applied To Link Type` field. This filter,…
Read answer→Answer
Certain NetSuite GUI search capabilities do not translate directly to scriptable searches. While projects are easily found in the UI, scripts must search the 'job' record type. Filtering…
Read answer→Answer
In NetSuite saved searches, using the ABS() operator in a formula with a 'SUM' summary type calculates the sum of the absolute values (pre-aggregation). The behavior of the…
Read answer→Answer
NetSuite prioritizes sorting definitions established directly within the user interface of a saved search. Any sorting instructions specified through scripts will only be applied after the UI-defined sorting…
Read answer→Answer
When searching for an employee by email, NetSuite's default behavior may query both the primary 'email' and secondary 'altemail' fields. While 'altemail' is not directly accessible on loaded…
Read answer→Answer
When using formulas in NetSuite Saved Search Available Filters, the system leverages the first formula in the Criteria tab that matches the type specified in the Available Filters.…
Read answer→Answer
Child record values can be accessed in NetSuite saved searches when the 'Record is Parent' field type in the custom field matches the search type. For instance, a…
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.