Saved Search to Calculate the Average Number of Days Bills are Paid per Vendor

In creating the Saved Search, here are the steps that you need to do:

-Navigate to Reports >Saved Searches >All Saved Searches >New

-Select Search Type = Transaction

-Navigate to Criteria tab >Standard subtab >Filter column and add the following fields:

a. Type = is Bill

b. Status = is Bill: Paid In Full

c. Account Type = is Accounts Payable

-Navigate to Results tab:

a. Sort By: Name

b. Then By: Date

c. Then By: Number

-Navigate to Results tab > Columns subtab > Field column and add the following fields:

a. Date

b. Type

c. Number

d. Name | Summary Type: Group

e. Amount

f. Status

g. Days Open | Summary Type: Average | Function: Round | Custom Label: Ave. Days Bills are Paid | Summary Label: Ave. Days Bills are Paid

-Click Save & Run button