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.

   Instructions   

  1. Step 1Click the drop-down menu next to the Employee Self Service menu.
  2. Step 2Click the UGA Financials link.
  3. Step 3Click the Grants tile.
  4. Step 4Click the Grants WorkCenter link.
  5. Step 5: The Grants WorkCenter page is displayed. Click the Reports/Queries tab.
  6. Step 6In the Reports/Processes section, click the Query Viewer link.
  7. Step 7Click the Minimize Grants WorkCenter button to close the Grants WorkCenter.
  8. Step 8: The Query Viewer page is displayed. Enter appropriate information into the begins with field.
  9. Step 9Click the Search button.
  10. Step 10In the Search Results Query section, click the HTML link.
  11. Step 11Click the Calendar button to change the From Acctg Date.
  12. Step 12Click the appropriate month from the drop-down menu.
  13. Step 13Click the appropriate From date.
  14. Step 14Click the Calendar button to change the To Acctg Date.
  15. Step 15Click the appropriate To date.
  16. Step 16Click the View Results button.
  17. Step 17Click the Excel SpreadSheet link to view the results in Excel.
  18. Step 18Click the Open button.
  19. Step 19The Excel file is displayed. You can filter through the columns to view the information you need.

In this article, you will learn the steps to run a project query for detail expenditures.

1. Step 1

step image

First, log into OneUSG Connect.                         

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

2. Step 2

step image

Click the UGA Financials link.

3. Step 3

step image

Click the Grants tile.

4. Step 4

step image

Click the Grants WorkCenter link.

5. Step 5

step image

The Grants WorkCenter page is displayed.

Click the Reports/Queries tab.

6. Step 6

step image

In the Reports/Processes section, click the Query Viewer link.

7. Step 7

step image

Click the Minimize Grants WorkCenter button to close the Grants WorkCenter.

8. Step 8

step image

The Query Viewer page is displayed.

Enter appropriate information into the begins with field.

Example shown here: " UGA_GM_OP_EXP_DETAIL ".

9. Step 9

step image

Click the Search button.

10. Step 10

step image

In the Search Results Query section, click the HTML link.

11. Step 11

step image

Click the Calendar button to change the From Acctg Date.

 

13. Step 12

step image

Click the appropriate month from the drop-down menu.

Example shown here: July.

14. Step 13

step image

Click the appropriate From date.

Example shown here: 2.

15. Step 14

step image

Click the Calendar button to change the To Acctg Date.

16. Step 15

step image

Click the appropriate To date.

Example shown here: 23.

17. Step 16

step image

Click the View Results button.

18. Step 17

step image

Click the Excel SpreadSheet link to view the results in Excel.

Note: Data has been masked to protect employee

19. Step 18

step image

Click the Open button.

20. Step 19

step image

The Excel file is displayed. You can filter through the columns to view the information you need.

Note: Data has been masked to protect employee information.

 

Details

Details

Article ID: 149729
Created
Sat 9/24/22 11:22 PM
Modified
Fri 1/5/24 5:10 PM