Running the GL Workflow - Approvals in Process Query

Summary

In this article, you will learn the steps to run a query in the Business Management Workcenter to view GL approvals in process.

Body

   Overview   

Use the UGA_GL_JRNL_WORKFLOW_PENDING query to review the general ledger journals for your department or unit that have not completed the approval process. This will help you monitor the journals that need attention.

You can also access this query using Query Viewer, accessed from the tile on the UGA Financials homepage.

In this article, you will learn the steps to run a query in the Business Management Workcenter to view GL approvals in process.

1. Step 1

step image

First, log into the Financial Management System

Click the Classic Home tile.

2. Step 2

step image

To navigate to the Business Management Workcenter , select:

Main Menu > UGA > Business Management Workcenter

3. Step 3

step image

The Business Management Workcenter page is displayed.

Click the Reports/Queries tab.

4. Step 4

step image

In the GL Journals section, click the Workflow - Approvals in Process link.

5. Step 5

step image

Click the Minimize Business Management Workcenter button to close the menu to the left.

6. Step 6

step image

The parameters for the UGA_GL_JRNL_WORKFLOW_PENDING query are displayed.

The search uses Department ID. You can search using an entire ID number, or you can search for departments using a partial ID number by inserting a % sign as a wildcard. For example, 17% would return all departments starting with 17.

Leave only the % sign in the field if you want to view all departments.

Example shown here:  "17" in the Dept field.

7. Step 7

step image

Click the View Results button to run the query.

8. Step 8

step image

The Results of the query are displayed and list the GL journals that are still waiting for approvals.

Columns on the report show the name of the person that entered the report, the ID assigned to the report, the description of the journal, the date it was entered, the header status of the journal and the type of approval.

Note : Data has been masked to protect employee information. 

9. Step 9

step image

Hyperlinks in the query results can link to original documents or pages in view only mode to give more information.  

Click the 1000013181  link.

10. Step 10

step image

The Header page of the selected journal is displayed.

The Header page gives basic information about the journal such as the date it was entered, the description, and when and by whom the journal was entered.

To check on approval status, click the Approval tab.

11. Step 11

step image

The Approval Status section shows the status of the journal. 

12. Step 12

step image

The Journal Approval (Line) shows who has already approved the lines and who has yet to do so. 

13. Step 13

step image

Click the Multiple Approvers link to see the list of approvers in that pool.

14. Step 14

step image

Scroll through the list and click the Close button when your review is complete.

15. Step 15

step image

Close the journal when you have finished your review.

16. Step 16

step image

The Workflow Approval link for each line can give you the approval specifics for each line. on the journal.

Click the GLJournalApproval  link for the line you want to review.

17. Step 17

step image

New query results are displayed that shows the approval details.

The results show the journal ID, the Description is the person who entered. You can also see the date, the journal status and the step where it was approved. The Approver name for each step is displayed with the step status (the approval decision).

Close the Window when you complete your review.

18. Step 18

step image

You can download data into an Excel spreadsheet for further Analysis, if needed.

Click the Excel SpreadSheet link and follow the prompts to open as an Excel document.

19. Step 19

step image

Once the Excel spreadsheet opens, you can add filters to help you sort and view the information you need.

When you are finished, click the Close button.

 

Details

Details

Article ID: 149751
Created
Sat 9/24/22 11:23 PM
Modified
Mon 6/10/24 11:32 AM