Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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.