Viewing Project Expenditure Details by Department

Overview

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.

1. Step 1

First, log into OneUSG Connect.

Click the drop-down button next to the Employee Self Service menu.

2. Step 2

Click the UGA Financials link.

3. Step 3

Click the Grants tile.

4. Step 4

In the Grants Center menu, click the Grants WorkCenter tab.

5. Step 5

The Grants WorkCenter page is displayed.

Click the Reports/Queries tab.

6. Step 6

In the Reports/Processes section to the left of the page, click the Query Viewer link.

7. Step 7

<< button selected to max query viewer page

Click the << button to maximize the Query Viewer page.

8. Step 8

On the Query Viewer page, enter "UGA_GM_OP_EXP_DETAIL_BYDEPT" in the begins with field.

9. Step 9

Click the Search button.

10. Step 10

The searched query is displayed. Click the HTML link.

11. Step 11

The searched query page is displayed. The top left corner contains search criteria you may use to search for specific awards.

12. Step 12

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.

13. Step 13

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.

Print Article

Updating...