Generating Global Reports

This chapter provides an overview of global reports and discusses how to:

Run the Statutory Reports Loader process (FS_FINRPTFS).
Run statutory reports.

Understanding Global Reports

PeopleSoft Billing, General Ledger, Expenses, Payables, and Receivables provide several reports that meet European statutory reporting requirements. Though the reports are designed specifically to meet these requirements, and even if you do not use the Document Sequencing and MultiBook features, you can still run the reports. The reports include journal entries that have been distributed to PeopleSoft General Ledger.

Prerequisites

Before you run the statutory reports, you must:

Post vouchers and payments (PeopleSoft Payables statutory reports only).
Process employee expense reports and payments (PeopleSoft Expenses statutory reports only).
Run the Billing Load GL Accounting Entries process (BILDGL01) (PeopleSoft Receivables statutory reports only, if PeopleSoft Billing is installed).
Run the Receivable Update process (AR_UPDATE) (PeopleSoft Receivables statutory reports only).
Generate journal entries for the application accounting entries that you want to include in the reports by running the Journal Generator process.
Format the journal entries for the statutory reports and load them into the statutory reporting tables by running the Statutory Reports Loader.

Running the Statutory Reports Loader Process

The Statutory Reports Loader process extracts accounting transactions from PeopleSoft Expenses, Payables, Receivables, and Billing for the specified business unit and accounting period. It places the entries in the RPTG_DETAIL_TBL, RPTG_BALANCE, and RPTG_PERIOD tables. When you run the Statutory Reports Loader for the first time, the beginning balance is zero. For the first execution of this process set the year or period to the earliest period for which you have accounting transactions in the system. Any subsequent runs of the Statutory Reports Loader automatically update beginning balances from the previously processed data that is available in the statutory reporting tables.

This section discusses how to load Statutory Reports.

Page Used to Run the Statutory Reports Loader

Page Name	Object Name	Navigation	Usage
Statutory Reports - Report Request	REPORT_RQST_PNL	Statutory Reports, Extract Data for Reports, Statutory Reports, Report Request	Specify the General Ledger business unit and accounting period for which to load data into the statutory reporting tables.

Loading Statutory Reports (FS_FINRPTFS)

Access the Statutory Reports - Report Request page.

Reporting Application

Select the PeopleSoft reporting application for which you are generating statutory reports. The available values are Accounts Payable, Expenses, Accounts Receivable, or Billing.

Business Unit

Select business units to report on and to provide prompting for the from and to Vendor IDs on which you are reporting.

Note. You can specify multiple business units, but you cannot exclude vendor IDs in the middle a sequence for a particular business unit. Totals by vendor IDs are most useful when you have a general ledger business unit associated with multiple payables business units and each payables business unit has its own set of vendor IDs.

Running Statutory Reports

You can run Crystal or SQR reports that meet European statutory reporting requirements. If you are not located in Europe, you can also benefit from these reports, for example, by printing the balance by account or vendor information. Each time you run the reports, specify the information to include in the report. The default is to print the reports in the ledger base currency.

If you have both PeopleSoft Billing and PeopleSoft Receivables installed, remember to select and print transactions from both products onto one single report to see complete balances by customer or by Receivables account.

Note. You can use regular or alternate accounts when running many of these reports.

In Spain, fiscal authorities require a list of domestic vendors and customers with whom your company conducted transactions greater than a specified value. A company has to declare transactions larger than 3.005,06 euros. PeopleSoft enables you to create a file containing this information.

This section describes how to generate the Statutory Report 347 ESP.

Page Used to Generate the Spanish Statutory Report File

Page Name	Object Name	Navigation	Usage
Statutory Report 347 ESP	RUN_LC_CNTL	Statutory Reports, Statutory Report 347 ESP	Creates a file consisting of 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 transactions larger than 3.005,06 euros.

Generating Statutory Report 347 ESP File

Access the Statutory Report 347 ESP page.

Business Unit

Select the appropriate business unit that contains the transactions required for this report.

Fiscal Year

Select the fiscal year that corresponds to the Declaration Fiscal Year of the report.

From Period and To Period

Select a beginning and ending period to apply to the transactions for this report.

Media

Select the type of media for delivering this report: Disk, Tape, or Electronic Transmission.

Sales Quota Amt (sales quota amount)

Specify a minimum amount. The file includes a list of customers with whom the selected business unit conducts transactions greater than this value.

Purchase Quota

Specify a minimum amount. The file includes a list of vendors with whom the selected business unit conducts transactions greater than this value.

Declaration Type

Select one of the following:

Normal: Defines the submission of a regular report.

Complementary: Defines additional information to a previously submitted report.

Substitute: Replaces a previously submitted report. This selection requires you to enter the declaration number of the previously submitted report.

From and To

Enter account numbers that apply to the report's transactions.

Currency Code

Enter the currency for the submitted amount.

Contact Information

Enter one or more names and telephone numbers for the individuals in your organization responsible for submitting the report.

Business Unit	Select the appropriate business unit that contains the transactions required for this report.
Fiscal Year	Select the fiscal year that corresponds to the Declaration Fiscal Year of the report.
From Period and To Period	Select a beginning and ending period to apply to the transactions for this report.
Media	Select the type of media for delivering this report: Disk, Tape, or Electronic Transmission.
Sales Quota Amt (sales quota amount)	Specify a minimum amount. The file includes a list of customers with whom the selected business unit conducts transactions greater than this value.
Purchase Quota	Specify a minimum amount. The file includes a list of vendors with whom the selected business unit conducts transactions greater than this value.
Declaration Type	Select one of the following: Normal: Defines the submission of a regular report. Complementary: Defines additional information to a previously submitted report. Substitute: Replaces a previously submitted report. This selection requires you to enter the declaration number of the previously submitted report.
From and To	Enter account numbers that apply to the report's transactions.
Currency Code	Enter the currency for the submitted amount.
Contact Information	Enter one or more names and telephone numbers for the individuals in your organization responsible for submitting the report.