Use the UGA_AP_PR_WAITING_PAYMENT query to view approved payment requests that are not yet paid out.
You can also access this query using Query Viewer, accessed from the tile on the UGA Financials homepage.
In this article, you will learn the steps to run a query in the Business Management Workcenter to view approved payment requests waiting to be paid.
This query can also be accessed using Query Viewer.
First, log into the Financial Management System
From the Employee Self Service page, click the Classic Home tile.
To navigate to the Business Management Workcenter, select:
Main Menu > UGA > Business Management Workcenter
The Business Management Workcenter page is displayed.
Click the Reports/Queries tab.
In the Payment Requests section, click the Approved - Waiting Payment link.
Click the Minimize Business Management Workcenter button to close the menu to the left.
The parameters for the UGA_AP_PR_WAITING_PAYMENT query are displayed.
This search uses Department ID. You can search using an entire ID number, or you can search for departments using a partial ID number by inserting a % sign as a wildcard. For example, 17% would return all departments starting with 17.
Leave only the % sign in the field if you want to view all departments.
For this example, leave only the % sign in the field to search for all departments, then click View Results to run the query.
The query results are displayed.
Click the Excel SpreadSheet link to download the data into an Excel file.
Note: Data has been masked to protect employee information.
Click the Open button.
The Excel File is displayed. You can add filters to sort and view the information you need.
You can also click the appropriate Request ID to open the specific payment request.
Example shown here: 0000011177 link.
The payment request information is displayed, including the supplier name and payment scheduled date.