General Ledger Report Console

Purpose: Use this document as a reference for running General Ledger delivered reports in ctcLink.

Audience: Financial Staff

 

The following table lists reports available in PeopleSoft General Ledger and vetted by the ctcLink Reporting & Analytics team (as of 2015-05-31). Please refer to the Reporting team's SharePoint site for up-to-date information.

High Needs General Ledger Reports

Report Name

Report ID

Description

Navigation    

Allocation Step Definition Rep

GLS6000

Lists detailed information for allocation steps.

Main Menu > Allocations > Reports > Allocation Step

Commitment Control Activity Log Report

GLX8570

Displays budget-checking activity.

Main Menu > Commitment Control > Budget Reports > Activity Log

Commitment Control Activity Log Summary Report

GLX8571

Displays budget-checking activity summarized by budget and ledger type.

Main Menu > Commitment Control > Budget Reports > Activity Log

Budget Checking Batch Process Statuses

GLX8530

Displays the budget checking status of source transactions that have been budget-checked.

Main Menu > Commitment Control > Budget Reports > Budget Checking Status

Budgetary Control Parameters

GLX8051

Displays the Ruleset ChartField, Control ChartField, and Commitment Control Option for each Ledger Group.

Main Menu > Commitment Control > Budget Reports > Budget Control Report

Budget Key Translations

GLX8050

Displays each key ChartField for each Ruleset in each Commitment Control ledger group, along with the ChartField's translation tree name and budgetary tree level.

Main Menu > Commitment Control > Budget Reports > Budget Key Translations Report

Budget Status Report

GLS8020

Displays all Commitment Control ledger amounts and the available budget balance.

Main Menu > Commitment Control > Budget Reports > Budget Status

Budget Transaction Detail Rep

GLS8005

Commitment Control Budget Transaction Detail Report

Main Menu > Commitment Control > Budget Reports > Budget Transaction Detail

Budget Actual Reconciliation

GLS8010

Commitment Control Budget Actual Reconciliation Report.

Main Menu > Commitment Control > Budget Reports > Budgets/Actuals Reconciliation

Ledger Details report

GLS8510

Displays such details as amounts for each ledger in the selected control budget, as well as the available amount for the budget.

Main Menu > Commitment Control > Budget Reports > Ledger Details

Project Expiration

GLX8043

Identifies expired projects and displays such information as project dates and managers.

Main Menu > Commitment Control > Budget Reports > Project Expiration

Closing Calculation Log Report

GLS1222

Commitment Control Budget Close Calculation Log Report.

Main Menu > Commitment Control > Close Budget > Closing Calculation Log Report

Closing Rules Report

GLS1200

Commitment Control Closing Rules Report.

Main Menu > Commitment Control > Close Budget > Closing Rules Report

Closing Status Report

GLS1220

Commitment Control Closing Status Report.

Main Menu > Commitment Control > Close Budget > Closing Status Report

Validate Closing Set

GLS1210

Validate Commitment Control Closing Set.

Main Menu > Commitment Control > Close Budget > Validate Closing Set

Budget Ledger Details

GLS8002

Displays budgets and their budget journals.

Main Menu > Commitment Control > Post Control Budget Journals > Budget Ledger Details Report

Closing Rules Report

GLS1002

The report lists detailed information about the closing set rules

Main Menu > General Ledger > Close Ledgers > Closing Rule Report

Closing Trial Balance Report

GLS1003

The report shows the ledger entry account type with its beginning balance and period total, along with any adjustments made to the beginning balance.

Main Menu > General Ledger > Close Ledgers > Closing Trial Balance

Journal Closing Status Report

GLS1004

Journal Closing Status Report.

Main Menu > General Ledger > Close Ledgers > Journal Closing Status Report

Consolidation Definition Report

GLS2002

Displays the options and controls that tell General Ledger how to process a consolidation.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Consolidation Set

Consolidation Out of Balance Report

GLS2003

Displays the elimination sets and ledger amounts that were processed for a consolidation request.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Elimination Out of Balance

Elimination Set Definition Report

GLS2000

Displays all elimination set definitions for financial consolidations.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Elimination Sets

Audit Elimination Sets

GLS2005

Displays the elimination sets and audit information, including account and business unit.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Elimination Sets Audit

Equalization Calculation Log

GLS2008

Lists equalization calculation details by process instance.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Equalization Calculation Log

Equalization Rule Definition

GLS2006

Displays the definition information and purpose for the equalization rule.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Equalization Rules

Fund Balance with Treasury Reconciliation

GLS9500

Fund Balance with Treasury Reconciliation Report.

Main Menu > General Ledger > Federal Reports > Fund Balance Reconciliation > Generate Reconciliation Report

InterUnit Activity Report

GLS3001

Displays reconciliation information.

Main Menu > General Ledger > General Reports > InterUnit Activity

Journal Entry Detail Report

FIN2001

Displays all journal entries that were entered in the system for a business unit and ledger within the date range specified.

Main Menu > General Ledger > General Reports > Journal Entry Detail

Journal Entry Detail Report with Attributes

FIN2005

This report is similar to the Journal Entry Detail Report, except that this report also lists the ChartField attribute values.

Main Menu > General Ledger > General Reports > Journal Entry with Attributes

Journal Line/Accounting Entry Reconciliation

GLS8012

Compares journal entry lines with accounting entries.

Main Menu > General Ledger > General Reports > Journal Line/Acctg Reconcil

General Ledger Activity Report

GLS7002

Lists the beginning and ending ledger balances by ChartField combination and account.

