ANS-0130 · SAVED SEARCHES & FORMULAS
How to Query Item Fulfillment Details from a NetSuite Sales Order
Learn how to access specific item fulfillment statuses, such as picked or shipped, directly from sales order records using standard NetSuite transaction links.
Short answer
To query item fulfillment details from a sales order, set search criteria to "Main Line False". The "Fulfilling/Receiving Transaction" link provides information on various fulfillment statuses, including shipped. The "Applying Transaction" link can also access item fulfillment records, allowing filtering by statuses like picked.
Scenario
Users often need to retrieve detailed item fulfillment information directly associated with a sales order. This typically involves identifying the status of items, such as whether they have been picked, packed, or shipped, to gain a comprehensive view of the order's fulfillment progress.
Solution
To effectively query item fulfillment information from a sales order, it is crucial to set the search criteria to Main Line False. This ensures that line-level transaction details are included in the search results.When retrieving fulfillment data:The Fulfilling/Receiving Transaction link can provide information on item fulfillments, including their various statuses such as shipped.The Applying Transaction link can also be used to access item fulfillment records, allowing for filtering by statuses like picked.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support