Running a Query to Review ChartFields on a Journal

Summary

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.

Body

   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

step image

First, log into the Financial Management System

Click the Employee Self Service drop-down menu.

2. Step 2

step image

Click the UGA Financials option.

3. Step 3

step image

The UGA Financials homepage is displayed.

Click the Query Viewer tile.

4. Step 4

step image

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

step image

Click the Search button.

6. Step 6

step image

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

7. Step 7

step image

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

step image

Click the View Results button.

9. Step 9

step image

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

Details

Details

Article ID: 148790
Created
Sat 9/24/22 10:54 PM
Modified
Fri 3/8/24 2:35 PM