NEED HELP USING THE SAME CRITERIA FILTER (End Date) MULTIPLE TIMES (with Parens) WITHIN THE SAME SAVED SEARCH, TO DETERMINE ACTIVE CUSTOMERS WHO USED TO BUY A SET OF PRODUCTS BUT NO LONGER BUY THOSE PRODUCTS NOW.
~~~~~
Can someone kindly help me figure out why my Saved Search isn’t returning any data, where I know the data exists?
I’m trying to determine which customers were billed on Sales Orders for a set of products in the past who aren’t currently buying that same set of products.
I’m needing Results from multiple different data tables (customers, contact, contract items, billed sales orders), but my preferred search would be Customer Search Criteria.
Here is my current Customer Search Criteria set that is returning zero data,
as well as one of my current Transaction Search Criteria set that is returning zero data.
I know that we have customers who have bought the products in the past that I'm selecting, who are currently not buying these same products, so I know the results exist, I just need wisdom from other to help me where I've gone astray.
Any help is greatly appreciated! :-)
WHAT I'M SEEKING:
CRITERIA to return Customers who:
[LIST]
[*]were billed Sales Orders that have Contract Items
[*]where the SO isn’t in current Status of Cancelled or Pending Approval
[*]for a certain set of products (simplified here by lumping all those products into a Class)
[*]with the End of the billed term in the past (End Date through yesterday),
[/LIST] AND
[LIST]
[*]this same set of products (same as above—simplified by Class)
[*]is not currently appearing on any Sales Orders/Contract Items
[*]in the present & future (transaction End Date from today forward).
[/LIST]