PeopleSoft Global Options and Reports: A-Z

APX1200

Journal Detail (BI Publisher)

Displays totals of all debits and credits for each journal type such as a sales or purchase journal. (BI Publisher)

RUN_APY1200

APX1200A

Journal Detail by Alternate Account (BI Publisher)

Displays totals of all debits and credits for each journal type by alternate accounts. (BI Publisher)

RUN_APY1200

APX1201

Journal Detail, No Document Sequencing (BI Publisher)

Displays totals of all debits and credits for each journal type such as a sales or purchase journal with no document sequencing information. (BI Publisher)

RUN_APY1200

APX1201A

Journal Detail by Alternate Account with no Document Sequencing (BI Publisher)

Displays totals of all debits and credits for each journal type by alternate accounts with no document sequencing information. (BI Publisher)

RUN_APY1200

APX1210

Journal Account Summary (BI Publisher)

Displays total debits and credits for each account within the specified journal type. (BI Publisher)

RUN_APY1210

APX1210A

Journal Account Summary by Alternate Account (BI Publisher)

Displays total debits and credits for each alternate account within the specified journal type. (BI Publisher)

RUN_APY1210

APX1211

Journal Account Summary, no document sequencing (BI Publisher)

Lists debits and credits in the ledger currency for each account for specified journal types. (BI Publisher)

RUN_APY1211

APX1211A

Journal Account Summary by Alternate Account, no document sequencing (BI Publisher)

Lists debits and credits in the ledger currency for each alternate account for specified journal types. (BI Publisher)

RUN_APY1211

APX1220

Transaction Detail by Account (BI Publisher)

Displays journal entries for selected payable accounts by accounting period and supplier. (BI Publisher)

The Supplier SetID field on the run control page is only for prompting purposes for the From Supplier ID and the To Supplier ID fields. The Supplier SetID field is not a filter for data printed on the report. The business unit is used by the system to filter data. The report provides a total by SetID, if multiple SetIDs are processed.

RUN_APY1220

APX1220A

Transaction Detail by Alternate Account (BI Publisher)

Displays journal entries for selected alternate accounts by accounting period and vendor. (BI Publisher)

RUN_APY1220

APX1230

Balance by Account/Vendor (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected vendors by payables account. (BI Publisher)

RUN_APY1230

APX1230A

Balance by Alternate Account/Vendor (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected vendors by alternate account. (BI Publisher)

RUN_APY1230

APX3200

Transaction Detail by Vendor (BI Publisher)

Displays journal entries by vendor, account and accounting period. (BI Publisher)

The Supplier SetID field on the run control page is only for prompting purposes for the From Supplier ID and the To Supplier ID fields. The Supplier SetID field is not a filter for data printed on the report. The business unit is used by the system to filter data. The report provides a total by SetID, if multiple SetIDs are processed.

RUN_APY3200

APX3200A

Transaction Detail by Vendor/Alternate Account (BI Publisher)

Displays journal entries by vendor, alternate account and accounting period. (BI Publisher)

RUN_APY3200

APX3210

Balance by Vendor/Account (BI Publisher)

Displays vendor beginning and ending balances and total debits and credits. (BI Publisher)

RUN_APY3210

APX3210A

Balance by Vendor/Alternate Account (BI Publisher)

Displays vendor beginning and ending balances and total debits and credits. (BI Publisher)

RUN_APY3210

ARX80012

Journal Account Summary (BI Publisher)

Lists the debits and credits in the ledger currency for each account for specified journal types and a selected date range and business unit. The report provides subtotals by subclass and class for each account if requested. For example, there is a subtotal for class each time the first digit in the account changes. (BI Publisher)

RUN_AR80012

ARX80012A

Journal Account Summary by Alternate Account (BI Publisher)

Lists the debits and credits in the ledger currency for each alternate account for specified journal types and a selected date range and business unit. The report provides subtotals by subclass and class for each alternate account if requested. For example, there is a subtotal for class each time the first digit in the alternate account changes. (BI Publisher)

RUN_AR80012

ARX80013

Balances By Account/Customer (BI Publisher)

Lists the beginning balance, ending balance, and credit and debit totals for selected accounting periods for each selected Receivables account by customer in a business unit. (BI Publisher)

RUN_AR80013

ARX80013A

Balances By Alternate Account/Customer (BI Publisher)

Lists the beginning balance, ending balance, and credit and debit totals for selected accounting periods for each selected alternate account by customer in a business unit. (BI Publisher)

RUN_AR80013

ARX80014

Balance By Customer/Account (BI Publisher)

Lists the beginning balance, ending balance and credit and debit totals for a selected accounting period for each selected customer by Receivables account in a business unit. (BI Publisher)

RUN_AR80014

ARX80014A

Balance By Customer/Alternate Account (BI Publisher)

Lists the beginning balance, ending balance and credit and debit totals for a selected accounting period for each selected customer by alternate account in a business unit. (BI Publisher)

RUN_AR80014

ARX80015

Transaction Detail by Account (BI Publisher)

Lists journal entries for selected Receivables accounts in a business unit by accounting period and customer. The report includes the beginning balance (in the ledger currency), ending balance, accounting date, document sequencing date, line item description, journal type, journal code, document type, document sequencing number, debits and credits (in the ledger currency), debits and credits in the foreign currency, if requested, with the foreign currency rate type and exchange rate). (BI Publisher)

RUN_AR80015

ARX80015A

Transaction Detail by Alternate Account (BI Publisher)

Lists journal entries for selected alternate accounts in a business unit by accounting period and customer. The report includes the beginning balance (in the ledger currency), ending balance, accounting date, document sequencing date, line item description, journal type, journal code, document type, document sequencing number, debits and credits (in the ledger currency), debits and credits in the foreign currency, if requested, with the foreign currency rate type and exchange rate). (BI Publisher)

