1,941 results total
Browse the knowledge base by search, topic, audience, and difficulty.
Answer
To correctly implement a CASE WHEN formula in NetSuite when a logical test keyword contains an apostrophe, utilize the field's internal ID instead of its display name. For…
Read answer→Answer
When formulas like {record.field} don't work directly on transaction columns with 'Default Value' and 'Store Value' unchecked, use the 'Sourcing & Filtering subtab' to source the record and…
Read answer→Answer
When scripting NetSuite saved searches, use 'internalidnumber' for applying mathematical filters such as 'lessthan' or 'greaterthan' to an internal ID. However, when defining a column to display or…
Read answer→Answer
To align NetSuite's 'Week of Year' function with ISO 8601 standards in saved searches, utilize the specific PL/SQL syntax: to_char ( {date} ,'IYYY-IW'). This formula ensures that both…
Read answer→Answer
To use a multi-select field as a plain text filter in a NetSuite saved search, select its corresponding join table's "Name" field in Available Filters. This method provides…
Read answer→Answer
NetSuite supports the use of multiple billing addresses for vendors. While the system does not automatically select a specific address, users can manually choose the desired billing address…
Read answer→Answer
Regular expression grouping in JavaScript allows for the extraction of specific substrings from a larger string. By enclosing parts of the regex pattern in parentheses, each matched group…
Read answer→Answer
To successfully use render.emailMerge in NetSuite server-side scripts such as Map/Reduce, ensure that the templateId and entity.id parameters are cast as numbers using parseInt(). Passing these values as…
Read answer→Answer
To include a service item as a component in a NetSuite assembly, an Expense account must be defined on the service item record. While not always strictly mandatory,…
Read answer→Answer
To effectively use the 'noneof' search operator on list/record fields in NetSuite SuiteScript 2.x, always specify the internal ID of the list members you wish to exclude. This…
Read answer→Answer
To use the transaction date for commissions on NetSuite return transactions, uncheck the 'DEFAULT SALES EFFECTIVE DATE TO LINKED SALES EFFECTIVE DATE' checkbox on the Setup > Sales…
Read answer→Answer
Yes, NetSuite's global search supports the use of French acronyms for efficient record retrieval. For instance, users can type `CLI:` to quickly locate records related to 'Client'. 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.