Hello Everyone:
I am attempting to create a report that tells me which customers have not purchased a group of about 10 items in the last 6 to 12 months, so that our Marketing group can target a campaign to these customers. I can create one that shows who has purchased these items through the Sales Invoice Line table, but am not sure how to obtain the opposite.
Any suggestions would be appreciated.
Thanks,
Antonio
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Antonio,
The solution I thought of would be:
- to create an array of all customer nos;
- to create an array of all customer nos who did buy these specific products;
- to report the difference between these 2 arrays.
To help you with this I created a small report based on Cronus. I hope it is self explanatory…
Please let us know if it works for you.
Please sign in to leave a comment.