Monday, December 3, 2018

List Customers with No Invoices for the Period

1. Navigate to Reports> New Search

2. Click Customer

3. Click Create Saved Search button
4. On the Criteria tab> Standard sub tab
    >> * Filter | * Description
    >> Inactive | is set to No ** to show active customers only
    >> Transaction fields... select Type | is any of Invoice
    >> Date of Last Sale | is on or before select date range
5. On the Results tab> Columns sub tab> click Remove All button
    >> * Field | Summary Type
    >> Name | Group
    >> Transaction fields... select Type | Maximum
6. Rename Search Title
7. Click Save and Run

** Report will show Customer Name and Date of Last Sale.

 

No comments:

Post a Comment