9.2 Ledger Inquiry

Purpose:  Use a Ledger Inquiry page to view detail and summary ledger information in ctcLink.

Audience: Finance Staff.

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.

The ctcLink General Ledger application provides a series of inquiries that enable you to review ledger summary and detail information based on selected ChartField combinations.  These inquiries use several successive views that enable you to access journal line details.  The ledger inquiry also enables you to drill down across products from account balances in ctcLink General Ledger to specific transaction entries in other ctcLink Financial and Distribution products.

ctcLink General Ledger provides these inquiries:  journal inquiry, ledger inquiry, ledger group inquiry, ledger comparisons, analytic charts, imported accounting entries inquiries, and entry event budget and general ledger adjustment accounting inquiries.  After you run an inquiry, you can specify criteria to narrow your inquiry results.

In this topic, you use the Ledger Inquiry page to view detail and summary ledger information.  You also use the Journal Inquiry page to view journal details and this is covered in its own QRG (see Journal Inquiry).

Ledger Inquiry

Navigation: General Ledger > Review Financial Information > Review Ledger Information

The Ledger search page displays.

  1. Select the Add a New Value tab. Enter the name information into the Inquiry Name field. 
  2. Select Add.

Multiple Inquiries can be created and saved to quickly access frequently used inquiries.

  1. The Ledger Inquiry page displays.  Use it to specify selection criteria to view ledger detail and summary information.
  2. Use the ChartField Criteria grid to specify the ChartFields you want to view.  
  3. In this example, we will use the following fields as criteria:
    • Enter the desired information in the Unit field.
    • Enter the desired information in the Ledger field.
    • Enter the desired information in the Fiscal Year field. 
    • Enter the desired information in the From Period field. 
    • Enter the desired information in the To Period field.
  4. If the number of data rows exceeds 100, increase the Max Ledger Rows value.  Note: this may affect performance.
  5. Select the Search button.
Ledger Inquiry page
  1. The Ledger Summary page displays summary balances based on the selected ledger criteria.  The Ledger Amount by Currency grid summarizes, based on currency type, the transaction balances for each account in the ledger within the selected ledger period range.
  2. To make sure you are viewing all rows available, make sure to select the View All link located to the right to the Ledger Summary Header.  Scroll down using the vertical scroll bar to see additional Ledger Amount By Currency sections.
  3. Select the Activity link in any row to get the transaction details for that row.
Ledger Summary page
  1. The Transaction Details page displays.  It summarizes the ledger journal data for your selection.  For example, it displays a summary of all the ledger journal amounts for a specific account ChartField value.
  2. Select a Journal ID link.
Transaction Details page
  1. The Journal Inquiry Details page displays.  It contains the Journal Header information and Journal Lines for the journal transaction.
  2. Review the Journal Header information.  You can either view All Lines for the selected Journal ID, or to view a range of journals, select the From/To option, enter line numbers in the From Line field and the To Line field, and then select the Query Journal Lines button.
  3. Select the All Lines option and then choose the Query Journal Lines button to see all journal lines. The results will display below the Journal Header section.
  4. The next step will be to review the Transaction Details.  Select Transaction Details to open the Ledger Inquiry Transaction Details page.
Journal Inquiry Details page
  1. The Transaction Details page displays.  It summarizes the ledger journal data for your selection.  After you are done reviewing the information.
  2. Select the Ledger Summary link.
Transaction Details page
  1. The Ledger Summary page displays.  Select the Ledger Detail Drill-Down ChartField Display link which then opens a separate window to display the ChartFields that are pertinent to your inquiry.
Ledger Summary page
  1. The Ledger Detail Drill-Down ChartField Display page displays.  Select/Unselect ChartField Criteria to display.  Use the vertical scroll bar to scroll down to view all data.  
  2. Select OK after you have finished selecting your criteria.

 

Ledger Detail Drilldown CharField Display page
  1. The Ledger Summary page displays.  
  2. Select the Detail link.
Ledger Summary page
  1. The Ledger Details page displays.  Select the Activity link to return to the Transaction Details page.
Ledger Details page
  1. The Transaction Details page displays.  Select Ledger Summary.
Transaction Details page
  1. The Ledger Summary page displays.Select the Detail link.
  2. Select the Activity link to return to the Transaction Details page.
  3. Select the Journal ID link.
Ledger Summary page
Ledger Details page
Transaction Details page
  1. The Journal Inquiry Details page displays.  You can select the Drill to Source to view details about the journal from the sub-system in a new window.
Journal Inquiry Details page
  1. The Journal Drill Down window opens.
Journal DrillDown window
  1. Close Journal Drill Down window.  You should now be back at the Journal Inquiry Details page.  
  2. Select the Ledger Summary link.
  3. Select the Inquiry Criteria link.
Journal Inquiry Details page
  1. The Ledger Summary page displays.
Ledger Summary page
  1. You have successfully viewed ledger detail transactions of a ledger.
  2. Process complete.

0 Comments

Add your comment

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