Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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.