Generic Inquiry to select customer who have made purchases between certain date ranges
I am trying to create an inquiry to select customers who have not previously had an invoice in the last 180 days and then made a purchase in the past 7 days. I have tried many different ways to do this but with no success. I can get those that have not purchased in the last 180 days and tried to add ARInvoice in a second time with an alias to get the last 7 days but cannot get the conditions to work properly. Any ideas or thoughts on how to do this?