ANS-0959 · WEB SERVICES & INTEGRATIONS
How to Search for Sales Orders by Status Using NetSuite Web Services
This guide explains the correct enumeration to specify sales order statuses when querying NetSuite via web services, ensuring accurate transaction retrieval.
Short answer
To search for sales orders by status using NetSuite web services, specify the desired status value, such as _salesOrderPendingFulfillment. It is crucial to reference the SalesOrderOrderStatus enumeration within the NetSuite Schema Browser to identify all valid status options for the orderStatus field, ensuring precise filtering in your web services requests.
Scenario
Users often need to retrieve specific sales orders based on their current processing status through NetSuite web services. A common challenge arises when attempting to filter transactions by status, as incorrect enumeration types can lead to failed queries or incomplete results. Understanding the precise status values and their corresponding enumeration is essential for successful integration.
Solution
When searching for sales orders by status using NetSuite web services, it is necessary to use the correct enumeration for the orderStatus field.The appropriate status value, such as _salesOrderPendingFulfillment, should be specified.To identify all valid status options for sales orders, consult the NetSuite Schema Browser.
Navigate to the NetSuite Schema Browser.
Locate the SalesOrder object definition.
Examine the orderStatus field to find its associated enumeration, which is SalesOrderOrderStatus.
Within SalesOrderOrderStatus, identify the specific status value that corresponds to the desired transaction state, for example:
_salesOrderPendingFulfillmentThis value should be used in your web services request to filter sales orders by their pending fulfillment status.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support