Appendix: PeopleSoft Financials Global Reports

This Appendix lists global reports provided with PeopleSoft Financials and includes:

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

See Also

Enterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler

Click to jump to parent topicPeopleSoft Global Options and Reports: A-Z

The information in this section is common to PeopleSoft Financial applications. Some of the pages used to generate reports have other application-specific functionality as well.

The following is a list of the standard financial reports included with your PeopleSoft applications.

Report ID and Report Name

Description

Navigation

Run Control Page

APY1200

Journal Detail

Displays totals for all debits and credits for each journal type such as sales journal or purchase journal. (Crystal)

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APX1200

Journal Detail (XMLP)

Displays totals for all debits and credits for each journal type such as sales journal or purchase journal. (XMLP)

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APY1200A

Journal Detail by Alternate Account

Displays totals for all debits and credits for each journal type with alternate accounts. (Crystal)

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APX1200A

Journal Detail by Alternate Account (XMLP)

Displays totals for all debits and credits for each journal type with alternate accounts. (XMLP)

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APY1201

Journal Detail, No Document Sequencing

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

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APX1201

Journal Detail, No Document Sequencing (XMLP)

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

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APY1201A

Journal Detail by Alternate Account with no Document Sequencing

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

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APX1201A

Journal Detail by Alternate Account with no Document Sequencing (XMLP)

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

Statutory Reports, Accounts Payable, Journal Detail

RUN_APY1200

APY1210

Journal Account Summary

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1210

APX1210

Journal Account Summary (XMLP)

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1210

APY1210A

Journal Account Summary by Alternate Account

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1210

APX1210A

Journal Account Summary by Alternate Account (XMLP)

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1210

APY1211

Journal Account Summary, no document sequencing

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1211

APX1211

Journal Account Summary, no document sequencing (XMLP)

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1211

APY1211A

Journal Account Summary by Alternate Account, no document sequencing

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1211

APX1211A

Journal Account Summary by Alternate Account, no document sequencing (XMLP)

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

Statutory Reports, Accounts Payable, Journal Account Summary

RUN_APY1211

APY1220

Transaction Detail by Account

Displays journal entries for selected payable accounts by accounting period and vendor. (Crystal)

The Vendor Set ID field on the run control page is only for prompting purposes for the From Vendor ID and the To Vendor ID fields. The Vendor Set ID 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.

Statutory Reports, Accounts Payable, Transaction Detail by Account

RUN_APY1220

APX1220

Transaction Detail by Account (XMLP)

Displays journal entries for selected payable accounts by accounting period and vendor. (XMLP)

The Vendor Set ID field on the run control page is only for prompting purposes for the From Vendor ID and the To Vendor ID fields. The Vendor Set ID 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.

Statutory Reports, Accounts Payable, Transaction Detail by Account

RUN_APY1220

APY1220A

Transaction Detail by Alternate Account

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

Statutory Reports, Accounts Payable, Transaction Detail by Account

RUN_APY1220

APX1220A

Transaction Detail by Alternate Account (XMLP)

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

Statutory Reports, Accounts Payable, Transaction Detail by Account

RUN_APY1220

APY1230

Balance by Account/Vendor

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

Statutory Reports, Accounts Payable, Balance by Account/Vendor

RUN_APY1230

APX1230

Balance by Account/Vendor (XMLP)

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

Statutory Reports, Accounts Payable, Balance by Account/Vendor

RUN_APY1230

APY1230A

Balance by Alternate Account/Vendor

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

Statutory Reports, Accounts Payable, Balance by Account/Vendor

RUN_APY1230

APX1230A

Balance by Alternate Account/Vendor (XMLP)

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

Statutory Reports, Accounts Payable, Balance by Account/Vendor

RUN_APY1230

APY3200

Transaction Detail by Vendor

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

The Vendor Set ID field on the run control page is only for prompting purposes for the From Vendor ID and the To Vendor ID fields. The Vendor Set ID 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.

Statutory Reports, Accounts Payable, Transaction Detail by Vendor

RUN_APY3200

APX3200

Transaction Detail by Vendor (XMLP)

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

The Vendor Set ID field on the run control page is only for prompting purposes for the From Vendor ID and the To Vendor ID fields. The Vendor Set ID 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.

Statutory Reports, Accounts Payable, Transaction Detail by Vendor

RUN_APY3200

APY3200A

Transaction Detail by Vendor/Alternate Account

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

Statutory Reports, Accounts Payable, Transaction Detail by Vendor

RUN_APY3200

APX3200A

Transaction Detail by Vendor/Alternate Account (XMLP)

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

Statutory Reports, Accounts Payable, Transaction Detail by Vendor

RUN_APY3200

APY3210

Balance by Vendor/Account

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

