Tuesday, June 4, 2019

Saved Search to show the number of days each invoice was open for each customer and then average it up per customer

1. Navigate to Lists > Search > Saved Searches > New.
2. Select Search Type = Transaction
3. On the Criteria tab > Standard subtab, add the following filters:
      **Type = is Invoice
      **Status = is Invoice: Paid In Full
      **Account Type = is Accounts Receivable
4. On the Results tab > add the following fields:
      **Name > Set Summary Type = Group
      **Days Open > Set Summary Type = Average > Function = Round
5. Rename the Search Title.

6. Click Save & Run.

No comments:

Post a Comment