Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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.