This query lists fully processed detail level expenditures by award. The query name is UGA_GM_OP_EXP_AWD_DETAIL.
In this article, you will learn to run a detail expenditure query by award.
First, log into the Financial Management System.
Click the drop-down menu next to the Employee Self Service menu.
Click the UGA Financials link.
Click the Grants tile.
Click the Grants WorkCenter link.
Click the Reports/Queries tab.
Click the Query Viewer link.
Click the << button to close the Grants WorkCenter.
The Query Viewer page is displayed.
Enter appropriate query name into the begins with field.
Example shown here: " UGA_GM_OP_EXP_AWD_DETAIL ".
Click the Search button.
In the Search Results Query section, click the HTML link.
Click the Calendar button to change the From Acctg Date.
Example shown here: July 1, 2018 option.
Click Calendar button to change the To Acctg Date.
Example shown here: August 23, 2018.
Click the View Results button.
Click the Excel SpreadSheet link to view the results in Excel.
Click the Open button.
The Excel file is displayed. You can filter through the columns to view the information you need.