Appendix: General Ledger Reports

This appendix provides a listing of Oracle's PeopleSoft Enterprise General Ledger reports and discusses how to manage ChartFields in reporting.

Note. For samples of these reports, see the Portable Document Format (PDF) files that are published on CD-ROM with your documentation.

See Also

Enterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler

Click to jump to parent topicGeneral Ledger Reports: A to Z

This table lists the General Ledger reports, sorted alphanumerically by report ID.

Report ID and Report Name

Description

Navigation

Run Control Page

FIN1001

Message Log Report

Prints message logs for a process instance ID and batch report type, similar to the online query that is available for each background program. Displays job ID, program name, date, time, sequence number, logged message, and explanation for each process instance ID. (SQR)

Background Processes, Print Process Report

RUN_FIN1001

FIN2001

Journal Entry Detail Report

Displays all journal entries that were entered in the system for a business unit and ledger within the date range specified. Prints the journal entries in ascending ID order within the ledger and shows the journal date, the source, whether a reversal entry was created, journal status, posted date (if any), and a description. For each line that is included in the journal entry, lists the line number of the entry, the account number, a description, the department, product, and project ChartField values, and debit and credit detail. Also prints statistical information where included in a journal entry. (SQR)

General Ledger, General Reports, Journal Entry Detail

RUN_FIN2001

FIN2005

Journal Entry Detail Report with Attributes

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

General Ledger, General Reports, Journal Entry with Attributes

RUN_FIN2005

FIN5001

Reconciliation by System Source

This report consists of detailed subsystem and General Ledger (GL) journal transactions that are aggregated to the business unit, subsystem source, ledger, account or alternate account, fiscal year, and accounting period level.

For example, it lists the data at the system source level, such as accounts payable (AP), and then lists all the activity for AP, including what was posted and not posted, for one or more selected ChartFields that appear in the data that you loaded. (SQR)

General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by System Srce

RUN_FIN5001 (RUN_GLRCN_RPTS)

FIN5005

Reconciliation by ChartField report.

Lists the data based on one or more selected ChartFields that appear in the data that you loaded. Each of the subsystem amounts that fall within the ChartField combination is listed on the report along with the total amounts for the ChartFields and the related ledgers. (SQR) Run control parameters allow you to select a ChartField value or a tree with the ChartField values to report. The run control parameters allow you to include vs. exclude system sources.

General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by ChartFields

RUN_FIN5005 (RUN_GLRCN_RPTS)

FIN5101

Ledger Translation Errors report.

Lists the errors from ledger translation.

General Ledger, Process Multi-currency, Reports, Ledger Translation Errors

RUN_FIN5101 (RUN_GLRCN_RPTS)

FSX5101

Ledger Translation Errors report (XMLP)

Lists the errors from ledger translation. (XMLP)

General Ledger, Process Multi-currency, Reports, Ledger Translation Errors

RUN_FIN5101 (RUN_GLRCN_RPTS)

FSX0007

SpeedTypes Report

Lists all valid SpeedTypes and corresponding information, including the ChartField values that are defined for each SpeedType (XMLP report).

Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, SpeedTypes

RUN_FIN0007

FSX0011

Valid Department Codes Report

Lists all valid Department values and related information (XMLP report).

Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Department

RUN_FIN0011

FSX0012

Valid Product Codes Report

Lists all valid Product values and related information (XMLP report).

Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Product, Product

RUN_FIN0012

FSX0013

Valid Project IDs Report

Lists all valid Project ID values and related information (XMLP report).

Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Project, Project ID

RUN_FIN0013

GLC1000

Summary Ledger Definition Report

Displays information about summary ledgers, including a description, the detail ledger that it summarizes, record names, and a listing of the ChartFields that are associated with the ledger. (Crystal) Transactions that have been journalized will be differentiated between those transactions that have not been journalized. Any ChartField changes that have been made between journalized transaction and the accounting line value will be reported. Information is provided on journals in suspense that originated in the system source.

General Ledger, Summary Ledgers, Summary Ledger Definition Rpt

RUN_GLC1000

GLX1000

