This query shows fully processed detail level expenditures by department. The name of the query is UGA_GM_OP_EXP_BYDEPT.
In this article, you will learn the steps to run a query to view detail expenditures by project and department.
First, log into OneUSG Connect.
Click the drop-down button next to the Employee Self Service menu.
Click the UGA Financials link.
Click the Grants tile.
In the Grants Center menu, click the Grants WorkCenter link.
The Grants WorkCenter page is displayed.
Click the Reports/Queries tab.
In the Reports/Processes section to the left of the page, click the Query Viewer link.
Click the << button to maximize the Query Viewer page.
On the Query Viewer page, enter appropriate information into the begins with field.
Example shown here: " UGA_GM_OP_EXP_DETAIL_BYDEPT ".
Click the Search button.
The searched query is displayed. Click the HTML link.
In the Dept field you can enter the Department number. If you do not know the department number, the wildcard (%) will display all awards by Department.
Enter appropriate information into the Dept field.
Example shown here: " % ".
Click the calendar icon to enter a date into the From Acctg Date field.
Enter appropriate information into the From Acctg Period 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 July 2, 2018 link.
Click the calendar icon to select a date for the To Acctg Date field.
Click the August 23, 2018 link.
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.