RUN_AR80015

ARX80016

Transaction Detail by Customer (BI Publisher)

Lists journal entries for selected customers in a business unit by customer, account, and accounting period. The report includes: the beginning balance (in the ledger currency), ending balance, accounting date, document sequencing date, line item description, journal type, journal code, document type, document sequencing number, debits and credits (in the ledger currency), and debits and credits in the foreign currency, if requested with the foreign currency rate type and exchange rate. (BI Publisher)

RUN_AR80016

ARX80016A

Transaction Detail by Customer/Alternate Account (BI Publisher)

Lists journal entries for selected customers in a business unit by customer, alternate account, and accounting period. The report includes: the beginning balance (in the ledger currency), ending balance, accounting date, document sequencing date, line item description, journal type, journal code, document type, document sequencing number, debits and credits (in the ledger currency), and debits and credits in the foreign currency, if requested with the foreign currency rate type and exchange rate. (BI Publisher)

RUN_AR80016

ARX80017

Journal Detail, no Document Sequencing (BI Publisher)

Summarizes the debits and credits for a ledger in the ledger currency by journal type for a selected date, with no document sequencing information. (BI Publisher)

RUN_AR80011

ARX80017A

Journal Detail by Alternate Account, no document sequencing (BI Publisher)

Summarizes the debits and credits for a ledger in the ledger currency by journal type and alternate account for a selected date, with no document sequencing information. (BI Publisher)

RUN_AR80011

ARX80018

Journal Account Summary, no Document Sequencing (BI Publisher)

Lists the debits and credits in the ledger currency for each account for specified journal types and a selected date range and business unit. The report provides subtotals by subclass and class for each account if requested. For example, there is a subtotal for class each time the first digit in the account changes. The report does not print document sequencing information. (BI Publisher)

RUN_AR80012

ARX80018A

Journal Account Summary by Alternate Account, no Document Sequencing (BI Publisher)

Lists the debits and credits in the ledger currency for each alternate account for specified journal types and a selected date range and business unit. The report provides subtotals by subclass and class for each alternate account if requested. For example, there is a subtotal for class each time the first digit in the alternate account changes. The report does not print document sequencing information. (BI Publisher)

RUN_AR80012

EXX1200

Journal Detail (BI Publisher)

Summarizes the debits and credits for a ledger in the ledger currency by journal type for a selected date. (BI Publisher)

RUN_EXG1200

EXX1200A

Journal Detail by Alternate Account (BI Publisher)

