Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Saved search for sales orders with items of different Location than order Location?
It's possible to create a sales order where one or more of the items in the order have a different Location than the Sales Order's Location. Such orders cause problems at fulfill or bill time.
I'm trying to create a saved search that returns the internal ids of sales orders where the order Location differs from at least one Item Location, order status Pending Fulfillment.
With a Transaction Search for Sales Order, setting Criteria Main Line = No, order status = Pending Fulfillment, and setting Results of sales order Internal id, sales order Location, and Item Display Name and Item Location, I get a list all sales orders Pending Fulfillment. But, in the Results some orders list an Item Location that differs from what's shown when Viewing that sales order.