Summary Ledger Definition Report (XMLP)

Displays information about summary ledgers, including a description, the detail ledger that it summarizes, record names, and a listing of the ChartFields that are associated with the ledger. (XMLP) Transactions that have been journalized will be differentiated between those transactions that have not been journalized. Any ChartField changes that have been made between journalized transaction and the accounting line value will be reported. Information is provided on journals in suspense that originated in the system source.

General Ledger, Summary Ledgers, Summary Ledger Definition Rpt

RUN_GLC1000

GLC1001

Valid Ledger Codes

Displays information about valid ledger codes including associated book codes. (Crystal)

General Ledger, Ledgers, Ledger Codes Report.

RUN_GLC1001

GLX1001

Valid Ledger Codes (XMLP)

Displays information about valid ledger codes including associated book codes. (XMLP)

General Ledger, Ledgers, Ledger Codes Report.

RUN_GLC1001

GLC4001

Summary Calendars

Displays information about summary calendars. Includes a description as well as a listing of the periods that you have defined for the calendar. (Crystal)

Setup Financials/Supply Chain, Common Definitions, Calendars/Schedules, Summary Calendar Report

RUN_GLC4001

GLX4001

Summary Calendars (XMLP)

Displays information about summary calendars. Includes a description as well as a listing of the periods that you have defined for the calendar. (XMLP)

Setup Financials/Supply Chain, Common Definitions, Calendars/Schedules, Summary Calendar Report

RUN_GLC4001

GLC4003

Combination Group

Displays information on ChartField combination edit groups for a selected setID. (Crystal)

Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Combination Group Report

RUN_GLC4003

GLX4003

Combination Group (XMLP)

Displays information on ChartField combination edit groups for a selected setID. (XMLP)

Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Combination Group Report

RUN_GLC4003

GLC4007

Journal Entry Template

Displays Journal Entry Templates by the security applied that is available to a user. (Crystal) If you have configured ChartFields, you might want to use the GLX4007 report to avoid manual changes to this Crystal report.

Setup Financials/Supply Chain, Common Definitions, Journals, Entry Template Report, Journal Entry Template Report, Run, Process Scheduler Request, and select Journal Entry Template.

RUN_GLC4007

GLX4007

Journal Entry Template (XMLP)

Displays Journal Entry Templates by the security applied that is available to a user. (XMLP). Use this report if you have configured ChartFields to avoid manual changes.

Setup Financials/Supply Chain, Common Definitions, Journals, Entry Template Report, Journal Entry Template Report, Run, Process Scheduler Request, and select Journal Entry Template.

RUN_GLC4007

GLC4008

Journal Class Report

Displays the journal class name and a description of each for a selected setID. (Crystal).

Set Up Financials/Supply Chain, Common Definitions, Journals, Class Report

RUN_GLC4008

GLX4008

Journal Class Report (XMLP)

Displays the journal class name and a description of each for a selected setID. (XMLP).

Set Up Financials/Supply Chain, Common Definitions, Journals, Class Report

RUN_GLC4008

GLC5501

ADB Calculation Report

Lists ADB calculation details, including averaged period, date, and time. (Crystal)

General Ledger, Average Daily Balance, ADB Calculation Report

RUN_GLC5501

GLX5501

ADB Calculation Report (XMLP)

Lists ADB calculation details, including averaged period, date, and time. (XMLP)

General Ledger, Average Daily Balance, ADB Calculation Report

RUN_GLC5501

GLC6001

Allocation Group

Lists detail information that is associated with a particular allocation group. (Crystal)

Allocations, Reports, Allocation Group

RUN_GLC6001

GLX6001

Allocation Group (XMLP)

Lists detail information that is associated with a particular allocation group. (XMLP)

Allocations, Reports, Allocation Group

RUN_GLC6001

GLC7501

Journal Entry Detail (Crystal )

Shows journal entry detail information by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (Crystal)

If you have configured ChartFields, you might want to use the GLX7501 report to avoid making manual changes to this Crystal report.

General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Journal Entry Lines Page

Select the Print Journal (Crystal) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLC7501 report.

Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLC7501 report.

