969 results total
Browse practical NetSuite answers in NetSuite administrator, filtered by topic, audience, and difficulty.
Answer
To count unique transactions in a NetSuite saved search, employ a formula using COUNT(DISTINCT({internalid})) combined with a CASE WHEN statement for specific criteria. Ensure the formula field's Summary…
Read answer→Answer
NetSuite Saved Searches currently have a recognized limitation where sorting does not function correctly when multiple formula (numeric) fields are used as sorting criteria. This behavior is a…
Read answer→Answer
When configuring a NetSuite workflow to set a custom list/record field to the internal ID of the current record, use the field ID `{id}`. Unlike `{tranid}` or `{internalid}`,…
Read answer→Answer
To allow NetSuite workflows to populate native email fields with multiple addresses from a free-form text field, create a custom entity field, temporarily set its format to 'Email'…
Read answer→Answer
To alert users when Sales Order shipping costs exceed Invoice shipping costs, create a NetSuite workflow on the Invoice record. Utilize two custom transaction body fields to capture…
Read answer→Answer
To compare NetSuite timestamps by date only, use a Formula (Numeric) field with the trunc() function. This function removes the time component, allowing for accurate date-only comparisons between…
Read answer→Answer
To enable contract item creation for maintenance-only sales orders, include a $0 license line item marked 'Closed' with $0 VSOE allocation. This satisfies the script's requirement. Process the…
Read answer→Answer
The NetSuite preferences 'Only Show Last Subentity' and 'Only Show Last Subitem' (Home > Set Preferences) simplify displayed names to only the child. This setting also impacts server-side…
Read answer→Answer
To create a customizable administrator role in NetSuite, install the "Administrator Role - Customizable" bundle (ID 396121) or utilize the "Core Administration Permissions" feature. This provides a role…
Read answer→Answer
Standard NetSuite sourced list/record fields only display public saved searches. To use private saved searches, a custom SuiteScript solution is required. This involves performing a 'search of searches'…
Read answer→Answer
NetSuite's scriptable (FreeMarker) templates overcome CRMSDK tag limitations by allowing access to fields from related records and sublists. This enables inclusion of comprehensive information, like case details in…
Read answer→Answer
To display vendor-specific item codes on purchase order line items in a NetSuite saved search, group results by line number and PO number. Use a MAX aggregation with…
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.