General Ledger

1
General Ledger
GL Inquiry Pages
2
GL Inquiry Pages Overview

• Made in UMS WebFAST replacement
• Provides all the functionality of WebFAST and
  more!

• Set your own search criteria and save for future
  use
• Search for detail or summary values
• Print results in PDF format
• Download to Excel
• Access to data determined by security settings

3
Access

• Login to PeopleSoft Portal
• From Portal Menu select
• University of Maine gt Enterprise Applications gt
  Financials

• When you select Financials link, new browser
  window opens for PeopleSoft Financials
• From Financials menu select
• University of Maine gt
• General Ledger gt
• GL Inquiry

4
New GL Inquiry

• New GL Inquiry page opens with Find an Existing
  Value tab selected

5
New GL Inquiry

• First time you use GL Inquiry, need to enter GL
  Inquiry Search ID
• Select Add a New Value tab

6
New GL Inquiry

• Enter name for your search in GL Inquiry Search
  ID field
• Name may consist of up to 30 alpha/numeric
  characters and may include spaces
• Select

7
Enter Search Criteria

• Search Criteria page opens

Search name appears
8
Enter Fiscal Year Accounting Period

• Enter Fiscal Year

Look Up and select Accounting Period
9
Consider Your Search Criteria

• For each ChartField you include in your search
  criteria you can
• Enter a specific ChartField value, or
• Enter a node from a ChartField tree

• If you are including more than one ChartField in
  your search criteria, can enter a specific value
  for one and a tree node value for another

10
Search Criteria - Detail Value
Enter ChartField Value related to your search
Narrow results by entering first few digits of
ChartField code before conducting look up
11
Search Criteria - Detail Value
From Look Up page, select ChartField value or
Description to enter it on Search Criteria page
12
Search Criteria - Detail Search
ChartField value appears in ChartField box on
Search Criteria page
13
PeopleSoft Trees

• We use Trees to organize ChartField data, setup
  security, create summary reports and change
  organizational structure without changing entire
  system
• Trees provide easy to follow visual
  representation of ChartField hierarchy

14
Look Up Tree Node
To enter tree node in critera, click on Look up
Tree icon adjacent to ChartField
15
Look Up Tree Node

• Display and Select TreeNodes page opens
• In this example, top level nodes on the
  Department tree for each Business Unit appears
  under the AllDEPTS node

Click on Expand Node icon to left of relevant
node
16
Look Up Tree Node

• System tracks path to selected node
• Nodes along path are clickable links

Top level nodes on ChartField tree for the
Business Unit will appear
17
Look Up Tree Node
Can click on Expand Node icon to right of
Business Unit to view all Business Unit tree
nodes for ChartField
18
Look Up Tree Node

• Might result in a list several pages long
• Advance to next page by clicking on next arrow

19
Look Up Tree Node
To limit results, select Expand Node icon
adjacent to top level node related to your search

• Continue drilling down until you reach relevant
  node
• Click on node and choose
  on Display and Select TreeNodes page

20
Look Up Tree node
Node name appears in ChartField box on Search
Criteria page
21
Find Value Feature

• Can also use Find Value feature to locate and
  select tree nodes or specific value on a tree

From Display and Select TreeNodes page, select
22
Find Value Feature

• Enter or look up the tree node name or enter its
  description in the Find Tree Node section, or
• Enter all or part of the Department code or its
  description in the Find Detail Value section

• Select when ready

23
Find Value Feature

• Choose when ready

24
Save GL Inquiry Search Criteria
To use this search criteria in future, select
after all criteria is set
25
GL Inquiry Search
Select
26
GL Inquiry Search Results
One search result row will return for each
combination of values that match criteria
27
GL Inquiry Search Results
No value entered for a ChartField will return all
values for the ChartField related to the set
criteria, including blank
28
GL Inquiry Search Results

• In this example, many rows returned for the set
  criteria
• Each row represents a different combination of
  values resulting from the search

29
GL Inquiry Search Results
Select any link in a search result row to open
Summary Display page
30
Summary Display
Summary display of corresponding
Asset/Liabilities and/or Revenues/Expenses appear
in separate sections
31
Summary Display - Attributes
Select Attributes link to view corresponding FAST
account values, effective dates and status
32
Summary Display - Attributes
33
Refine Search
Select Refine Search button at any point to
return to Search Criteria page
34
Display Details
Select Display Details radio button to view
detail results
35
Display Detail
Displays Account numbers
Detail page shows subtotals for each summary
level and NET BALANCE
36
Download Results to Excel
Select Excel icon to download results in
adjacent section
37
Print Results
Can print page to PDF at any point
Click Print icon to start process to create
PDF
38
Print Results
Can print or save PDF file
39
View Journal Entry Details
Select underlined value to access Journal Details
page
40
Journal Details Page
Page lists lines from all journal entries
submitted for period
41
Journal Details Page

• Information entered on journal line displays in
  Journal Entries section

Click on Journal ID link to display Journal
Header and other Information  
42
Journal Header
Information entered on Header page of
corresponding journal entry appears here