1,941 results total
Browse the knowledge base by search, topic, audience, and difficulty.
Answer
To display only line items in a NetSuite Item Fulfillment transaction search and avoid duplicates, apply specific filters. Set Main Line to False, and ensure cogsLine = false,…
Read answer→Answer
To display only line items in a NetSuite opportunity saved search, add a criteria for "Main Line" and set its value to "False". This ensures that only individual…
Read answer→Answer
To correctly filter NetSuite saved search results for the logged-in Partner Center user, embed the DECODE formula within a CASE WHEN statement. This ensures the {me} keyword is…
Read answer→Answer
To filter NetSuite transactions by items in a saved search, add "Item on Any Line" to your search criteria. If the goal is to exclude transactions containing specific…
Read answer→Answer
To filter a NetSuite saved search for 'noneOf None' on a multiselect field, use a Formula (Text) filter. Set the formula to the multiselect field ID and the…
Read answer→Answer
To filter a NetSuite saved search based on a discrepancy between two counted fields, apply a Summary filter. Configure this filter as 'COUNT - Greater than 0' and…
Read answer→Answer
To filter a NetSuite search by multiple values for a custom field, configure the field as a List/Record type with a defined list of values. In the search…
Read answer→Answer
NetSuite does not offer a direct, native method to filter or list segments where an associated numerical value, such as 'greater than 200', is applied. Standard custom searches…
Read answer→Answer
To filter NetSuite transaction searches by a range of customer names, utilize a formulatext search filter. This involves constructing a SQL CASE WHEN formula that evaluates UPPER(SUBSTR({customer.companyname},0,length)) against…
Read answer→Answer
To filter NetSuite transactions for open status, apply specific criteria based on transaction type. For invoices, filter for "any of (Invoice:Open CustInvc:A)". For sales orders, filter for "none…
Read answer→Answer
To filter items on a purchase order by the selected vendor, create a custom record/list field of type 'item'. Configure this field to filter items where their preferred…
Read answer→Answer
To search for marketing campaigns, utilize the NetSuite Records Browser to identify relevant search filters. Navigate to the Campaign record and locate the issalescampaign filter in the search…
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.