RUN_GLC7501

GLX7501

Journal Entry Detail (XML format)

Crystal reports require manual changes when there are ChartField configurations. XML Publisher reports do not require manual changes to support ChartField configuration and use the same criteria as the Crystal reports.

Shows journal entry detail information by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (XML Publisher)

General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Journal Entry Lines Page

Select the Print Journal (XMLP) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLX7501 report.

Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLX7501 report.

RUN_GLC7501

GLC7502

Journal Entry Detail (separate debit and credit) (Crystal format)

Shows journal entry detail information for separate debit credit by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (Crystal)

If you have configured ChartFields, you might want to use the GLX7502 report to avoid manual changes to this Crystal report.

Note. You must have configured you system for separate debit credit to use this report.

General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Journal Entry Lines Page

Select the Print Journal (Crystal) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLC7502 report.

Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLC7502 report.

RUN_GLC7502

GLX7502

Journal Entry Detail (separate debit and credit) (XML )

Crystal reports require manual changes when there are ChartField configurations. XML Publisher reports do not require manual changes to support ChartField configuration and use the same criteria as the Crystal reports.

Shows journal entry detail information for separate debit credit by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (XML Publisher)

Note. You must have configured you system for separate debit credit to use this report.

General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Journal Entry Lines Page

Select the Print Journal (XMLP) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLX7502 report.

Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLX7502 report.

RUN_GLC7502

GLS1001

Summary Ledger Detail

This is a template for designing reports based on user-specific ledger definitions. This is based on the summary ledger (PS_S_LEDGER_SUM), which you can find in the DEMO database. The record definition set consists of the following ChartFields: ACCT, OPERATING_UNIT, DIVISION, PRODUCT_AREA, and PROJ. Contains one statistics code field named STATS. (SQR)

General Ledger, Summary Ledgers, Summary Ledger Detail Report

RUN_GLS1001

GLS1002

Closing Rules

Displays information about closing set rules. It prints a description of the close set, identifies the name of the account ChartField, and shows the ChartField to which that profit and loss account will be closed. Also shows the option for retaining earnings in the ChartField. (SQR)

General Ledger, Close Ledgers, Closing Rule Report

RUN_GLS1002

GLS1003

Closing Trial Balance

Summarizes all entries on the ledger by account type. Prints beginning and ending balances for the year, totals for the period, adjustments, and closing entries. (SQR)

General Ledger, Close Ledgers, Closing Trial Balance

RUN_GLS1003

GLS1004

Journal Closing Status

Displays the journal line details for journal lines with various closing statuses. (SQR)

General Ledger, Close Ledgers, Journal Closing Status Report

RUN_GLS1004

GLS1005

Translate Ledger Reconciliation

Reconciles the amounts in the currency translation ledger to the amounts in the primary ledger within a Multibook ledger group. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Ledger Reconcile

RUN_GLS1005

GLS1006

Ledger In-Sync

This report searches the currency translation ledger within a multibook ledger to determine whether any data (for a particular year) is violating the required ledger structure. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Ledger In-Sync

RUN_GLS1006

GLS2000

Elimination Set Definition

Displays all elimination set definitions for financial consolidations. Lists accounts to which differences will post if the set doesn't eliminate and shows the ChartFields (such as ACCOUNT and BUSINESS_UNIT) and the ChartField values that make up the elimination set, as well as a description of those values. (SQR)

General Ledger, Consolidate Financial Data, Reports, Elimination Sets

RUN_GLS2000

GLS2001

Minority Interest Set Definition

Displays the minority interest set definitions for financial consolidations. Lists for each minority interest set a description, tree structure ID, the subsidiary entity, and percent of ownership. Also lists the accounts to which differences will post if the set doesn't eliminate, as well as the ChartField, manner specified, tree name/level, and the values that make up the parent/subsidiary accounts. (SQR)

General Ledger, Consolidate Financial Data, Reports, Minority Interest Sets

RUN_GLS2001

GLS2002

Consolidation Set Report

