Discussions
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.