(USF) Creating Federal Customer Statements

Page Name

Definition Name

Usage

Create Federal Statements Page

FEDERAL_CUST_STMT

Enter the run control parameters for the Federal Customer Statements multiprocess job that creates federal customer statements.

The Federal Customer Statements report is used internally by the federal government to track agreements between federal government agencies. This feature gathers information from the PeopleSoft General Ledger, PeopleSoft Receivables, and PeopleSoft Contracts systems to produce the Federal Customer Statements report.

To create federal statements, run the Federal Customer Statements multiprocess job (ARSTFED), which includes:

  • The AR_FED_STMTS Application Engine process, which merges information from the PeopleSoft General Ledger and PeopleSoft Contract systems with PeopleSoft Receivables data and updates these tables:

    • Reimbursable Agreements Federal Statement table (PS_FEDST_TBL_RA), which stores information from PeopleSoft General Ledger and PeopleSoft Contracts for reimbursable agreements.

    • PeopleSoft Receivables Federal Statement table (PS_FEDST_TBL_AR), which contains customer-related information for the period that the report is run.

  • The Federal Customer Statements report (ARX80019).

If a customer has reimbursable activity and nonreimbursable activity, the report displays summary totals for both.

Before creating federal customer statements:

  1. Enable the Federal Customer feature on the General Info page for the customer.

  2. Enable the Federal Reimbursable Agreement feature on the Installation Options - Contracts page.

  3. Set up the account mappings on the Reimbursable Agreement Account page.

Note: If you do not have PeopleSoft General Ledger or PeopleSoft Contracts installed on your system, disable the products on the Installed Products page to ensure that the reports show correct information.

Use the Create Federal Statements page (FEDERAL_CUST_STMT) to enter the run control parameters for the Federal Customer Statements multiprocess job (ARSTFED) that creates federal customer statements.

Navigation:

Accounts Receivable > Customer Interactions > Statements > Create Federal Statements > Create Federal Statements

Field or Control

Description

Unit

Enter a business unit to create statements for all customers with transactions in a specific business unit. If you leave this field blank, a default business unit will automatically appear in the field.

From Date and To Date

Enter a date range for the accounting date of items that are included in the statement activity. The dates determine the fiscal year and accounting periods used to select information from PeopleSoft General Ledger.

SetID

Select a SetID or accept the default SetID. If you leave this field blank, a default SetID will automatically appear in the field.

Customer

Enter only a customer ID to create statements for the specified customer. If you select a customer who is part of a correspondence group, the system addresses the statement to the correspondence customer, but includes only the specified customer's information.

Correspondence Customer

Enter only the customer ID for a correspondence customer to create statements for all customers in the correspondence group.

Project

Optionally, enter a project ID that is associated with a reimbursable agreement to include information only for customers that have reimbursable activity for that project.

Provide more than one parameter to tailor statements even further. The following table describes the results of combining different parameters. It assumes that a parameter in the left column is combined with one or more parameters to the right of that parameter:

Parameter

SetID

Business Unit

Customer ID

Business Unit

One statement for each correspondence customer in the business unit.

Not applicable (NA)

NA

Customer ID

A single statement for the customer. If the customer is part of a correspondence customer group, the process addresses the statement to the correspondence customer but includes only items that are for the specified customer.

A single statement for the customer, containing only items in the business unit. If the customer is part of a correspondence customer group, the process addresses the statement to the correspondence customer but includes only items for the specified customer.

NA

Correspondence Customer

A single statement, for the correspondence customer, containing items for all customers in the correspondence group.

A single statement for the correspondence customer, containing items in the business unit for all customers in the correspondence group.

A single statement that is addressed to the correspondence customer, containing only items for the specified customer.