Thursday, March 14, 2019

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

 

 

No comments:

Post a Comment