Statutory Reports, Accounts Payable, Balance by Vendor/Account

RUN_APY3210

APY3210A

Balance by Vendor/Alternate Account

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

Statutory Reports, Accounts Payable, Balance by Vendor/Account

RUN_APY3210

AR80011

Journal Detail

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

Statutory Reports, Accounts Receivable, Journal Detail

RUN_AR80011

AR80011A

Journal Detail by Alternate Account

Summarizes the debits and credits for a ledger in the ledger currency by journal type and Alternate Account for a selected date. (Crystal)

Statutory Reports, Accounts Receivable, Journal Detail

RUN_AR80011

AR80012

Journal Account Summary

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

Statutory Reports, Accounts Receivable, Journal Account Summary

RUN_AR80012

AR80012A

Journal Account Summary by Alternate Account

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

Statutory Reports, Accounts Receivable, Journal Account Summary

RUN_AR80012

AR80013

Balances By Account/Customer

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

Statutory Reports, Accounts Receivable, Balance by Account/Customer

RUN_AR80013

AR80013A

Balances By Alternate Account/Customer

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

Statutory Reports, Accounts Receivable, Balance by Account/Customer

RUN_AR80013

AR80014

Balance By Customer/Account

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

Statutory Reports, Accounts Receivable, Balance by Customer/Account

RUN_AR80014

AR80014A

Balance By Customer/Alternate Account

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

Statutory Reports, Accounts Receivable, Balance by Customer/Account

RUN_AR80014

AR80015

Transaction Detail by Account

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

Statutory Reports, Accounts Receivable, Transaction Detail by Account

RUN_AR80015

AR80015A

Transaction Detail by Alternate Account

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

Statutory Reports, Accounts Receivable, Transaction Detail by Account

RUN_AR80015

AR80016

Transaction Detail by Customer

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

Statutory Reports, Accounts Receivable, Transaction Detail by Customer

RUN_AR80016

AR80016A

Transaction Detail by Customer/Alternate Account

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

Statutory Reports, Accounts Receivable, Transaction Detail by Customer

RUN_AR80016

AR80017

Journal Detail, no Document Sequencing

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

Statutory Reports, Accounts Receivable, Journal Detail

RUN_AR80011

AR80017A

Journal Detail by Alternate Account, no document sequencing

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

Statutory Reports, Accounts Receivable, Journal Detail

RUN_AR80011

AR80018

Journal Account Summary, no Document Sequencing

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

Statutory Reports, Accounts Receivable, Journal Account Summary

RUN_AR80012

AR80018A

Journal Account Summary by Alternate Account, no Document Sequencing

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

Statutory Reports, Accounts Receivable, Journal Account Summary

RUN_AR80012

EXG1200

Journal Detail

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

Statutory Reports, Expenses, Journal Detail

RUN_EXG1200

EXX1200

Journal Detail (XMLP)

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

Statutory Reports, Expenses, Journal Detail

RUN_EXG1200

EXG1200A

Journal Detail by Alternate Account

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

Statutory Reports, Expenses, Journal Detail

RUN_EXG1200

EXX1200A

Journal Detail by Alternate Account (XMLP)

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

Statutory Reports, Expenses, Journal Detail

RUN_EXG1200

EXG1210

Journal Account Summary

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

Statutory Reports, Expenses, Journal Account Summary

RUN_EXG1210

EXX1210

Journal Account Summary (XMLP)

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

Statutory Reports, Expenses, Journal Account Summary

RUN_EXG1210

EXG1210A

Journal Account Summary by Alternate Account

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

Statutory Reports, Expenses, Journal Account Summary

RUN_EXG1210

EXX1210A

Journal Account Summary by Alternate Account (XMLP)

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

Statutory Reports, Expenses, Journal Account Summary

RUN_EXG1210

EXG1220

Transaction Detail by Account

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

Statutory Reports, Expenses, Transaction Detail by Account

RUN_EXG1220

EXX1220

Transaction Detail by Account (XMLP)

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

Statutory Reports, Expenses, Transaction Detail by Account

RUN_EXG1220

EXG1220A

Transaction Detail by Alternate Account

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

Statutory Reports, Expenses, Transaction Detail by Account

RUN_EXG1220

EXX1220A

Transaction Detail by Alternate Account (XMLP)

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

Statutory Reports, Expenses, Transaction Detail by Account

RUN_EXG1220

EXG1230

Balance by Account/Employee

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

Statutory Reports, Expenses, Balance by Account/Employee

RUN_EXG1230

EXX1230

Balance by Account/Employee (XMLP)

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

Statutory Reports, Expenses, Balance by Account/Employee

RUN_EXG1230

EXG1230A

Balance by Alternate Account/Employee

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

