ANS-0110 · SAVED SEARCHES & FORMULAS
How to Filter NetSuite Item Fulfillment Searches for Line Items Only?
Configure NetSuite saved searches to display only Item Fulfillment line items, preventing duplicate entries.
Short 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, shippingLine = false, and taxLine = false are also included. This configuration accurately isolates transaction line details.
Scenario
Users creating NetSuite transaction saved searches for Item Fulfillments may encounter an issue where the search returns duplicate lines. This typically occurs when attempting to retrieve a list that includes only the transaction's line item details, excluding the main header. The challenge is to configure the search filters precisely to achieve this specific result without redundancy.
Solution
To accurately retrieve only the line item list from a NetSuite Item Fulfillment transaction search and prevent duplicate entries, specific filters must be applied. The Main Line filter should be set to False to exclude the main transaction header. Additionally, the following filters are essential to refine the results further by excluding specific types of lines:
cogsLine = false
shippingLine = false
taxLine = falseBy implementing these filters, the saved search will display a clean list consisting solely of the item fulfillment's line item details.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support