9.2 Specifying Journal Entry Search Criteria

Purpose:  Use this document as a reference to specify journal entry search criteria.

Audience:  Finance and Business Office Staff.

You must have at least one of these local college managed security roles:

  • ZZ GL Journal Entry

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Specify Journal Entry Search Criteria

Navigation:  General Ledger > Journals > Journal Entry > Create/Update Journal Entries

  1. Select the Find an Existing Value tab.
  2. Enter the desired information into the Business Unit field. Enter a valid value e.g. "WA220".
  3. Select the Journal ID field.    
  4. You know that your journal begins with "MK" but you do not remember the rest - Enter the desired information into the Journal ID field. Enter a valid value e.g. "MK".
  5. You also recall the date of the journal for which you are searching - Select the Journal Date field.
  6. The date of the journal was May 31, 2018 - Enter the desired information into the Journal Date field. Enter a valid value e.g.  "05152018".
  7. Select the Search button.
  8. Notice when you Select the Search button, the journal date converts to the proper date syntax. Select the journal MKDEC5 from the list.
  9. Select the MKDEC5 link.
find an existing value tab
search results
  1. Select the Lines tab.
  2. Use the Lines page to view the journal lines.
  3. Enter the number of lines that you would like to display at once in the Line field. This is also the number of lines that you will move forward or backward when you Select the double arrow button on either side of the Line field.
  4. Use the Next Group button (double down arrows) to scroll down the grid by the number of lines that you have specified in the Line field. Similarly, use the Previous Group button on the other side of the Line field to scroll up the grid by the number of lines in the Line field.
  5. Use the Last Row button and the First Row button (outermost single arrow on either side of the double arrows) to navigate to the last row and the first row, respectively, in the journal entry.
lines tab
  1. Use the Search Criteria link to access the Selection Criteria page where you enter specific line information that you would like to retrieve. This is most useful when navigating through voluminous journals - Select the Search Criteria menu.
search criteria
  1. Use the Selection Criteria page to enter specific field values that you would like to retrieve.
  2. Enter the selection criteria, including any wildcards.  These wildcards assist you in finding the exact information that you need.   Unless you enter one of the following wildcards, General Ledger assumes that you want an exact match:
    • % = Match one or more characters
    • * = Match one or more characters
    • _ = Match any single character
    • ? = Match any single character
    • ! = If first character, negate the user (not equal or not like)
    • ~ = Tilde—represents a blank character—this should not be used with any other characters or wildcard symbols.
    • \ = Escape character—do not treat the next character as a wildcard.
  1. For example, you could search for a blank in the Account, Operating Unit, Department, Program, Project, or Affiliate, fields by entering a tilde (~) in the field.
  2. When you enter search criteria, the Journal Line Number field is the starting line number for your search. For example, if you enter "35" here and 10 in the Line field on the Lines page, the system retrieves journal lines 30 through 39 - Enter the desired information into the Journal Line Number field. Enter a valid value e.g. "35".
  3. Select the OK button.
selection criteria wildcards
  1. After researching lines 35 and beyond, you would like to go back to the top of the journal - Select the First Row button.
  2. We can do a more specific search if we know what values we want to find - Select the Search Criteria menu.
  3. In this example, you want to search for the lines whose Account begins with "34" and whose Department value begins with "1" - Select in the Account field - Enter the desired information into the Account field. Enter a valid value e.g. "34%".
  4. Select in the Department field - Enter the desired information into the Department field. Enter a valid value e.g. "1%".
  5. Select the OK button - The system retrieves and displays the requested journal lines.  
specified criteria wildcard
  1. You can Select the Next Group scroll button to view the rest of the retrieved lines or you can enter a larger number in the Line field to view all retrieved lines - Select the Next Group button.
  2. End of procedure.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

VIDEO COMING SOON!

View Tutorial via Panopto

View the external link to Specifying Journal Entry Search Criteria. This link will open in a new tab/window.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.