Running the PR Approved - Waiting Payment Query

Summary

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.

Body

   Overview   

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.

1. Step 1

The UGA Financials page is displayed with the Classic Home tile highlighted.

First, log into the Financial Management System

From the Employee Self Service page, click the Classic Home tile.

2. Step 2

The Main Menu navigation page is displayed with the "Business Management Workcenter" option highlighted.

To navigate to the Business Management Workcenter, select:

Main Menu > UGA > Business Management Workcenter

3. Step 3

The Business Management Workcenter page is displayed with the Reports/Queries tab highlighted.

The Business Management Workcenter page is displayed.

Click the  Reports/Queries  tab.

4. Step 4

The Business Management Workcenter page is displayed with the Approved - Waiting Payment link highlighted.

In the Payment Requests section, click the  Approved - Waiting Payment  link.

5. Step 5

The Minimize Business Management Workcenter button is highlighted.

Click the  Minimize Business Management Workcenter  button to close the menu to the left.

6. Step 6

The Waiting Payment page is displayed with the View Results button highlighted.

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.

7. Step 7

The Waiting Payment page is displayed with the Excel SpreadSheet link highlighted.

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.

8. Step 8

The Open button in the file download prompt is highlighted.

Click the  Open  button.

9. Step 9

The Excel file is displayed.

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.

10. Step 10

The Payment Request Detail Data page is displayed with the search results table highlighted.

The payment request information is displayed, including the supplier name and payment scheduled date.

 

Details

Details

Article ID: 150352
Created
Sat 9/24/22 11:41 PM
Modified
Thu 10/1/26 5:39 PM