ANS-0017 · SAVED SEARCHES & FORMULAS

Distinguish Drop Ship and Special Order POs in NetSuite Saved Searches

NetSuite users can identify the precise link type between a Sales Order and its generated Purchase Order using a dedicated search filter.

Short answer

To differentiate between Drop Ship and Special Order Purchase Orders originating from a Sales Order in NetSuite saved searches, utilize the `Applied To Link Type` field. This filter, accessible in the UI and via its internal ID `appliedtolinktype`, allows precise identification of the transaction link type, enabling accurate reporting and analysis.

Scenario

NetSuite users often need to distinguish between Purchase Orders (POs) that are created as Drop Ship orders and those created as Special Orders, especially when these POs originate from a Sales Order. This distinction is crucial for accurate reporting, inventory management, and fulfillment processes within the system.

Solution

To differentiate between Purchase Orders created as Drop Ship orders and those created as Special Orders from a Sales Order, a specific search filter and column can be utilized. In the NetSuite user interface, this field is named Applied To Link Type. For scripting or advanced searches, its internal ID is appliedtolinktype. This field provides values that clearly indicate the link type between transactions, allowing users to accurately categorize and report on their Purchase Orders.

Expert NetSuite Support

Need help with this NetSuite issue?

Saved Searches & Formulas consulting and configuration support

Talk to a consultant