Saved Search To Return All Lines in an Sales Order If Any Item Location=X?
I have a user that needs to see a list of sales orders with all line items where any line item on the SO is set to fulfill from one specific warehouse.
If the SO does not have that location on any line, then it should be excluded from the results.
It does. however need to return all the items and locations on the SO.
I’ve tried using a numeric formula where
CASE WHEN {item.location}=’X’ then 1 else 0 end
But all I get in the results are the lines set to fulfill out of Warehouse X and not all the other lines.
Any ideas?