Displays the options and controls that tell General Ledger how to process a consolidation. Lists the journal ID mask, source, and relative elimination reversal date for elimination journals, the ChartFields included in the elimination journals, whether all elimination sets that are defined for the consolidation tree will apply, which elimination sets will be used, whether all minority interest sets apply, and which minority interest sets will be used. (SQR)

General Ledger, Consolidate Financial Data, Reports, Consolidation Set

RUN_GLS2002

GLS2003

Consolidation Out of Balance Report

Displays the elimination sets and ledger amounts that were processed for a consolidation request. The elimination sets are totaled and any out-of-balance amount is displayed. The out-of-balance amounts are also summarized at the node and tree levels. (SQR)

General Ledger, Consolidate Financial Data, Reports, Elimination Out of Balance

RUN_GLS2003

GLS2004

Minority Interest Eliminations and Adjustments

Displays the results of minority interest calculations for a consolidation request based on the combination of business units that are present in the consolidation tree. The elimination and adjustment entries are grouped by minority interest set. (SQR)

General Ledger, Consolidate Financial Data, Reports, Minority Int Elim/Adjustment

RUN_GLS2004

GLS2005

Audit Elimination Sets

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

General Ledger, Consolidate Financial Data, Reports, Elimination Sets Audit

RUN_GLS2005

GLS2006

Equitization Rules

Displays the definition information and purpose for the equitization rule, including component, ChartField, value, and description. (SQR)

General Ledger, Consolidate Financial Data, Reports, Equitization Rules

RUN_GLS2006

GLS2007

Subsidiary Ownership Sets Report

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

General Ledger, Consolidate Financial Data, Reports, Ownership Sets

RUN_GLS2007

GLS2008

Equitization Calculation Log

Lists equitization calculation details by process instance. (SQR)

General Ledger, Consolidate Financial Data, Reports, Equitization Calculation Log

RUN_GLS2008

GLS3000

Open Item Listing

Lists open Items for the accounts specified, including a description of the accounts, the OpenItem key field, and a detailed listing of the journal lines that have an open status up to the as of date. The journal lines are subtotaled by key field value. Journal lines containing OpenItem accounts are matched together based on the OpenItem edit field. (SQR)

General Ledger, Open Items, Open Item Listing Report

RUN_GLS3000

GLS3001

InterUnit Activity

Displays reconciliation information by business unit, ChartField, primary and balancing values, and variance. (SQR)

General Ledger, General Reports, InterUnit Activity

RUN_GLS3001

GLS4000

Schedules

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. (SQR)

Setup Financials/Supply Chain, Common Definitions, Calendars/Schedules, Schedules Report

RUN_GLS4000

GLS4002

Combination Rule

Displays information on a selected ChartField combination edit rule. (SQR)

Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Combination Rule Report

RUN_GLS4002

GLS5000

Translation Definition

Displays the details and rules of each currency translation step. For each translation step, the report shows the description, ledger information, output and journal options, and gain and loss ChartFields. In addition, detailed information is displayed for every translation rule that is used by the translation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Step

RUN_GLS5000

GLS5001

Revaluation Definition

Displays the details of each currency revaluation step, including revaluation step description, ledger and TimeSpan information, exchange rate type, output and journal options, gain and loss ChartFields, and detailed revaluation ChartField information. (SQR)

General Ledger, Process Multi-Currency, Reports, Revaluation Step

RUN_GLS5001

GLS5002

Translation Calculation Log

Lists translation calculation details by process instance and translation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Calculation Log

RUN_GLS5002

GLS5003

Revaluation Calculation Log

Lists revaluation calculation details by process instance and revaluation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Revaluation Calculation Log

RUN_GLS5003

GLS5004

Translate in Ledger Calculation Log

Lists translation within ledger calculation details by process instance and translate within ledger step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation in Ledger Calc Log (translation in ledger calculation log)

RUN_GLS5004

GLS5005

Translate in Ledger Report

Displays the details and rules of each translation step within the ledger calculation log. For each step, the report shows the description, ledger information, output and journal options, and gain and loss ChartFields. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation in Ledger, Translate in Ledger Report

RUN_GLS5005

GLS5500

