Monday, March 4, 2019

Saved Search: Pull up a list of All Bill Payments settled through Online Bill Pay

Currently, the fields pertaining to Online Bill Pay are not available in standard reports or when you customize reports and Saved Searches.  This is relatively discussed under Enhancement 35832: Ability to provide a list of vendor records where Online Bill Pay is enabled

An alternate solution is to create a custom Transaction Saved Search and make reference of the initial status: Online Bill Pay Pending Accounting Approval set for all Bill Payments that are intended to be settled through Online Bill Pay.

Here are the steps:

-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 filters:

-Main Line = is false

-Formula (Numeric) | Formula: case when {systemnotes.field} = 'Document Status' and {systemnotes.oldvalue} is null and {systemnotes.newvalue} = 'Online Bill Pay Pending Accounting Approval' then 1 else 0 end | Formula (Numeric): greater than or equal to | Value: 1

-Account Type = is Accounts Payable

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

a. Date

b. Type

c. Number

d. Name

e. Amount

-Navigate to Available Filters tab>Filter column and add the field: Date then mark the box under the Show In Footer column next to the field added.

-Hit Save & Run button


It is still possible that some Bill Payments were not actually paid through Online Bill Pay as the status: Online Bill Pay Pending Accounting Approval only implies that the To Bill Pay field was enabled when the Bill Payment was recorded.

The Search may not accurately depict the expected data if the subsequent alterations were made to the Bill Payment transaction like unchecking the To Bill Pay field in the Bill Payment to change the mode of payment.

No comments:

Post a Comment