Statutory Reports, Expenses, Balance by Account/Employee

RUN_EXG1230

EXX1230A

Balance by Alternate Account/Employee (XMLP)

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

Statutory Reports, Expenses, Balance by Account/Employee

RUN_EXG1230

EXG3200

Transaction Detail by Employee

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

Statutory Reports, Expenses, Transaction Detail by Employee

RUN_EXG3200

EXX3200

Transaction Detail by Employee (XMLP)

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

Statutory Reports, Expenses, Transaction Detail by Employee

RUN_EXG3200

EXG3200A

Transaction Detail by Employee/Alternate Account

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

Statutory Reports, Expenses, Transaction Detail by Employee

RUN_EXG3200

EXX3200A

Transaction Detail by Employee/Alternate Account (XMLP)

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

Statutory Reports, Expenses, Transaction Detail by Employee

RUN_EXG3200

EXG3210

Balance by Employee/Account

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

Statutory Reports, Expenses, Balance by Employee/Account

RUN_EXG3210

EXX3210

Balance by Employee/Account (XMLP)

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

Statutory Reports, Expenses, Balance by Employee/Account

RUN_EXG3210

EXG3210A

Balance by Employee/Alternate Account

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

Statutory Reports, Expenses, Balance by Employee/Account

RUN_EXG3210

EXX3210A

Balance by Employee/Alternate Account (XMLP)

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

Statutory Reports, Expenses, Balance by Employee/Account

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)

Statutory Reports, Legalized Paper ITA

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.

Note. The Journal Summary Report will only be printed if there are at least two journals to be processed for the criteria selected on the request page. (SQR)

Statutory Reports, General Ledger, Journal Activity

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)

Statutory Reports, General Ledger, Journal Activity

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)

Statutory Reports, General Ledger, Journal Activity

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)

Statutory Reports, General Ledger, Journal Contra Activity, Contra Journal Activity

RUN_FIN2003

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)

Statutory Reports, AR/AP Doc Sequence Control

RUN_FIN5002

FIN5003

Italian Detail Book (Libro Sezionale)

Prints the journals that relate to vendors 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)

Statutory Reports, Detail Book ITA

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)

Statutory Reports, Journal Book ITA

RUN_FIN5004

FIN5101

Regulatory Ledger Translation Error Report (Crystal )

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 whose 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. (Crystal)

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

General Ledger, Regulatory Ledger Reports, Ledger Error

RUN_FIN5101

FSX5101

Regulatory Ledger Translation Error Report (XML Publisher)

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

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)

General Ledger, Regulatory Ledger Reports, Ledger Error

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)

General Ledger, Regulatory Ledger Reports, ChartField Value Mapping

RUN_FIN5102

GLS7005

GL Transaction Detail Report

Displays account activity information for selected accounts. (SQR)

Statutory Reports, General Ledger, General Ledger Activity

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)

Statutory Reports, General Ledger, Accounting Transaction Control

RUN_GLS7006

GLS7013

Statutory Summary Balance Report

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

Statutory Reports, General Ledger, Summary Balance

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)

Statutory Reports, General Ledger, Trial Balance

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)

Statutory Reports, General Ledger, Trial Balance

RUN_GLS7014

IST0050

Intrastat Form N

Provides an Intrastat report for Form N. (Crystal)

VAT and Intrastat, Intrastat, Returns and Output Files

IST_RPT_INST1

ISTX0050

Intrastat Form N (XMLP)

Provides an Intrastat report for Form N. (XMLP)

VAT and Intrastat, Intrastat, Returns and Output Files

IST_RPT_INST1

IST0100

Intrastat From R

Provides an Intrastat report for Form R. (Crystal)

VAT and Intrastat, Intrastat, Returns and Output Files

IST_RPT_INST1

IST0150

Intrastat Form DEB

Provides an Intrastat report for Form DEB. (Crystal)

VAT and Intrastat, Intrastat, Returns and Output Files

IST_RPT_INST1

ISTX0150

Intrastat Form DEB (XMLP)

Provides an Intrastat report for Form DEB. (XMLP)

VAT and Intrastat, Intrastat, Returns and Output Files

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.

Statutory Reports, Statutory Report 347 ESP

RUN_LC_CNTL

LC_RPT_VAT

VAT Transaction Report

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports, VAT Reports

VAT_RPT_INST1

VAT0100

VAT Return Germany - (Umsatzsteuer- voranmeldung)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0100

VAT Return - Germany (XMLP) - (Umsatzsteuer- voranmeldung)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0150

VAT Transaction Report (Germany)

Provides a VAT transaction report for Germany. (SQR)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0200

CA3 VAT Return (France)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0200

