Running the JV Entry - Pending Submission Query

   Overview   

Use the UGA_AP_JV_PENDING_SUBMIT to review the journal vouchers created, but not yet submitted, in your department or unit.

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

In this article you will learn how to run the UGA_AP_JV_PENDING_SUBMIT query to find the journal vouchers from your department that have been created but not submitted for approval.

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 is displayed.

The queries are found on the Reports/Queries tab.

Click the Reports/Queries tab.

4. Step 4

step image

Click the Entry - Pending Submission link.

5. Step 5

step image

The parameters for the UGA_AP_JV_PENDING_SUBMIT query are displayed.

Enter all or part of your department into the  Dept  field. If you use the entire Department ID, do not use the wildcard. Use the wild card if you are entering a partial department ID.

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

6. Step 6

step image

With your parameters entered, click the View Results button to run the query.

7. Step 7

step image

The results of the query are displayed.

Results include the name of the employee who is entered the journal voucher, the ID for the voucher, any related voucher, and attached invoice, the date of the invoice, supplier information, and the unit.   

8. Step 8

step image

Click on the hyperlinked voucher ID number to display the voucher details in view only mode.

Example shown here: 11223848 link.

9. Step 9

step image

A new page opens with the original transaction displayed in the summary tab. 

10. Step 10

step image

To review the approval history of the transaction, click the Approval History link.

11. Step 11

step image

The Approval History window is displayed. You can see where in the approval workflow this voucher has been and who has reviewed the voucher.

12. Step 12

step image

Scroll down the page to see where the voucher has been or will be routed.

13. Step 13

step image

When done reviewing the approval path, close the window.

Click the Close link.

14. Step 14

step image

Navigate to tabs at the top of the page to review further information regarding the selected voucher.

Example shown here: Related Documents tab.

15. Step 15

step image

The Related Documents tab displays information on vouchers that share the same invoice number as the selected voucher. This is to show the connection between the journal voucher and the original transaction it is adjusting.

16. Step 16

step image

To review the invoice details, click the Invoice Information tab.

17. Step 17

step image

The Invoice details are displayed in the Invoice Lines section. 

18. Step 18

step image

Use the scrollbar to review the full chartstring.

Note: The order of the ChartField values may vary depending on the set up of your preferences.

19. Step 19

step image

There are some useful links along the right side of the page. These are the same links that can be seen during the creation of the journal voucher.

Note: Visibility of some of the links may be restricted depending on your role within the system.

20. Step 20

step image

To review current default settings, click the Session Defaults link.

21. Step 21

step image

The Session Default window is displayed. From this page, you can review default settings such as Business Unit (almost never changed), supplier details, invoice defaults, and more.

When done reviewing the information, click the Return to Main Page object.

22. Step 22

step image

To review or add comments, click the Comments link.

Note: The number within the parenthesis displays the current number of comments.

23. Step 23

step image

The Voucher Comments window is displayed. The comments are displayed in the Comments field. This is also where you will enter your comments.

When done reviewing or adding comments, click the OK button to close the window.

24. Step 24

step image

When done reviewing or adding comments, click the OK button to close the window.

24. Step 24

step image

To review or add comments, click the Attachments link.

Note: The number within the parenthesis displays the current number of attachments.

25. Step 25

step image

The Voucher Header Attachment window is displayed.

To add an attachment, click the Add Attachment button.

26. Step 26

step image

The File Attachment window is displayed.

To locate a file on your computer, click the Browse button, then click the Upload button.

27. Step 27

step image

To return to the Invoice Information page, click the OK button.

28. Step 28

step image

To review and edit which ChartField values are displayed when viewing a journal voucher, click the Template List link.

29. Step 29

step image

The Voucher Entry Template List page is displayed. From this page, you can change which ChartField values are displayed and what fields are visible within the Invoice Lines.

Note: Review the other tabs to explore further options.

30. Step 30

step image

Use the scrollbar to review the full chartstring.

31. Step 31

step image

When done reviewing the template list, click the OK button.

32. Step 32

step image

To review payment preferences, click the Payments tab.

33. Step 33

step image

Payment details are displayed in the Payment Information and Payment Options sections.

34. Step 34

step image

Use the scrollbar to review additional information.

35. Step 35

step image

To review the attributes of the selected JV, click the Voucher Attributes tab.

36. Step 36

step image

Multiple attribute sections regarding the voucher are displayed.

37. Step 37

step image

Use the scrollbar to review additional information.

38. Step 38

step image

To review any errors with the selected voucher, click the Error Summary tab.

49. Step 49

step image

The error details are displayed. Review the errors and have the initiator correct the errors before submitting for approval.

In this example, you can see the selected voucher has no errors.

40. Step 40

step image

When you have finished your review, close the page.

Click the Close Tab button.

41. Step 41

step image

You can export the report to an Excel Spreadsheet.

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

42. Step 42

step image

The report is opened in an Excel spreadsheet. You can use all of the Excel features to work with the data.

43. Step 43

step image

Close the spreadsheet when you have finished your review.

Click the Close button.

44. Step 44

step image

Continue to review the report.

 

Details

Article ID: 151441
Created
Sun 9/25/22 10:07 AM
Modified
Wed 2/21/24 3:00 PM