204 results total
Browse practical NetSuite answers in Saved Searches & Formulas, filtered by topic, audience, and difficulty.
Answer
To obtain a list of items purchased by a customer in NetSuite, create a Transaction Saved Search. Filter the search by the desired customer and item criteria. This…
Read answer→Answer
The "Quantity in Transaction Units" field, or {quantityuom}, provides the quantity of an item on a sales order with its unit of measurement already applied. To determine the…
Read answer→Answer
To display the billed amount from a sales order in a NetSuite saved search, include the field 'Billing Transaction : Amount' in your results. Crucially, ensure that the…
Read answer→Answer
To retrieve the full name of the day of the week from a date field in NetSuite SQL, utilize the TO_CHAR and TO_DATE functions. This combination allows for…
Read answer→Answer
To get the last amount by date in a grouped saved search, add a group option on the 'Type' field. Then, add a formula field to the Results…
Read answer→Answer
To retrieve the internal ID of the currently logged-in user within a NetSuite Saved Search, use the `{me}` keyword. This dynamic value automatically populates with the user's internal…
Read answer→Answer
To prevent blank quantity fields from affecting your NetSuite saved search results, use the NVL function. This formula replaces any null or blank quantity value with zero, ensuring…
Read answer→Answer
To find backordered transfer order line items in NetSuite, create a saved search with two key filters: 'Transaction Line Type is Item' and a 'Formula (Numeric) is greater…
Read answer→Answer
To find inventory items with available quantity but no bin assignment, create a NetSuite saved search. Apply summary filters to check where the sum of 'Bin on Hand…
Read answer→Answer
To identify records exclusively running a duplicate workflow, create a saved search on the relevant record type. Use a formula numeric column with CASE {workflow.workflow} WHEN '*[original workflow…
Read answer→Answer
To track Sales Orders impacted by customer credit holds, create a custom field on the Sales Order. Use a transaction saved search with the 'customer: On Credit Hold'…
Read answer→Answer
To identify the employee associated with a Purchase Order in a NetSuite saved search for email alerts, utilize the 'Sales Rep' field. While 'Requestor' fields exist for other…
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.