Scenario:
The user wants to generate a saved search that will return only Sales Orders containing exactly two specific items—Item A and Item B—and no other items. For example:
Include
Exclude
Even though SO #2 includes both Item A and B, it should be excluded because of the presence of an extra item (Item C).
Solution:
To filter Sales Orders with only Item A and Item B (and no others), you can use a Transaction Saved Search with formula filters. Below are the steps to configure the search:
- Criteria Subtab – Standard Filters
- Criteria Subtab – Summary Filters
This setup groups the results by Sales Order number and lists only the desired items per group.
Optional Tip
If you want to reuse this logic for different item combinations in the future, consider turning this into a template search and swap out the item IDs as needed.
-----
If you find this information useful, let us know by reacting or commenting on this post!