Main Menu > General Ledger > General Reports > Ledger Activity

Ledger Activity with Attribute

GLS7016

This is the report for the Panel STAT2_Trial Balance

Main Menu > General Ledger > General Reports > Ledger Activity with Attribute

General Ledger Summary

GLS7003

General Ledger Summary report

Main Menu > General Ledger > General Reports > Ledger Summary

Ledger vs Journal Integrity Report

GLS7010

Checks for any discrepancy between Ledger and Journal tables within a specified period range.

Main Menu > General Ledger > General Reports > Ledger vs Journal Integrity

Standard Journal Entry Status

GLS7001

Lists standard journal entries and their status.

Main Menu > General Ledger > General Reports > Standard Journals

Trial Balance Report

GLS7012

Combines detail and summary balance information.

Main Menu > General Ledger > General Reports > Trial Balance

Reconciliation by ChartFields

FIN5005

GL Subsystem Reconciliation by ChartFields

Main Menu > General Ledger > GL Subsystem Reconciliation > Reconciliation by ChartFields

Reconciliation by System Source

FIN5001

GL Subsystem Reconciliation by System Source

Main Menu > General Ledger > GL Subsystem Reconciliation > Reconciliation by System Srce

Journal Edit Error Report

GLS7011

Provides detailed information about journal edit errors.

Main Menu > General Ledger > Journals > Process Journals > Journal Edit Errors Report

Journal Posting Summary Report

GLS7009

Provides the ability to report on journals that were posted during a specific run of the Jo

Report    Name

Report ID

Description

Navigation

Budget Attributes

GLX8100

KK Budget Attributes Report.

Main Menu > Commitment Control > Budget Reports > Budget Attributes Report

Budgetary Control Tree Audit

GLS8007

Audits all budget key ChartField translation trees for completeness and accuracy and displays various error and warning messages.

Main Menu > Commitment Control > Budget Reports > Budgetary Control Tree Audit

Subsidiary Ownership Sets Report

GLS2007

Shows the ownership, set status, effective date, description, entity ChartField, subsidiary entity, parent, ownership percentage, and controlling equitize.

Main Menu > General Ledger > Consolidate Financial Data > Reports > Ownership Sets

Journal Entry Print

GLX7501

Journal Entry Detail report.

Main Menu > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

Journal Entry Print

GLX7502

Journal Entry Detail report Separate DR/CR.

Main Menu > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

Valid Ledger Codes

GLX1001

Displays information about valid ledger codes including associated book codes.

Main Menu > General Ledger > Ledgers > Ledger Codes Report

Ledger Template Report

FSX0023

Displays the records and fields included in detail ledger templates.

Main Menu > General Ledger > Ledgers > Template Report

CF Value Map for Reg Ledger

FIN5102

Regulatory Ledger ChartField Value Mapping report.

Main Menu > General Ledger > Regulatory Ledger Reports > ChartField Value Mapping

Ledger Translation Errors Report

FSX5101

Lists the errors from ledger translation.

Main Menu > General Ledger > Regulatory Ledger Reports > Ledger Errors

Valid Business Units Report

FIN0020

Displays a list of business units that are valid as of a specific date. For each business unit, prints a description of the unit, and the default as-of date.

Main Menu > Set Up Financials/Supply Chain > Business Unit Related > Reports > General Ledger Units

Ledgers for a Business Unit

FIN0021

Displays information about the ledgers that you have defined for a business unit. Shows information about each ledger, including type, ledger, definition, SetID, date of last update, and whether the ledger is balanced. Also shows open accounting periods, the adjustments year, and journal error handling options.

Main Menu > Set Up Financials/Supply Chain > Business Unit Related > Reports > Ledgers For A Unit

List of Tables by Record

FSX0016

Displays tables by the record group they belong to. Displays a description and table name for each record group ID.

Main Menu > Set Up Financials/Supply Chain > Business Unit Related > Reports > Record Groups

Table Set Controls Report

FIN0018

Displays the record groups associated with the TableSet you specify, including the field names and values you enter at the system prompt. Displays the trees designated for that TableSet.

Main Menu > Set Up Financials/Supply Chain > Business Unit Related > Reports > TableSet Controls

List of Valid Set IDs Rpt

FSX0017

Displays a short and long description of each SetID valid on a specific date.

Main Menu > Set Up Financials/Supply Chain > Business Unit Related > Reports > TableSet IDs

Detail Calendars Report

FSX0002

Displays information about detail calendars, including a description as well as a listing of the periods you have defined for the calendar.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > >Calendars/Schedules > Detail Calendar Report

Schedules Report

GLS4000

Prints a list of the schedules that you have defined for a SetID. The report includes a description of each schedule and the definition of its frequency.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Calendars/Schedules > Schedules Report

Summary Calendars Report

GLX4001

Displays information about summary calendars.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Calendars/Schedules > Summary Calendar Report

TimeSpans

FSX0003

Displays the TimeSpan definitions for a SetID, including a description and information about the start year, start period, end year, and end period. The report also shows whether the TimeSpan includes forward balances and closing adjustments.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Calendars/Schedules > TimeSpans Report

Journal Class Report

GLX4008

Displays the journal class name and a description.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Journals > Class Report

Journal Entry Template

GLX4007

Journal Entry Template Report.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Journals > Entry Template Report

Valid Journal Sources Report

FIN0008

Displays the journal class name and a description of each for a selected SetID.

Main Menu > Set Up Financials/Supply Chain > Common Definitions > Journals > Source Report


0 Comments

Add your comment

E-Mail me when someone replies to this comment