Summarizes the debits and credits for a ledger in the ledger currency by journal type and alternate account for a selected date. (BI Publisher)

RUN_EXG1200

EXX1210

Journal Account Summary (BI Publisher)

Displays total debits and credits for each account within the specified journal type. (BI Publisher))

RUN_EXG1210

EXX1210A

Journal Account Summary by Alternate Account (BI Publisher)

Displays total debits and credits for each alternate account within the specified journal type. (BI Publisher))

RUN_EXG1210

EXX1220

Transaction Detail by Account (BI Publisher)

Displays journal entries for selected expense accounts by accounting period. (BI Publisher)

RUN_EXG1220

EXX1220A

Transaction Detail by Alternate Account (BI Publisher)

Displays journal entries for selected expense alternate accounts by accounting period. (BI Publisher)

RUN_EXG1220

EXX1230

Balance by Account/Employee (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected account by employee. (BI Publisher)

RUN_EXG1230

EXX1230A

Balance by Alternate Account/Employee (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected alternate account by employee (BI Publisher)

RUN_EXG1230

EXX3200

Transaction Detail by Employee (BI Publisher)

Displays journal entries by Employee, Account and Accounting period. (BI Publisher)

RUN_EXG3200

EXX3200A

Transaction Detail by Employee/Alternate Account (BI Publisher)

Displays journal entries by Employee, Alternate Account and Accounting period. (BI Publisher)

RUN_EXG3200

EXX3210

Balance by Employee/Account (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected employee by account. (BI Publisher)

RUN_EXG3210

EXX3210A

Balance by Employee/Alternate Account (BI Publisher)

Displays the beginning balance, ending balance, and credit and debit totals for selected employee by alternate account. (BI Publisher)

RUN_EXG3210

FIN0070

Italian Legalized Paper Form

Italian statutory reports must be printed on legalized paper. Legalized paper meaning this paper has been authenticated and stamped by a notary public. The paper does not contain data. It remains blank except pages are numbered and contain some mandatory information on the header of each page. Because of the design of such reports, they cannot use the standard PeopleSoft SQR headers. (SQR)

RUN_FIN0070

FIN2002

Journal Summary

Displays summary information for all journals entered in the system for a business unit and ledger within the specified date range. Prints the journals in ascending ID order and shows the journal date, journal ID, description, and debit and credit amount totals for each journal. Also prints a Journal Detail report (FIN2002D) and an Account Summary report (FIN2002S), depending on the option selected on the request page.

RUN_FIN2002

FIN2002D

Journal Activity

Displays detail information for all journals entered in the system for a business unit and ledger within the specified date range. Provides the option to list journals by journal type, journal code, and document type for business units that are Document Sequencing enabled. Prints the journals in ascending ID order and shows the journal date, journal ID, description, and debit and credit amount totals for each journal. Also prints information from each journal line that is distributed to the selected GL business unit within the selected journal range. (SQR)

RUN_FIN2002

FIN2002S

Journal Account Summary

Displays the same as FIN2002D, but lists account summary information—account, description, debits and credits— for all journal entries entered in the system for a business unit and ledger within the specified date range. Also provides flexible subtotaling option by account. (SQR)

RUN_FIN2002

FIN2003

Contra Journal Activity Report

Displays PeopleSoft General Ledger journal activity information, including the specified range of accounts by business unit, ledger, fiscal year, and period. Also displays the assumed "contra" account for each journal line, depending on criteria entered on the request page. (SQR)

RUN_FIN2003

FINX2026

DTAUS EFT File Cover Sheet - Germany (BI Publisher)

Provides cover sheet for your EFT payments. (BI Publisher)

RUN_FIN2026

FIN5002

Payables/Receivables Accounting Transaction Control

Tracks document sequencing. Each transaction must exist only once and must be serially numbered. Any used sequence number that is deleted is recorded in order to track sequencing gaps. (SQR)

RUN_FIN5002

FIN5003

Italian Detail Book (Libro Sezionale)

Prints the journals that relate to suppliers and customers and is produced based on the PeopleSoft Statutory Report Loader (FS_FINRPTFS) tables, and is printed on legalized paper for use in Italy only. (SQR)

RUN_FIN5003

FIN5004

Italian Journal Book (Libro Giornale)

Prints accounting transactions that are recorded daily in a book called Libro Giornale, which contains all accounting entries posted during the year. It is produced based on the General Ledger tables. This report prints on legalized paper for use in Italy only. (SQR)

RUN_FIN5004

FSX5101

Regulatory Ledger Translation Error Report (BI Publisher)

XML reports do not require manual changes to support ChartField configuration .

Prints the contents of the Regulatory Ledger Translation Error table, which is populated during the Build Regulatory Ledger process with rows from the General Ledger tables for which internal ChartField values could not be translated into external regulatory ChartField values. The exact contents include: Business Unit, Regulatory Ledger, Regulatory Entity, External Entry Type, Fiscal Year, From Period, To Period, internal ChartField values, Currency, and Posted Total Amount. (XML)

RUN_FIN5101

FIN5102

Regulatory Ledger ChartField Value Mapping

Lists all the internal ChartFields, their effective dates, and descriptions for one or more ChartField value sets. (SQR)

RUN_FIN5102

GLS7005

GL Transaction Detail Report

Displays account activity information for selected accounts. (SQR)

RUN_GLS7005

GLS7006

Accounting Transaction Control

This report lists the document sequence numbers for accounting transactions by business unit, either to show all document sequence numbers or gaps in the document sequence numbers. (SQR)

RUN_GLS7006

GLS7013

Statutory Summary Balance Report

Displays balance information and shows ending ledger balances for the specified range of periods. (SQR)

RUN_GLS7013

GLS7014

Statutory Trial Balance Report

Displays account balance information, including information by selected previous and actual periods, and shows ending ledger balances for the specified period. (SQR)

RUN_GLS7014_PNLG

GLS7018

General Ledger Statutory Trial Balance Report, including YTD

GLS7018 is a layout variation of GLS7014 that is Italian specific. Displays account balance information, including information by selected periods, as well as year to date information. (SQR)

RUN_GLS7014

ISTX0050S

Intrastat Form N (BI Publisher)

Provides an Intrastat report for Form N. (BI Publisher)

IST_RPT_INST1

ISTX0100S

Intrastat Form R (BI Publisher)

Provides an Intrastat report for Form R. (BI Publisher)

IST_RPT_INST1

ISTX0150

Intrastat Form DEB (BI Publisher)

Provides an Intrastat report for Form DEB. (BI Publisher)

IST_RPT_INST1

ISTX0200

Intrastat Movement Statistics (BI Publisher)

Lists transactions that can be used to verify information reported in Intrastat Forms N or R. (BI Publisher)

IST_RPT_INST1

LCESP347

Spanish 347 Report

This statutory report provides a list of domestic vendors and customers with whom your company conducted transactions greater than a specified value for the Spanish authorities. A company has to declare the transactions bigger than 3.005,06 euros.

RUN_LC_CNTL

LC_RPT_VAT

VAT Transaction Report

Shows details of the line item amounts for the delivered VAT returns.

VAT_RPT_INST1

VATX0100

VAT Return - Germany (BI Publisher) - (Umsatzsteuer- voranmeldung)

Provides the VAT return report for Germany. Report prints in German language only. (BI Publisher)

VAT_RPT_INST1

VAT0150

VAT Transaction Report (Germany)

Provides a VAT transaction report for Germany. (SQR)

VAT_RPT_INST1

VATX0200

CA3 VAT Return France (BI Publisher)

Provides a VAT return report for France. Report prints in French language only. (BI Publisher)

VAT_RPT_INST1

VATX0300

VAT Return Spain - Declaration IVA - Espana (BI Publisher)

Provides a VAT return report for Spain. Report prints in Spanish language only. (BI Publisher)

VAT_RPT_INST1

VATX0350

Canada VAT Report (BI Publisher)

Provides a VAT return report for Canada. Report prints in English language only. (BI Publisher)

VAT_RPT_INST1

VATX0400

VAT Recovery Report by Tax Authority - Canada (BI Publisher)

Provides a report that splits VAT recoveries and rebates by VAT Authority for Canada. Report prints in English language only. (BI Publisher)

VAT_RPT_INST1

VATX0550

Belgian Annual VAT Declaration (BI Publisher)

Provides an annual VAT declaration report for Belgium. Report prints in Dutch and English languages only. (BI Publisher)

VAT_RPT_INST1

VATX0560

Belgian Monthly VAT Preparation (BI Publisher)

Provides a monthly draft of the VAT return report for Belgium. Report prints in Dutch and English languages only. (BI Publisher)

VAT_RPT_INST1

VATX0600

Australian GST - Business Activity Statement - Calculation Sheet (BI Publisher)

Provides a VAT return report for Australia. Report prints in English language only. (BI Publisher)

VAT_RPTG_RQST2

VATX0700S

Spanish Input VAT Journal Report (BI Publisher)

Provides a VAT listing of all vouchers with totals and all vouchers grouped by tax code. Report prints in Spanish language only. (BI Publisher)

VAT_RPT_INST1

VATX0800S

Spanish Output VAT Journal Report (BI Publisher)

Provides a VAT listing of all items and a listing of all items grouped by transaction type. Report prints in Spanish language only. (BI Publisher)

VAT_RPT_INST1

VATX0900

VAT Liquidation Italy (BI Publisher) - (VAT Liquidazione)

Provides a VAT report for Italy. (BI Publisher)

VAT_RPT_INST1

VAT0910

VAT Register Italy

Provides sales and purchase registers for VAT for Italy. (SQR)

VAT_REGISTER_RQST

VATX1002

European Sales Listing (BI Publisher)

Provides a VAT report listing a company's intra-EU (intra-European Union) sales. (BI Publisher)

VAT_RPT_INST1

VATX1003

VAT Return (BI Publisher)

Provides a summary VAT return report for a specified VAT Entity and country. (BI Publisher)

VAT_RPT_INST1

VATX1004

EC Sales List - UK (BI Publisher)

Provides a VAT report listing a company's intra-EU (intra-European Union) sales. Layout variation from VAT1002. (BI Publisher)

VAT_RPT_INST1

VATX1005

UK VAT Return (BI Publisher)

Provides a VAT return report for the UK. Report prints in English language only. (BI Publisher)

VAT_RPT_INST1

VATX1006

Switzerland VAT Return (BI Publisher)

Provides a VAT Return Report for Switzerland. (BI Publisher).

VAT_RPT_INST1

VATX1007

Netherlands VAT Return

Provides a VAT Return Report for the Netherlands. (BI Publisher).

VAT_RPT_INST1

VATX1008

Luxembourg VAT Return

Provides a VAT Return Report for the Luxembourg. (BI Publisher).

VAT_RPT_INST1

VAT2001

VAT Account Balance Reconciliation

For a specified range of VAT-applicable accounts and dates, allows comparison of the amount of expected VAT to the amount of VAT that was actually posted for VAT transactions that have been recorded in PeopleSoft Payables, Receivables, Billing, Asset Management, Expenses, Treasury, and General Ledger. This report also allows the total amount of posted VAT reported for each VAT account to be compared to the GL balance for that VAT account.

RUN_VAT2000

VAT2002

Taxable Account/VAT Account Reconciliation

For a specified range of accounts and dates, lists the taxable basis amounts as well as corresponding VAT amounts calculated from VAT transactions that have been posted by PeopleSoft Payables, Receivables, Billing, Asset Management, Expenses, Treasury, and General Ledger.

RUN_VAT2000

VAT2003

VAT Transaction Reconciliation

Provides an overview of VAT transactions generated by PeopleSoft Payables, Receivables, Billing, Asset Management, Expenses, Treasury, and General Ledger applications and verifies if those transactions have been reported on a VAT Return Report.

RUN_VAT2000

VAT2004

VAT Taxable Basis Reconciliation

Verifies that the VAT Basis amounts stored on the VAT Transaction Table, multiplied by the appropriate VAT percentage, is equal to the actual VAT amount also stored on the same table.

RUN_VAT2000

VAT2005

Zero-rated VAT Justification

Provides a list of zero-rated transactions for audit purposes.

RUN_VAT2000

VAT3000

VAT Set Up Validation

Validates VAT default setup data and exposes inconsistencies and missing default values.

RUN_LC_VATCHK