Running a Query to Review ChartFields on a Journal

   Overview   

When you approve a General Ledger Journal, all of the ChartFields are not available on the approval page. Running the UGA_GL_JOURNAL_ENTRY query will show all of the ChartFields for a specific journal.

In this article, you will learn the steps to run a query in the UGA Financial Management System that will show the ChartFields used on each line of a journal.

1. Step 1

Financial Management homepage displayed with Employee Self Service link highlighted

First, log into the Financial Management System

Click the Employee Self Service drop-down menu.

2. Step 2

Financial Management homepage displayed with UGA Financials link highlighted

Click the UGA Financials option.

3. Step 3

Financial Management homepage displayed with Query Viewer tile highlighted

The UGA Financials homepage is displayed.

Click the Query Viewer tile.

4. Step 4

Query Viewer page displayed with Begins With field highlighted

The Query Viewer page is displayed. Enter the appropriate information in the  begins with field.

Example shown here: " UGA_GL_JOURNAL_ENTRY " in the begins with field.

5. Step 5

Query Viewer page displayed with Search button highlighted

Click the Search button.

6. Step 6

Query Viewer page displayed with HTML link highlighted

To run the query in your browser, click the HTML link.

7. Step 7

Selected query page displayed with Journal ID field highlighted

The selected query is opened in a new browser tab. Enter the appropriate information into the  Journal ID (can use partial %)  field.

  

Note: Partial Journal IDs can be entered when followed by % .  

Example shown here: " 1000125698 " into the Journal ID (can use partial %) field.

8. Step 8

Selected query page displayed with View Results button highlighted

Click the View Results button.

9. Step 9

Selected query page displayed with Results highlighted

All of the journal lines are displayed, and you can see the values entered in all ChartFields.
 
Print Article