ADB Definition report (average daily balance definition)

Prints ADB details, including description, purpose, and ChartField information. (SQR)

General Ledger, Average Daily Balance, ADB Definition Report

RUN_GLS5500

GLS6000

Allocation Step Report

Lists detailed information for allocation steps. (SQR)

Allocations, Reports, Allocation Step

RUN_GLS6000

GLS6002

Allocation Calculation Log

Lists the allocation calculations that were performed for a given process step within a specified process instance. Displays the pool, basis, and target amounts. (SQR)

Allocations, Reports, Allocation Calculation Logs

RUN_GLS6002

GLS6003

Budget Copy Calculation Log

Lists the Budget Copy Process calculations that were performed for a given process step within a specified process instance. For each process step, the report shows the sequence, business unit, account, department, product, project status, year, period, pool amount, basis amount, basis total, target amount, and offset amount. (SQR)

General Ledger, Maintain Standard Budgets, Budget Copy Calculation Log

RUN_GLS6003

GLS7001

Standard Journals report

Lists standard journal entries and their status. (SQR)

General Ledger, General Reports, Standard Journals

RUN_GLS7001

GLS7002

Ledger Activity report

Lists the beginning and ending ledger balances by ChartField combination and account. Also lists the detailed journal line activity that is posted against the ledger for the accounting periods that are specified. (SQR)

General Ledger, General Reports, Ledger Activity

RUN_GLS7002

GLS7003

Ledger Summary Report

Summarizes journal totals within a ledger by ChartField.

General Ledger, General Reports, Ledger Summary

RUN_GLS7003

GLS7009

Posted Journal Summary

Provides the ability to report on journals that were posted during a specific run of the Journal Post process. The Journal Post process updates all journals that were posted with the value of the Process Instance. The Process Instance is part of the search criteria that is used by the Posted Journals - Summary report. (SQR)

General Ledger, Journals, Process Journals, Posted Journal Summary Report

RUN_GLS7009

GLS7010

Ledger vs Journal Integrity

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

General Ledger, General Reports, Ledger vs Journal Integrity

RUN_GLS7010

GLS7011

Journal Edit Errors

Provides detailed information about journal edit errors: period, journal ID, date, source, reference number, error type, line, line description, field name, and error message. (SQR)

General Ledger, Journals, Process Journals, Journal Edit Errors Report

RUN_GLS7011

GLS7012

Trial Balance

Combines detail and summary balance information. Shows the ending ledger balances for the specified year and period by ChartField combination. Also displays subtotals by ChartField. Prints a final total for debits and credits. (SQR)

General Ledger, General Reports, Trial Balance

RUN_GLS7012

GLS7015

Journal Suspense Activity

Provides detailed information about suspended journals. (SQR)

General Ledger, Journals, Suspense Correction, Suspended Activity Report

RUN_GLS7015

GLS7016

Ledger Activity with Attributes Report

Lists the journal activity and the associated attributes for one or more specific ChartFields in a ledger for one or more periods, including beginning and ending balances. (SQR)

General Ledger, General Reports, Ledger Activity with Attributes

RUN_GLS7016

GLS7017

General Ledger Activity with Fund and Account Attributes

Generates a FACTS II report for a specific business unit, ledger, fiscal year, period range, adjustment period information, and FACTS tree group. The Program Reporting Category (PRC column heading) can display values for Category A and Category B apportioned funds. You can also indicate that the numeric field can be 23 integers and 3 decimal places long. (SQR)

General Ledger, Federal Reports, FACTS II Reports, Ledger with Attributes Report

RUN_GLS7017

GLS7500

Ledger File Creation

Reads all entries on the ledger and gives the ending balance for the year and period by account. Output is routed to an ASCII file in the specified format. (SQR)

General Ledger, Ledgers, Export Ledger Data

RUN_GLS7500

GLS8012

Journal Line/Accounting Entry Reconciliation

Compares journal entry lines with accounting entries. (SQR)

General Ledger, General Reports, Journal Line/Acctg Reconcil (journal line/accounting reconciliation)

RUN_GLS8012

GLS8303

