This chapter lists the reports provided with the PeopleSoft Enterprise Application Fundamentals 8.9 PeopleBook and includes general information and links to additional information about specific reports.
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
Use this table to find general information about PeopleSoft Application Fundamentals reports.
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
APY0003 |
Displays Payables User defaults by SetID. For each user, the default values for Business Unit, SetID and Origin as well as Vendor and Voucher Processing Authority display. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, User Preferences, AP User Preferences Report |
RUN_APY0003 |
APY0012 |
Displays available accounting entry templates and shows template name, effective date, type, description, account, department, product, and project. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Accounting Entry Templates, Template Report |
RUN_APY0012 |
ChartField Project |
Displays steps to configure a ChartField to individual needs. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, Configuration Steps |
RUN_CFC001 |
Cross/Reciprocal Rate Calc |
Displays the cross rates calculated for selected currency exchange rates. (SQR) |
Set Up Financials/Supply Chain, Common Definitions, Market Rates, Cross/Reciprocal Rate Calc |
RUN_EO9030 |
Installation Options |
Displays the contents of the PeopleSoft Installation Table, which contains system-wide parameters used by the applications. (Crystal) |
Set Up Financials/Supply Chain, Install, Installation Options Report |
RUN_FIN0001 |
Detail Calendars |
Displays information about detail calendars, including a description as well as a listing of the periods you have defined for the calendar. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Detail Calendar Report |
RUN_FIN0002 |
TimeSpans |
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. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, TimeSpans Report |
RUN_FIN0003 |
Account Types |
Displays all the account types, including the long and short descriptive name, and indicates whether the system carries forward the balance for that account type. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, Account Types |
RUN_FIN0004 |
Statistics Units of Measure |
Displays a standard, portrait-style report of the contents of the Statistics Units of Measure table. The report also contains the unit of measure and description. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Units of Measure, Units of Measure Report |
RUN_FIN0005 |
User Preferences |
Displays the values you enter for system users on the User Preference page. The User ID, business unit, SetID, ledger, source, and as-of date also display. These are the default settings that appear on the pages and reports used by each user. (SQR) |
Set Up Financials/Supply Chain, Common Definitions, User Preferences, User Preferences Report |
RUN_FIN0006 |
FIN0007 |
Displays a valid list of SpeedTypes. A SpeedType enables you to enter shorthand keys to trigger a system expansion into pre-specified values for one or more fields on a page. For each SpeedType, the report prints a description, the User ID or class, and associated values for account, department, product, project, and statistics code. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, SpeedTypes |
RUN_FIN0007 |
Journal Sources |
Displays valid journal entry sources. Source codes describe the origination of journal entries or the party responsible for generating the journal, define special processing, and make financial transactions easier to identify and report. (SQR) |
Set Up Financials/Supply Chain, Common Definitions, Journals, Source Report |
RUN_FIN0008 |
Valid General Ledger Accounts |
Displays the valid general ledger accounts by SetID. For each account, the report prints a description, short name, and the account type. Shows if the account is a statistical account and if so, what unit of measure is used. If the account contains open items, lists their descriptions as well as the edit record and field that apply. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Account |
RUN_FIN0010 |
Valid Department Codes |
Displays valid department codes by SetID. Prints the department ID and its description, along with each department manager’s name. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Department |
RUN_FIN0011 |
Valid Product Codes |
Displays valid product codes by SetID. Prints the product ID and its description, in ascending order by ID. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Product |
RUN_FIN0012 |
Valid Project IDs |
Displays valid projects by SetID. For each project, prints the description, manager’s name, and the project start and end dates. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Project |
RUN_FIN0013 |
Valid Statistics Code |
Produces a standard portrait style report that show the contents of the Statistics Codes table. Displays the code along with a description, the standard unit of measure, and the ledger update method. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Statistics Code |
RUN_FIN0015 |
Record Groups |
Displays tables by the record group they belong to. Displays a description and table name for each record group ID. (Crystal) |
Set Up Financials/Supply Chain, Business Unit Related, Reports, Record Groups |
RUN_FIN0016 |
Valid Set IDs |
Displays a short and long description of each SetID valid on a specific date. (Crystal) |
Set Up Financials/Supply Chain, Business Unit Related, Reports, TableSet IDs |
RUN_FIN0017 |
Table Set Controls |
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. For each record group, shows the ID, description, SetID, and SetID description. (SQR) |
Set Up Financials/Supply Chain, Business Unit Related, Reports, TableSet Controls |
RUN_FIN0018 |
Valid General Ledger Business Units |
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. (SQR) |
Set Up Financials/Supply Chain, Business Unit Related, Reports, General Ledger Units |
RUN_FIN0020 |
Ledgers for a Business Unit |
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. (SQR) |
Set Up Financials/Supply Chain, Business Unit Related, Reports, Ledgers For A Unit |
RUN_FIN0021 |
Detail Ledger Definition |
Displays general information about detail ledgers. Includes a description, error handling options, accounting periods, record names, and a listing of the ChartFields associated with the ledger. (Crystal) |
General Ledger, Ledgers, Detail Ledger Report |
RUN_FIN0022 |
Detail Ledger Template Definition |
Displays the records and fields included in detail ledger templates. (Crystal) |
General Ledger, Ledgers, Template Report |
RUN_FIN0023 |
Valid Budget Reference |
Lists all valid Budget Reference ChartField values in a SetID. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Report, Select Budget Reference |
RUN_FIN0024 |
Scenario |
Lists by setID the current active budget scenario. |
Set Up Financial/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Scenario |
RUN_FIN0025 |
nVision Reports |
Displays the PS/nVision reports for selected business units. For each report, shows the ID, description, layout, scope ID, scope description, business unit, last run date, as-of date type, as-of date, tree date type, and tree date. (Crystal) |
General Ledger, General Reports, nVision Request Summary |
RUN_FIN0030 |
nVision Scopes |
Displays the details of each PS/nVision Scope definition. (Crystal) |
General Ledger, General Reports, nVision Scope |
RUN_FIN0031 |
Valid Operating Units |
Displays the valid operating units for a selected SetID. For each SetID it shows the operating units, their description, their status, and the effective date of the status. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Operating Unit |
RUN_FIN0032 |
Valid Alternate Account |
Displays the valid Alternate Accounts for a SetID. For each alternate account, the report prints a description, account type, if it has open items, if it’s a statistical account, any control flags, the current effective status and, its effective date. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Alternate Account |
RUN_FIN0033 |
Currency Codes |
Displays information about a currency, including code, effective date, description, symbol, country, and decimal point. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Currency, Currency Code Report |
RUN_FIN0035 |
Alternate Account Cross Reference |
Displays accounts with corresponding cross-referenced alternate accounts, by SetID and Effective Date. (SQR) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, Alt Acct Cross Reference |
RUN_FIN0036 |
Chartfield 1 |
Displays the valid values for a selected setID. |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Chartfield 1 |
RUN_FIN0037 |
Chartfield 2 |
Displays the valid values for a selected setID. |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Chartfield 2 |
RUN_FIN0038 |
Chartfield 3 |
Displays the valid values for a selected setID. |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Chartfield 3 |
RUN_FIN0039 |
Valid Fund Codes |
Displays a list of all valid fund code ChartField values. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Fund Code |
RUN_FIN0050 |
Valid Program Codes |
Displays a list of all valid program code ChartField values. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Program Code |
RUN_FIN0052 |
Valid Class |
Displays a list of all valid class ChartField values. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, select Class Field |
RUN_FIN0053 |
Journal Types |
Displays the various Journal Types defined on the Journal Types page for a particular SetID. Includes descriptions for each Journal Type and indicates whether they are sequenced by Document Type or Journal Code. Related to Document Sequencing. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Journal Type Report |
RUN_FIN0057 |
Journal Codes |
Displays the various Journal Codes defined on the Journal Codes page for a particular SetID-Journal Type combination. Includes descriptions for each Journal Code, as well as Sequence Range and Sequencing Type information. Related to Document Sequencing. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Journal Code Report |
RUN_FIN0058 |
Document Types |
Displays the various Document Types defined on the Document Type page for a particular SetID-Journal Type-Journal Code combination. Includes descriptions for each Document Type, as well as Sequence Range and Sequencing Type information. Related to Document Sequencing. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Document Type Report |
RUN_FIN0059 |
Document Sequence Ranges |
Displays the detail range(s) defined on the Document Sequence Range page for a specified Sequence Range. (Crystal) |
Set Up Financials/Supply Chain, Common Definitions, Document Sequencing, Sequence Range Report |
RUN_FIN0060 |
FIN0061 ChartField Attribute Report |
This report lists all or a selected list of ChartFields and their associated attributes, attribute descriptions, and attribute values. (SQR) |
Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Attributes |
RUN_FIN0061 |
Message Log Report |
Prints message logs for a process instance ID and batch report type, similar to the online query 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 |
Journal Entry |
Displays all journal entries 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 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 |
FIN5001 |
This report consists of detailed subsystem and 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 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 Reconciliation Subsystem, Reconciliation by System Srce (source) |
RUN_FIN5001 |
FIN5005 |
This 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) |
General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by ChartFields |
RUN_FIN5005 |
GLC1001 |
List Ledger Codes with associated Book Code and provides description. (Crystal) |
General Ledger, Ledgers, Ledger Codes Report |
RUN_GLC1001 |
Adjustment Types |
By setID, displays current active Adjustment Type ChartField values. (Crystal) |
Setup Financials / Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Adjustment Type |
RUN_GLC4004 |
Book Codes |
By setID, displays current active Book Codes. (Crystal) |
Setup Financials / Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Book Code |
RUN_GLC4005 |
Balancing Groups |
Display all Balancing Groups and describes whether they are active or inactive and shows the default balancing group. (Crystal) |
Setup Financials / Supply Chain, Common Definitions, Design ChartFields, Reports, ChartField Reports, Account Balancing Group |
RUN_GLC4006 |
Journal Entry Template Report |
Displays Journal Entry Templates by the security applied that is available to a user. (Crystal) |
Setup Financials / Supply Chain, Common Definitions, Journals, Journal Entry Template Report |
RUN_GLC4007 |
Displays tax authorities by setID. For each tax authority, the authority code, name, effective date, percentage and ChartField values appear. |
Setup Financials/Supply Chain, Common Definitions, Sales and Use Tax, Authorities Report |
RUN_APY0006 |
|
Displays tax codes by setID. For each tax code, a description, tax type, VAT reference, tax calculation information, taxing authority, effective date, and tax percentage appear. |
Setup Financials/Supply Chain, Common Definitions, Sales and Use Tax, Codes Report |
RUN_APY0007 |
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:
Enter the header selection criteria and click Refresh to populate the grid with rows for each ChartField.
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.
(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.
(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.
(Optional) Select Descr to include a description of the ChartField value.
(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 |