Ledger Inquiry

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

Audience: Finance Staff

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 it's own QRG (see Journal Inquiry).

Ledger Inquiry

Navigation:  General Ledger > Review Financial Information > Ledger

Once you navigate to the Ledger page:

  1. Select the Add a New Value tab.

Enter the name information into the Inquiry Name field. 

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

  1. Select the Add button.
Ledger Page

Use the Ledger Inquiry page to specify selection criteria to view ledger detail and summary information.

You can also use the ChartField Criteria grid to specify the ChartFields you want to view. Also use this grid to specify the order of the ChartFields to be viewed when the Sum By option is selected.

For example, if you select the Sum By option for the Account and the Department ChartFields, Account has Order-By equal to 1 and Department has Order-By equal to 2. You also can specify adjustment periods as part of your criteria by selecting the option next to Period in the Include Adjustment Periods grid.

In this example, we will use the following fields as criteria:

  1. Enter the desired information in the Unit field.
  2. Enter the desired information in the Ledger field.
  3. Enter the desired information in the Fiscal Year field. 
  4. Enter the desired information in the From Period field. 
  5. Enter the desired information in the To Period field.

If the number of data rows exceeds 100, increase the Max Ledger Rows value.  Note: this may affect performance.

  1. Select the Search button.

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.

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.

  1. Select the Activity link in any row to get the transaction details for that row.

The Transaction Details page 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.

  1. Select a Journal ID link.

The Journal Inquiry Details page displays the Journal Header information and Journal Lines for the journal transaction.

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.

  1. 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.

The next step will be to review the Transaction Details.  

  1. Select Transaction Details to open the Ledger Inquiry Transaction Details page.

The Transaction Details page summarizes the ledger journal data for your selection.  Once you are done reviewing the information,

  1. Select the Ledger Summary link.
  1.  Select the Ledger Detail Drill-Down ChartField Display which then opens a separate window to display the ChartFields that are pertinent to your inquiry.

This is the Ledger Detail Drill-Down ChartField Display page.  Select/Unselect ChartField Criteria to display.  Use the vertical scroll bar to scroll down to view all data.  

  1. Select OK once you have finished selecting your criteria.

 

Chartfield Criteria

You should now be back on the Ledger Summary page:  

  1. Select the Detail link.

Select the Activity link to return to the Transaction Details page.

From the Ledger Summary page:

  1. Select the Detail link.
  2. Select the Activity link to return to the Transaction Details page.
  3. Select the Journal ID link.

From the Journal Inquiry Details page you can select the Drill to Source to view details about the journal from the sub-system.

Close Journal Drill Down window.  You should now be back at the Journal Inquiry Details page.  

  1. Select the Ledger Summary link.
  2. Select the Inquiry Criteria link.

You have successfully viewed ledger detail transactions of a ledger.

End of Procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment