Viewing Project Expenditure Details by Project ID
Summary
In this article, you will learn the steps to run a project query for detail expenditures.
Body
Overview
This article will walk you through the steps to view fully processed detail level transactions by Project ID. The query name is UGA_GM_OP_EXP_DETAIL.
In this article, you will learn the steps to run a project query for detail expenditures.
 |
|
First, log into OneUSG Connect.
Click the drop-down menu next to the Employee Self Service menu.
|
|
 |
Click the UGA Financials link.
|
|
 |
Click the Grants WorkCenter link.
|
|
 |
The Grants WorkCenter page is displayed.
Click the Reports/Queries tab.
|
|
 |
In the Reports/Processes section, click the Query Viewer link.
|
|
 |
Click the Minimize Grants WorkCenter button to close the Grants WorkCenter.
|
|
 |
The Query Viewer page is displayed.
Enter appropriate information into the begins with field.
Example shown here: " UGA_GM_OP_EXP_DETAIL ".
|
|
 |
In the Search Results Query section, click the HTML link.
|
|
 |
The searched query page is displayed. The top left corner contains search criteria you may use to search for specific awards.
|
|
 |
Enter appropriate information into the From Acctg Date field.This field will restrict which awards are displayed, only showing awards from after the date you enter.
Example shown here: 07/02/2018 in the From Acctg Date field.
Note: The Accounting Period in Financials is based on the Fiscal Year, not the Calendar Year. Ex. 01 = July, 02= August, etc.
|
|
 |
Enter appropriate information into the To Acctg Date field.This field will restrict which awards are displayed, only showing awards from before the date you enter.
Example shown here: 08/23/2018 in the To Acctg Date field.
Note: The Accounting Period in Financials is based on the Fiscal Year, not the Calendar Year. Ex. 01 = July, 02= August, etc.
|
|
 |
Click the View Results button.
|
|
 |
The results matching your search criteria are displayed.
|
|
 |
Click the Excel SpreadSheet link to view the results in Excel.
|
|
 |
The Excel file is displayed. You can filter through the columns to view the information you need.
|
|
Details
Details
Article ID:
149729
Created
Sat 9/24/22 11:22 PM
Modified
Mon 4/14/25 2:19 PM