FACTS II Accounting Edit Validation

Includes validation edits for account attributes, also includes footnote check to Edit10 when balance is negative, and Edit 8 validation. Shows Program Reporting Category (PRCs) for Category A and B.

General Ledger, Federal Reports, FACTS II Review, Validate FACTS II Data

RUN_GLS8303

GLS8310

FACTS I Validation report

This report is generated when you run the FACTS I Validation process. It describes any outstanding issues for each FACTS I edit that is run for your FACTS I accumulated data. (SQR)

General Ledger, Federal Reports, FACTS I, Generate FACTS I

RUN_CNTL_FACTSI

GLS8311

FACTS I Trial Balance report

This report displays the status of the General Ledger account balances along with the corresponding USSGL account attributes based on each Treasury Symbol. (SQR)

General Ledger, Federal Reports, FACTS I, Generate FACTS I

RUN_CNTL_FACTSI

GLS8312

FACTS II Trial Balance

This report displays the status of the General Ledger account balances along with the corresponding USSGL account attributes based on each Treasury Symbol. (SQR)

General Ledger, Federal Reports, FACTS II, FACTS II Reports, FACTS II Trial Balance

F2_RUN_GLS8312

GLS8400

SF224 Transaction Detail Report

This is a monthly report that includes the detail transactions that make up the totals on the SF224 - Statement of Cash Transactions report.

The detail report supports both regular SF224 and partial SF224 reporting.

General Ledger, Federal Reports, SF 224/ 1219/1220, SF 224 Transaction Report

RUN_GLS8400

GLS8410

SF224 Business Activity Exception Report

Displays transactions that should not be recorded for a particular ALC based on the Business Activity Type code for that ALC. For example, if the ALC is classified with a GWA Business Activity of IPAC Only, then the report reflects any transactions erroneously recorded for CA$HLINK and TDO Payments.

The report reflects data from Accounts Receivable and Accounts Payable. General Ledger journal entry activity is not included in the report.

General Ledger, Federal Reports, SF224/1219/1220, SF224 Bus Activity Exceptions

RUN_GLS8410

GLS8411

ALC GWA Reporting Options Report

Displays Agency Location Codes by setID and prints the ALC, agency Name, Business Activity Type, and all related GWA Reporter Category Codes by descending effective date and status.

General Ledger, Federal Reports, SF224/1219/1220, ALC GWA Reporting Options

RUN_GLS8411

GLS8500

Federal Trial Balance report

This is a summary trial balance report. This report displays a beginning balance, the total amount of debits and credits, and an ending balance. The data is generated for the specified ChartField combination for the fiscal year, accounting periods, and adjustment periods. This report also displays subtotals by ChartField and grand totals by TAS/TAFS levels. Displays the fiscal year grand total. (SQR)

General Ledger, Federal Reports, Federal Trial Balance

RUN_GLS8500

GLS8501

Federal Transaction Register

This is an online report that displays values at the fund, department, and TAS/TAFS levels for each accounting period along with each ChartField's attributes and attribute values. Displays the Program Reporting Category serving Category A and Category B and also accumulates and displays subtotals by ChartField and grand total. (SQR)

General Ledger, Federal Reports, Federal Transaction Register

RUN_GLS8501

GLS9500

Fund Balance Reconciliation

This report is run after you run the Fund Balance Reconciliation process, which compares account activity and trial balance data that is imported from the U.S. Treasury to a federal agency's cash activity. It contains any differences between a federal agency's and the U.S. Treasury's data. (SQR)

General Ledger, Federal Reports, Fund Balance Reconciliation, Generate Reconciliation Report

RUN_FBRECON_RPT

GLSF224P

Statement of Cash Transactions

SF224 is a monthly report to the U.S. Treasury that identifies the dollar amounts of confirmed disbursements and collections by Treasury Symbol, Agency Location Code, and fiscal month. This report is used by the U.S. Treasury to ensure that the agency agrees with the internal U.S. agencies that perform disbursements through the U.S. Treasury. This option enables you to create a flat file of the report to submit electronically through GOALS, and to print a hard copy of the report.

