Generate and View AM Journals in GL

Purpose: Use this document as a reference for generating and view Asset Management journals in the General Ledger in ctcLink.

Audience: Financial Asset Manager/Staff

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

  • ZZ GL Journal Generation

You must also set these User Preference Definitions:

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

Before closing the month, ensure that all subsystems have sent journals to the GL. The process for generating journals is used to create and post to the GL from the various subledgers in ctcLink (Assets, Billing, Accounts Receivable, Payables, Purchasing, etc.). Doing so will keep the subledgers and GL in sync.

Generate AM Journals

Navigation: General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem

  1. The Generate Journals run control ID search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA010_SUBSYSTEM_JRNL (College, Process).
  3. The Generate Journals Request page displays. Use it to define options, such as journal processing options, process frequency, SetID, accounting definition name, application business unit, ledger group, and date options for processing. Select all of the following journal processing checkbox options:
    • Edit - performs the standard Journal Edit process.
    • Budget Check - performs budget checking.
    • Post - posts the journals that pass the Edit and Bugdet Checking processes (not recommended).
  4. In the Process Frequency box, select the Always radio button.
  5. Enter the SetID = WACTC. The default is WACTC and is never changed.
  6. Enter or select the Accounting Definition Name = AMDEFN for the Asset Management subsystem journals.
  7. Enter or select the appropriate Business Unit for the journal.
  8. Enter or select the Ledger Group =  ACTUALS. Leave blank to select all values.
  9. If a template is to be used, enter or select the appropriate template to use for the subsystem journal in the Template field. Leave blank to select all values.
  10. Select the From Date Option drop-down button to specify the date selection:
    • Begin Date - From Period:
    • Begin Date - To Period:
    • No From Date: to pick up all relevant transactions, up to and including the To Date, regardless of the accounting date. This ensures nothing gets left behind because of an old accounting date.
    • Process Date: to enter the appropriate date in the corresponding From Date field.  
    • Specify Date: to enter the appropriate date in the corresponding From Date field.
  11. Select the To Date Option drop-down button to specify the date selection:  
    • Current Date:
    • End Date - From Period:
    • End Date - To Period: to pick up all transactions with an accounting date equal to or less than the last day of the current open period.
    • Process Date: to enter the appropriate date in the corresponding From Date field.
    • Specify Date: to enter the appropriate date in the corresponding From Date field.
  12. Select the Run button.
Generate Jouranls Request page
  1. The Process Scheduler Request page displays. Select the FS_JGEN process checkbox and then select the OK button.
Process scheduler request page, select FS_JGEN check box
  1. The Process Scheduler Request page disappears. The updated Generate Journals Request page displays.  Note the Process Instance number. Select Process Monitor. Refer to the QRG Process Scheduling/Process Monitor for further instructions.
Review AM Journals

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

  • ZD General Ledger Inquiry
  • ZZ GL Local Configuration

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

Navigate: General Ledger > Review Financial Information > Review Journals

  1. Next, navigate to the Journal Inquiry page to verify that the journals were created. The Journals run control ID search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA020_JRNL (College, Process).
  3. The Journal Inquiry page displays. Use it to review summary and detail journal information for a specific business unit, ledger, and period. Enter or select the appropriate business unit in the Unit field.
  4. Enter or select the Ledger field = LOCAL.
  5. Enter or select the appropriate fiscal year in the Year field.
  6. Enter or select the appropriate from period in the From Period and To Period fields.
  7. In the Source field, enter AM for Asset Management.
  8. Select the Search button to populate the Journals grid results below.
  9. Select the Journal ID link to view the details of the journal entry you specified.

TIPS: Add additional search criteria to refine results: search by User ID, Journal ID, or Date. Max Rows defaults to 100. Optional to override to row number up to 99999. Select the column name to sort by ascending or descending or use the 'Sort By' drop down menu option.

Journal Inquiry page
  1. The Journal Inquiry Details page displays. Review Journal Header and Journal Line details. Select the Go To Journal Criteria link to return to the Journal Inquiry page search results.
Journal Inquiry Details
Post AM Journals

Post AM Journals by following the QRG Posting Journals and Running the Post Process.

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.

View Tutorial via Panopto

View the external link to Generate and View AM Journals in GL. 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.