This article will walk you through two queries to view foundation account budget balances and expenditures.
First, log into the Financial Management System.
Click the Employee Self Service object.
Click the UGA Financials link.
Click the Query Viewer tile.
The Query Viewer page is displayed. Enter appropriate information into the begins with field.
Note: You can enter the entire query name or can do a partial search.
Example shown here: " UGA_KK " in the begins with field.
The search result is displayed. Click the appropriate query link.
Example shown here: HTML link for the Query UGA__KK_DEPT_BUDGET_BALANCE.
The search parameters for the query are displayed. The Fiscal Year, Thru Period, and the Bud Ref fields auto populate. You can change the search criteria for any field.
Enter appropriate information into the Class field.
Example shown here: " 67072 " in the Class field.
Click the View Results button.
The requested result is displayed.
Click the Excel SpreadSheet link to open the data into an Excel file.
Click the Open button.
Click in the Enable Editing field.
The Excel file is displayed.
Click the Select All button to select the entire sheet.
Select and shrink the columns to view all the fields to the right.
You can filter through and analyze the data in any way you want.
Example shown here: " =sum( " in the field under the column 17
The selected cells are displayed.
The sum is displayed.
Close the Excel tab to switch back to the Query Viewer page.
Click in the begins with field.
Enter appropriate information into the begins with field.
Example shown here: "UGA_KK" in the begins with field.
Click the HTML link for the query UGA_KK_DEPT_EXP_REV_BALS.
The parameters for the specific query are displayed. You can edit/enter information into any of these search fields.
The requested results are displayed.
Click the Excel SpreadSheet link to open the data in an Excel spreadsheet.
The expenditure and revenue balances are displayed for the specific department.
You can filter through the data to view and analyze the information you need.