SF224 functionality supports both regular and partial reporting.

General Ledger, Federal Reports, SF224 / 1219/ 1220, Run SF224 Report/Create File

RUN_SF224_SF1220

GLSF1219

Statement of Accountability

This report is used to determine the accountability of disbursing officers for funds that are held outside the Department of Treasury (cash on hand) by U.S. Treasury Regional Finance Centers (RFCs) and other nonmilitary agencies that do not do their own disbursing. This option prints a hard copy version of this report. This report is very similar to the SF1220 report. These two reports are treated as one report when submitted electronically and processed by GOALS using the SF1219/1220 Create option to create the file.

General Ledger, Federal Reports, SF224/ 1219/ 1220, Run SF1219 Report

RUN_SF1219

GLSF224P

Statement of Transactions According to Appropriations, Funds, and Receipt Accounts report

Provides the U.S. Treasury with a monthly statement of payments and collections that are performed by agencies that do their own disbursing. This option prints a hard-copy version of this report. This report is very similar to the SF1219 report. These two reports are treated as one report when submitted electronically and processed by GOALS using the SF1219/1220 Create option to create the file.

General Ledger, Federal Reports, SF224/ 1219/ 1220, Run SF1220 Report

RUN_SF224_SF1220

See Also

PeopleSoft Commitment Control Reports

Application Fundamentals Reports

PeopleSoft Financials Global Reports

Click to jump to parent topicManaging ChartFields in Reporting

The following discusses how to:

Click to jump to top of pageClick to jump to parent topicUsing XML Reporting to Support ChartField Configuration

Oracle XML Publisher (XMLP) technology is accessible from PeopleTools PS Query and all PeopleTools applications. This technology enables PeopleSoft Enterprise to deliver XML Publisher reports to supplement the existing General Ledger Crystal reports, which require manual changes if you implement ChartField configuration. The XML Publisher reports do not require manual changes to support ChartField configuration and use the same criteria as the Crystal reports.

The following is a list of General Ledger reports that can be generated with Crystal and XML Publisher:

See Using XMLP Reports to Support Configured ChartFields.

Click to jump to top of pageClick to jump to parent topicSelecting ChartFields for SQR Reports

The ChartField Selection grid is used by many report request pages and enables you to select the ChartFields you want to view for SQR based reports that print ChartField values.

To enter report selection criteria in the ChartField Selection Grid:

  1. Enter the header selection criteria and click Refresh to populate the grid with rows for each ChartField.

  2. Click Include CF for the ChartFields that you want to include values for in the report.

    PeopleSoft delivers reports with a fixed number of lines on the report heading. This number is determined based on the most common business practice. There is just enough space for a few ChartFields on the heading and still retain enough space for detail lines on each page. If you elect to include more ChartFields, the report will not have enough space to print all ChartField headings. This results in report heading and detail lines that overlay each other. If your circumstances require you to print more than the optimum number of ChartField values, change the report to increase the report heading lines. Increasing the number of ChartFields is a customization and is not supported by PeopleSoft.

  3. (Optional) Use the Value field to enter ChartField values for the budgets on which you want to report.

    Leave blank to select all values for the ChartField. Some Commitment Control report request pages include Value From and Value To fields to enable you to select ranges of ChartField values.

  4. (Optional) Change the Sequence in which the ChartFields appears on the report.

    For example, if you are reporting by Account and Department and you select Account to be first in the sequence, the report displays budget rows as follows:

    Account

    Department

    60000

    100

     

    110

     

    120

    62000

    100

     

    110

     

    130

    The default sequence is alphabetical.

  5. (Optional) Select Descr to include a description of the ChartField value.

  6. (Optional) Select Subtotal to include a subtotal of all amounts for the ChartField.

    For example, if you are reporting by Account and Department as in the above example, and you select Subtotal for Account, the report displays a subtotal amount for each Account:

    Account

    Department

    Amount

    60000

    100

    1000

     

    110

    2000

     

    120

    1000

    Subtotal

     

    4000

    62000

    100

    2000

     

    110

    1000

     

    130

    3000

    Subtotal

     

    6000