CA3 VAT Return France (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0300

VAT Return (Spain - Declaration IVA - Espana)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0300

VAT Return Spain - Declaration IVA - Espana (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0350

Canada VAT Report

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0350

Canada VAT Report (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0400

VAT Recovery Report by Tax Authority (Canada)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0400

VAT Recovery Report by Tax Authority - Canada (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0550

VAT Return (Belgium)

Provides a VAT return report for Belgium. Report prints in Dutch and English languages only. (Crystal)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0550

VAT Return Belgium (XMLP)

Provides a VAT return report for Belgium. Report prints in Dutch and English languages only. (XMLP)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0600

Australian GST - Business Activity Statement - Calculation Sheet

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPTG_RQST2

VATX0600

Australian GST - Business Activity Statement - Calculation Sheet (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPTG_RQST2

VAT0700

VAT Listing Input (Spain) Libro Registro De Facturas Recibidas

Provides a VAT listing of all vouchers. Report prints in Spanish language only. (Crystal)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0700

VAT Listing Input (Spain) Libro Registro De Facturas Recibidas (XMLP)

Provides a VAT listing of all vouchers. Report prints in Spanish language only. (XMLP)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0750

VAT Listing Input Spain by Transaction Type

Provides a VAT listing of all vouchers grouped by transaction type. Report prints in Spanish language only. (Crystal)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0750

VAT Listing Input Spain by Transaction Type (XMLP)

Provides a VAT listing of all vouchers grouped by transaction type. Report prints in Spanish language only. (XMLP)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0800

VAT Listing Output Spain - (Libro Registro De Facturas Emitidas)

Provides a VAT listing of all Items. Report prints in Spanish language only. (Crystal)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0800

VAT Listing Output Spain (XMLP) - (Libro Registro De Facturas Emitidas)

Provides a VAT listing of all Items. Report prints in Spanish language only. (XMLP)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0850

VAT Listing Output Spain - (Libro Registro De Facturas Emitidas)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0850

VAT Listing Output Spain (XMLP) - Libro Registro De Facturas Emitidas)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0900

VAT Liquidation Italy - (VAT Liquidazione)

Provides a VAT report for Italy. (Crystal)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX0900

VAT Liquidation Italy (XMLP) - (VAT Liquidazione)

Provides a VAT report for Italy. (XMLP)

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT0910

VAT Register Italy

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

VAT and Intrastat, Value Added Tax, VAT Reports, ITA-VAT Register

VAT_REGISTER_RQST

VAT1002

EC Sales List

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1002

EC Sales List (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1003

VAT Return

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1003

VAT Return (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1004

EC Sales List — UK

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1004

EC Sales List - UK (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1005

UK VAT Return

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1005

UK VAT Return (XMLP)

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

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1006

Switzerland VAT Return

Provides a VAT Return Report for Switzerland. (Crystal).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1006

Switzerland VAT Return (XMLP)

Provides a VAT Return Report for Switzerland. (XMLP).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1007

Netherlands VAT Return

Provides a VAT Return Report for the Netherlands. (Crystal).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1007

Netherlands VAT Return

Provides a VAT Return Report for the Netherlands. (XMLP).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VAT1008

Luxembourg VAT Return

Provides a VAT Return Report for the Luxembourg. (Crystal).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

VAT_RPT_INST1

VATX1008

Luxembourg VAT Return

Provides a VAT Return Report for the Luxembourg. (XMLP).

VAT and Intrastat, Value Added Tax, VAT Reports, Return and Other Reports

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.

VAT and Intrastat, Value Added Tax, VAT Reports, Reconciliation Reports

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.

VAT and Intrastat, Value Added Tax, VAT Reports, Reconciliation Reports

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.

VAT and Intrastat, Value Added Tax, VAT Reports, Reconciliation Reports

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.

VAT and Intrastat, Value Added Tax, VAT Reports, Reconciliation Reports

RUN_VAT2000

VAT2005

Zero-rated VAT Justification

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

VAT and Intrastat, Value Added Tax, VAT Reports, Reconciliation Reports

RUN_VAT2000

VAT3000

VAT Set Up Validation

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

Set Up Financials/Supply Chain, Common Definitions, VAT and Intrastat, Value Added Tax, VAT Set Up Validation Report

RUN_LC_VATCHK

Click to jump to parent topicUsing XMLP Reports to Support Configured ChartFields

Oracle XML Publisher (XMLP) technology is accessible from PeopleTools PS Query and all PeopleTools 8.5x-based applications. This technology enables PeopleSoft Enterprise to deliver XML publisher reports in addition to the Crystal reports. The Crystal reports 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.

Click to jump to top of pageClick to jump to parent topicXMLP Reports

The following section is a list of the Global Options reports that can be generated in both Crystal and XMLP formats: