You can run in query using Query Viewer in the UGA Financial Management System to view your project spending detail by chartstring. The name of the query is UGA_KK_PROJECT_TRANS_DETAIL.
In this article, you will learn the steps to run a query to view detail level project transactions with chartstrings.
This query runs from the Commitment Control (KK) ledger, so it shows anything that has passed budget check, even if the transactions have not fully posted or completed all workflow steps.
First, log into the Financial Management System.
On the UGA Financials page, click the Query Viewer tile.
The Query Viewer page is displayed.
Enter the query name " UGA_KK_PROJECT_TRANS_DETAIL " into the begins with field.
Click the Search button.
The query is displayed. Click the HTML link to open the results as a webpage.
The search criteria for the query is displayed. You can enter any available information you have to refine your search.
Enter appropriate information into the Dept field.
Note: 17% in the Department search field will display all the department IDs that begin with 17.
Example shown here: " 17 "
Click the View Results button.
Click the Excel SpreadSheet link to download the data into an Excel file.
When prompted, click the Open button.
The Excel file is displayed with the requested data, including project chartstrings.
You can filter and sort the columns to view the information that you need. Scroll the right to view additional data.
Additional columns are displayed, including expenditures for each chartstring.