I'm trying to make a saved search for online orders that shows you the entire Sales order of items if any item in it is in the selected Department filter. What I'm doing currently is less than ideal -- I'm filtering the items by Department, then grouping them by Sales Order number. This does allow the user to see Sales Orders that contain items from their department, but I want them to see the entire transaction worth of items when they drill down, with the unfulfilled item from their department highlighted. I've been getting mixed messages by looking at old forum posts as to whether or not this can be done. Here's my current Transaction Saved Search:
Normal Criteria:
- Main Line: false
- Tax Line: false
- COGS Line: false
- Shipping Line: false
- Item : Department: mine
- Subsidiary: mine
- Type: Sales Order
Summary Criteria:
- Type: Maximum; Field: Unpicked Order Quantity; Value: Greater than 0
Results:
- Transaction Number (Summary Type: Group)
- Date (Summary Type: Maximum)
- Item : Display Name (Summary Type: None)
- Item : UPC Code (Summary Type: None)
- Quantity (Summary Type: Sum)
- Quantity Picked (Summary Type: Sum)
Filters:
- Item : Department
- Show in Filter Region: Yes
- Show as Multi-Select: Yes
- Subsidiary
- Show in Filter Region: Yes
- Show as Multi-Select: Yes
Other:
- Sort By: Date, Descending
I have had many situations in which this functionality would have been useful -- this is just a fun utility search that people can take or leave without consequence. I have a feeling the solution might involve using Summary criteria, but I'm not sure how I would go about this. I only just learned about Summary Criteria a few days ago. If there is some way to make this work, I'd love to hear about it! Thanks!