Search to view Customers with no Sales Activity in the past 18 months
Navigate to Reports > Saved Search > All Saved Searches > New > Customer
1. Check mark Use Expressions = True
2. Criteria : Standard subtab :
a. Filter is Date of Last Sale .. is Before 18 months ago
b. Filter is Date of Last Sale .. is Empty ( this will show all customer's with no sales activity)
3. Results :
a. Date of Last Sale
You may add other fields as required.
4. Sort by Date of Last Sale ... Descending = True
5. Submit