Running the PR Review - Payment Request Data Query

   Overview   

Use the UGA_AP_PR_DETAIL_LOOKUP query to locate and review payment request information, including supplier, pay schedule date, and request quantities and amounts.. 

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 review payment request information.

You can also run this query from Query Viewer.

1. Step 1

UGA Financials homepage 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

Financial Managment page displayed with the Business Management Workcenter link highlighted

To navigate to the Business Management Workcenter, select:

Main Menu > UGA > Business Management Workcenter

3. Step 3

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

The Business Management Workcenter page is displayed.

Click the Reports/Queries tab.

4. Step 4

Business Management Workcenter page displayed with the Review - Pymt Request Data link highlighted

In the Payment Requests section, click the  Review - Pymt Request Data link.

5. Step 5

UGA_AP_PR_DETAIL LOOKUP query results displayed with the Request ID field highlighted

The parameters for the UGA_AP_PR_DETAIL LOOKUP query are displayed. This search uses Request ID to locate information. 

Enter appropriate information into the Request ID field.  

Example shown here: " 0000000300 ".

6. Step 6

UGA_AP_PR_DETAIL LOOKUP query results displayed with the View Results button highlighted

Click the View Results button.

7. Step 7

UGA_AP_PR_DETAIL LOOKUP query results displayed with the Minimize Business Management Workcenter icon highlighted

Click the Minimize Business Management Workcenter icon to close the menu to see more of the query results.

Note : Data has been masked to protect employee information.

8. Step 8

UGA_AP_PR_DETAIL LOOKUP query results displayed with the Excel Spreadsheet link highlighted

The query results are displayed.  You can view the supplier, date scheduled for payment, total amount of the request, quantity, and line amounts.

You can also download the results as an Excel SpreadSheet if desired.
 
Print Article