PeopleSoft Receivables Reports: A to Z

This table lists the PeopleSoft Receivables reports, sorted alphanumerically by report ID. The reports listed are Structured Query Reports (SQRs) and BI Publisher reports. If you need more information about a report, refer to the report details at the end of this appendix.

For samples of these reports, see the Report Samples that are published with this online documentation.

Report ID and Report Name Description Navigation Run Control Page

AR01001

System Function

Lists system functions. (SQR)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then List System Functions, and then System Functions

RUN_AR01001

AR01002

Entry Type/Entry Reason

Lists valid automatic entry information as of a specified effective date. (SQR)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then Entry Type Entry Reason, and then Entry Type Entry Reason

RUN_AR01002

AR01003

Auto Entry Type

Lists valid automatic entry information as of a specified effective date. (SQR)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then Auto Entry Type, and then Auto Entry Type

RUN_AR01003

AR01004

Item Entry Type

Lists valid item entry information as of a specified effective date. (SQR)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then Item Entry Type Report, and then Item Entry Type

RUN_AR01004

ARX01006

Predictor Method By Customer

Describes the Payment Predictor methods used at the customer level to override the business unit default method. The report lists each method used in this manner followed by a list of customers that use it. (BI Publisher)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then Predictor Method By Customer, and then Predictor Method By Customer

RUN_AR01006

ARX01007

Predictor Method by SetID

Contains the steps involved in the Payment Predictor method used as the default for the specified SetID. (BI Publisher)

Set Up Financial/Supply Chain, and then Product Related, and then Receivables, and then Reports, and then Predictor Method By TableSet, and then Predictor Method By TableSet

RUN_AR01007

AR11001

Group Control By Entry Date

Lists all group control records by entry date, shown in the entry currency. (SQR)

Accounts Receivable, and then Pending Items, and then Reports, and then Group Control By Entry Date, and then Group Control By Entry Date

RUN_AR11001

ARX11001P

Group Control for Business Unit

Lists all group control records by entry date, shown in the entry currency. Specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Pending Items, and then Reports, and then Group Control - Point in Time, and then Group Control - Point in Time

RUN_AR11001PIT

AR11002

Pending Item By Entry Date

Lists all pending items within a group, shown in either the business unit base currency or the entry currency. (SQR)

Accounts Receivable, and then Pending Items, and then Reports, and then Pending Item By Entry Date, and then Pending Item By Entry Date

RUN_AR11002

ARX11002P

Pending Items Within Group

Lists all pending items within a group, in either the business unit base currency or the entry currency. Specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Pending Items, and then Reports, and then Pending Item - Point in Time, and then Pending Item - Point in Time

RUN_AR11002P

ARX11003

Item Detail

Shows item detail by line item, accounting date, entry type, description, terms, due date, and amount. (BI Publisher)

Accounts Receivable, and then Pending Items, and then Reports, and then Item Detail, and then Item Detail

RUN_AR11003

ARX11003P

Item Detail by Due Date

Shows item detail by line item, accounting date, entry type, description, terms, due date, and amount. (BI Publisher)

Note: You must set up the contact information for a customer. This report does not display items if the customer contact information is not populated.

Accounts Receivable, and then Pending Items, and then Reports, and then Item Detail - Point in Time, and then Item Detail - Point in Time

RUN_AR11003PIT

AR11004

Actual Matches Report

Lists pending items that the Automatic Maintenance Application Engine process created and set to post. (SQR)

Accounts Receivable, and then Receivables Maintenance, and then Automatic Maintenance, and then Actual Matches Report, and then Actual Matches Report

RUN_AR11004

AR11005

Potential Matches Report

Lists new worksheet items that the Automatic Maintenance process placed on maintenance worksheets. (SQR)

Accounts Receivable, and then Receivables Maintenance, and then Automatic Maintenance, and then Potential Matches Report, and then Potential Matches Report

RUN_AR11005

AR20001

Deposit Summary

Lists detailed information for deposits, in either the business unit base currency or the entry currency. (SQR)

Accounts Receivable, and then Payments, and then Reports, and then Deposit Control by Entry Date, and then Deposit Control by Entry Date

RUN_AR20001

ARX20001P

Deposit Control

Lists detailed information for deposits, in either the business unit base currency or the entry currency. (BI Publisher)

Important: When you run this report and select the Base Curr (base currency) as the Amount Type and do not enter a control currency in the Deposit field, there is no basis to convert, which results in a blank Control Amount column.

Accounts Receivable, and then Payments, and then Reports, and then Deposit Control - Point in Time, and then Deposit Control - Point in Time

RUN_AR20001P

AR20002

Payment Detail

Lists detailed information for all payments within a deposit, in either the business unit base currency or the entry currency. The payment details are unavailable if the posting status is Not Posted. (SQR)

Accounts Receivable, and then Payments, and then Reports, and then Payment Detail, and then Payment Detail

RUN_AR20002

ARX20002P

Payment Detail

Lists detailed information for all payments within a deposit, in either the business unit base currency or the entry currency. Specify a point in time when you run the report. You must enter item references for each payment to have data in this report. (BI Publisher)

Accounts Receivable, and then Payments, and then Reports, and then Payment Detail - Point in Time, and then Payment Detail - Point in Time

RUN_AR20002P

AR20003

Payment Summary

Lists status for all payments within a deposit, in either the business unit base currency or the entry currency. (SQR)

Accounts Receivable, and then Payments, and then Reports, and then Payment Summary, and then Payment Summary

RUN_AR20003

ARX20003P

Payment Summary

Lists the status for all payments within a deposit, in either the business unit base currency or the entry currency. Specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Payments, and then Reports, and then Payment Summary - Point in Time, and then Payment Summary - Point in Time

RUN_AR20003P

AR20005

Receivables Activity Report

Lists each receivable with an associated write-off. (SQR)

Accounts Receivable, and then Receivables Update, and then Posting Results Upd Pend Items, and then Receivables Activity Report, and then Receivables Activity

RUN_AR20005

ARX20006

Form 1099–C Cancellation of Debt

Required by the Internal Revenue Service (IRS) in the United States to summarize how much debt has been written off for a specific customer. (BI Publisher)

See Generating the 1099-C Report.

Accounts Receivable, and then Receivables Update, and then Posting Results-Upd Pend Items, and then Receivables 1099C Submit

SUBMIT_AR_1099

AR21001

Payment Predictor Detail

Lists predicted payments. If a remit from SetID and customer are associated with the payment, it is listed. If more than one remit from SetID and customer are associated with the payment, only one is listed. (SQR)

Accounts Receivable, and then Payments, and then Reports, and then Payment Predictor Detail, and then Payment Predictor Detail

RUN_AR21001

AR21002

Payment Predictor Summary

Lists Payment Predictor results by status and predictor method and algorithm. The number of payments is listed as a percentage of total number of payments predicted. A summary at the end of the report provides the number of payments predicted, number of payments not predicted, and each as a percentage of the total. (SQR)

Accounts Receivable, and then Payments, and then Reports, and then Payment Predictor Summary, and then Payment Predictor Summary

RUN_AR21002

AR21003

Unmatched MICR Identifiers

Lists MICR identifiers that appear on payments and that you have not defined on the customer MICR ID table. The system derives possible business units and customers for each MICR by looking at the items to which the payment was applied. (SQR)

Accounts Receivable, and then Payment, and then Reports, and then Unmatched MICR Identifiers, and then Unmatched MICR Identifiers

RUN_AR21003

AR30001

Aging Detail by Tree

Lists aged base currency open balances for every item. It is sorted and summarized by looking at a tree structure that you define for business units, collectors, team members, or credit analysts. (SQR)

See Generating Aging Reports.

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging Detail by Tree Rpt, and then Aging Detail By Tree

RUN_AR30001

AR30002

Aging Summary by Tree

Lists aged base currency open balances for every customer, with the option to exclude interunit customers. It is sorted and summarized by looking at a tree structure that you define for business units, collectors, team members, or credit analysts. (SQR)

See Generating Aging Reports.

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging Summary by Tree Rpt, and then Aging Summary By Tree

RUN_AR30002

AR30003

Aging Detail by Business Unit

Lists aged open balances for every item, with the option to exclude interunit customers. Balances may be reported in entry or base currency. When the currency amount type is base currency, a rate type may be provided. When a rate type is provided, the applicable rates from the rate table are applied to the entry amounts on the open items, giving run-time generated base amounts. If no rate type is provided, the base item amounts are reported. (SQR)

See Generating Aging Reports.

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging Detail by Unit Rpt, and then Aging Detail By Unit

RUN_AR30003

AR30004

Aging Summary by Business Unit

Lists aged open balances for every customer. Balances may be reported in entry or base currency. When the currency amount type is base currency, a rate type is provided, the applicable rates are taken from the rate table and applied to the entered amounts on the open items, giving run-time generated base amounts. If no rate type is provided, the base item amounts are included in the customer balances. Select the entry currency to show subtotals by currency. (SQR)

See Generating Aging Reports.

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging Summary by Unit Rpt, and then Aging Summary By Unit

RUN_AR30004

AR30005

Cash Forecast

Lists base currency balances by customer, categorized by user-defined forecasting categories and rounded to the nearest dollar. Includes a grand total if specified business units use the same currency. (SQR)

See AR30005 - Cash Forecast Report.

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then Cash Forecast, and then Cash Forecast

RUN_AR30005

AR30006

Aging by Chartfield

Lists calculated aged receivables by customer, item and ChartField selection. Option to exclude interunit customers. (SQR)

See Generating Aging Reports.

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging by Chartfield Rpt, and then Aging By Chartfield

RUN_AR30006

AR30007

Aging by Reason

Shows a summarized total of all deductions, items in collection, or disputed items by reason in either the base currency of the unit or the entry currency. Select the entry currency to show subtotals by currency. (SQR)

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging by Reason Rpt, and then Run AR30007

RUN_AR30007

AR30009

Aging Detail by Department

Shows the age of open balances for all items in a given department, totaled by contract number and grouped by customer ID and business unit. Select the entry currency to show subtotals by currency. (SQR)

Accounts Receivable, and then Receivables Analysis, and then Aging, and then Aging by Department Report, and then Aging Detail By Department

RUN_AR30009

AR31001

TableSet Customers

Lists all customers and customer addresses within a TableSet. (SQR)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then Customers by SetID, and then Customers By SetID

RUN_AR31001

AR31002

Business Unit Customers

Lists all customers and customer addresses within a business unit. (SQR)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then Customers by Unit, and then Customers By Unit

RUN_AR31002

AR31003

TableSet Contacts

Lists all customers and customer contacts within a TableSet. (SQR)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then Contacts by SetID, and then Contacts By SetID

RUN_AR31003

AR31004

Business Unit Contacts

Lists all customers and customer contacts within a business unit. (SQR)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then Contacts by Unit, and then Contacts By Unit

RUN_AR31004

AR_AR32X000

Collections Workbench Statement Image

Same as ARX32000S, ARX32001, and ARX32002. This statement image is generated for the Collections Workbench.

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Customer Statements

RUN_AR32001

ARX32A00

Open Item Statement (NLD)

A customer statement model for the Netherlands that includes the acceptgiro attachment, which you can modify as necessary. It lists all open items for the customer, the total amount open, and an aging of open items. Options to print separate reports by contract number, or to print individual invoices and consolidated invoices together on the report. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Print Statements, and then Statement Print

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Customer Statements

RUN_AR32000

RUN_AR32001

ARX32A01

Balance Forward Statements (with acceptgiro) (NLD)

Customer Statement model for the Netherlands that includes an acceptgiro attachment, which you can modify as necessary. It lists all new items and payments in the current statement period, balance forward amount or ending amount from the previous statement, and the ending balance for the current statement period. Option to print individual invoices and consolidated invoices together on the report. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Print Statements, and then Statement Print

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Customer Statements

RUN_AR32000

RUN_AR32001

ARX32000

ARX32000S

Customer Statement Print

A customer statement model that you can modify as necessary. It lists all open items for the customer, the total amount open, and an aging of open items. Options to print separate reports by contract number, or to print individual invoices and consolidated invoices together on the report. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Print Statements, and then Statement Print

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Customer Statements

RUN_AR32000

RUN_AR32001

ARX32001

Balance Forward Statement

Customer Statement model that you may modify as necessary. It lists all new items and payments in the current statement period, balance forward amount or ending amount from the previous statement, and the ending balance for the current statement period. Option to print individual invoices and consolidated invoices together on the report. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Print Statements, and then Statement Print

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Customer Statements

RUN_AR32000

RUN_AR32001

ARX32002

Draft Customer Statement

The same as ARX32000/ARX32000S but in addition it lists the items that are closed but are in an open draft (accepted drafts that have not been collected). Option to print individual invoices and consolidated invoices together on the report. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Print Statements, and then Statement Print

RUN_AR32000

ARX32100

Draft Statement

Lists the items that are in a draft. (BI Publisher)

Accounts Receivable, and then Drafts, and then Reports, and then Draft Statement, and then Draft Statement

RUN_AR32100

ARX32101

Draft Document

Includes the actual draft document for drafts that you have created, but have not been preapproved. (BI Publisher)

Accounts Receivable, and then Drafts, and then Reports, and then Draft Documents, and then Draft Documents

RUN_AR32101

AR32102

Draft Summary by Customer

Lists the drafts that are still unpaid by the customer by the due date for a specified date range. (SQR)

Accounts Receivable, and then Drafts, and then Reports, and then Draft Reports, and then Draft Reports

RUN_AR32102

AR32103

Request Form for Drafts

Creates a form that can be submitted to a bank to show drafts that need to be discounted or collected. (SQR)

Accounts Receivable, and then Drafts, and then Reports, and then Remittance/Discount Form, and then Remittance/Discount Form

RUN_AR32103

ARX32104

Dishonored Drafts

Lists all drafts that have a Dishonored status. (BI Publisher)

Accounts Receivable, and then Drafts, and then Reports, and then Dishonor Activity, and then Dishonor Activity

DRAFT_RUN_ARDISH01

ARX3210X

EFT Draft Inbound Exception Report

List drafts that processed successfully and errors for draft remittance files sent by the bank. (BI Publisher)

Accounts Receivable, and then Drafts, and then Reports, and then Draft Remit Exceptions Report

EFT_DR_EXCEPT

ARX33000

All Levels Dunning Letter

A dunning letter model that you may modify as necessary. It contains all past due items regardless of their age. The text that prints before the open items depends on your specifications on the Dunning Letter - Parameters page. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

(NLD) ARX33A00

All Levels Dunning Letter (with acceptgiro)

A dunning letter model for the Netherlands that includes an acceptgiro attachment, which you can modify as necessary. It contains all past due items regardless of their age. The text that prints before the open items depends on your specifications on the Dunning Letter - Parameters page. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

ARX33001

Level 1 Dunning Letter

Dunning letter model that you may modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level one. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33001

(NLD) ARX33A01

Level 1 Dunning Letter (with acceptgiro)

Dunning letter model for the Netherlands that includes the acceptgiro attachment, which you can modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level one. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33001

ARX33002

Level 2 Dunning Letter

Dunning letter model that you may modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level two. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

(NLD) ARX33A02

Level 2 Dunning Letter (with acceptgiro)

Dunning letter model for the Netherlands that includes an acceptgiro attachment, which you can modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level two. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

ARX33003

Level 3 Dunning Letter

A dunning letter model that you may modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level three. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

(NLD) ARX33A03

Level 3 Dunning Letter (with acceptgiro)

A dunning letter model for the Netherlands that includes an acceptgiro attachment, which you can modify as necessary. As delivered with the system, this letter includes only items in the age range for dunning level three. Can be set up to print separate letters by contract number. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

ARX33004

Customer Follow Up Letter

Generates a letter that contains the text that you define. Enter parameters to process all customers in one business unit or in multiple business units, or an individual customer. The system generates a letter for each customer that contains a follow-up letter code on the Conversations page for the customer. (BI Publisher)

See Generating and Printing Follow-Up Letters.

Accounts Receivable, and then Customer Interactions, and then Customer Follow-Up Letter, and then Customer Follow Up Letter

RUN_AR33004

ARX33005

Dunning Letter Control

Shows the dunning letters that were printed from all dunning runs. For example, use to see which letter was last sent to a customer. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

ARX33006

Dunning Letter Preview Report

Provides a preview of which dunning letters will print. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Dunning Letters, and then Print Letter, and then Dunning Letter Print

RUN_AR33000

ARX34001

AR/AP Balance by Customer

Lists all open vouchers for each supplier ID that corresponds to the selected customer ID. It also lists all items for the customer. The vouchers are grouped by supplier ID, by Payables business unit within supplier and currency within Payables business unit. (BI Publisher)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then AR/AP Balance by Customer, and then AR_AP Balance by Customer

RUN_AR34001

ARX34002

AR/AP Balances by SetID

Lists all open vouchers for each supplier ID that corresponds to all customer IDs within the selected SetID. It also lists all items for the customer. The vouchers are grouped by supplier ID, Payables business unit within supplier and currency within Payables business unit. (BI Publisher)

Accounts Receivable, and then Customer Accounts, and then Customer Reports, and then AR/AP Balance by SetID, and then AR_AP Balance by TableSet

RUN_AR34002

ARX34003

Customer Item Inquiry

Lists detailed item information by customer, including entry type, balance, reference, dispute, terms, and discount date. (BI Publisher)

Accounts Receivable, and then Customer Accounts, and then Item Information, and then Item List, and then Item List

Select Generate an Open Item Report in the Item Action field and click Go on the Item List page.

ITEM_LIST

ARX34004

Unrealized Gain and Losses by Doubtful Items from Revaluation Process

Lists doubtful items that have unrealized gain or loss after running the Revaluation Application Engine process (AR_REVAL). (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Revaluation, and then Unreal Gain Doubtful Items, and then Unrealized Gain and Losses by Doubtful Items from Revaluation Process

RUN_AR34004

AR34006

Memo Status Changes

Lists any memo status code and the operator ID for any changed memo status. (SQR)

Accounts Receivable, and then Customer Accounts, and then Item Information, and then Memo Status Change Report, and then Memo Status Changes

RUN_AR34006

ARX35000

Overdue Charge Print

An overdue or finance charge invoice model that you may modify as necessary. (BI Publisher)

Accounts Receivable, and then Customer Interactions, and then Overdue Charges, and then Print Overdue Charges, and then Overdue Charge Print

RUN_AR35000

ARX37501

Direct Debit Remittance Advice

Generates the direct debit remittance advice to send to the bank. (BI Publisher)

Accounts Receivable, and then Direct Debits, and then Administer Direct Debits, and then Update Direct Debits Worksheet

Click the Print icon on the Worksheet page.

RUN_AR37501

ARX3750X

EFT Direct Debit Inbound Exception Report

After the system has processed the bank remittance file sent by the bank, use to see if a direct debit was processed successfully or if an inbound exception was found. (BI Publisher)

Accounts Receivable, and then Direct Debits, and then Remit to Bank, and then Bank Remit Exception Report, and then Bank Remit Exception Report

EFT_DD_EXCEPT

AR50001

Accounting Entries

Shows detailed accounting entry information by accounting date in the business unit base currency. Lists accounting line information at either a detail or summary level. Detail shows all ChartField activity, summary level summarizes by ChartField (one line for each ChartField combination). (SQR)

  • Accounts Receivable, and then Payments, and then Reports, and then Payment Accounting Entries, and then Accounting Entries

  • Accounts Receivable, and then Drafts, and then Reports, and then Draft Acctg Entries by Date, and then Accounting Entries

  • Accounts Receivable, and then Pending Items, and then Reports, and then Item Accounting Entries, and then Accounting Entries

RUN_AR50001

ARX50001P

Receivables Accounting Entries

Shows detailed accounting entry information by accounting date in the business unit base currency. It shows accounting line information at the detail level, including all ChartField activity. You specify a point in time when you run the report. (BI Publisher)

  • Accounts Receivable, and then Payments, and then Reports, and then Acctg Entries - Point in Time, and then Accounting Entries - Point in Time

  • Accounts Receivable, and then Pending Items, and then Reports, and then Item Acctg Entries by Date

RUN_AR50001PIT

ARX50002P

Receivables Accounting Entries - Summary by Accounting Date

Shows summarized accounting entry information by accounting date, in the business unit base currency. It shows one line for each ChartField for each accounting date. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Pending Items, and then Reports, and then Item Acctg Entries by Date

RUN_AR50001PIT

AR60001

Unit Activity

Shows a summarized picture of system activity. Presents the information in different ways depending on the sort options you select. The report always shows a beginning balance for a business unit, but it summarizes the activity for the period by entry type, entry type and entry reason, group type and origin, or activity and origin. (SQR)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity, and then Unit Activity

RUN_AR60001

ARX60001P

Item Activity by Entry Type

Shows a picture of business unit activity for a selected date range summarized by entry type and reason code. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity - PIT, and then Unit Activity - Point in Time

RUN_AR60001P

ARX60002P

Item Activity by Group Type/Origin

Shows a picture of business unit activity for a selected date range summarized by group type and origin ID. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity - PIT, and then Unit Activity - Point in Time

RUN_AR60001PIT

ARX60003P

Item Activity by Entry Type/Reason

Shows a picture of business unit activity for a selected date range summarized by entry type and reason. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity - PIT, and then Unit Activity - Point in Time

RUN_AR60001PIT

ARX60004P

Item Activity by Activity Type

Shows a picture of business unit activity for a selected date range summarized by activity type, such as Billing or Cash Applied. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity - PIT, and then Unit Activity - Point in Time

RUN_AR60001PIT

ARX60005P

Item Activity by Activity Type/Origin

Shows a picture of business unit activity for a selected date range summarized by activity type, such as Billing or Cash Applied, and origin ID. You specify a point in time when you run the report. (BI Publisher)

Accounts Receivable, and then Receivables Analysis, and then Receivables Reports, and then Business Unit Activity - PIT, and then Unit Activity - Point in Time

RUN_AR60001PIT

ARX70001

Pending Item Archive Candidates

Lists the pending item archive candidates. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Pending Candidate Report, and then Pending Archive Candidates

RUN_AR70001

ARX70002

Payment Archive Candidates

Lists the payment archive candidates. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Payment Candidate Report, and then Payment Archive Candidates

RUN_AR70002

ARX70003

Item Archive Candidates

Lists the closed item archive candidates. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Item Candidate Report, and then Item Archive Candidates

RUN_AR70003

ARX70004

Statement Archive Candidates

Lists customer statements that are candidates to be archived. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Statement Candidate Report, and then Statement Archive Candidates

RUN_AR70004

ARX70005

Action List Archive Candidates

Lists item and customer actions that are candidates to be archived. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Action List Candidate Report, and then Action List Candidate Report

RUN_AR70005

ARX70006

Direct Debit Archive Candidate

Lists direct debits that are candidates to be archived. (BI Publisher)

Accounts Receivable, and then Receivables Update, and then Archive Receivables, and then Direct Debit Candidate Report, and then Direct Debit Archive Candidate

RUN_AR70006

ARCMCHCK

Action Status by Owner

Provides the total number of actions open, completed, and canceled for each action owner during the reporting period. (SQR)

Accounts Receivable, and then Customer Interactions, and then Actions, and then Action Status by Owner Rpt, and then Action Status by Owner Rpt

RUN_ARCMCHCK

ARCMCUST

Condition Status by Owner and Customer

Provides the total number of open, completed, and canceled actions for each action owner during the reporting period. The report is sorted by customer and condition. (SQR)

Accounts Receivable, and then Customer Interactions, and then Actions, and then Condition Status by Owner Rpt, and then Condition Status by Owner Rpt

RUN_ARCMCUST

AR_TROR_XML

Treasury Report on Receivables

U.S. Department of Treasury's means for periodically collecting data on the status and condition of the federal government's non-tax debt portfolio. Uses the TROR Application Engine process (AR_TROR_XML).

See Understanding Generating the TROR and Debt Collection Activities.

Accounts Receivable, and then Receivables Update, and then Posting Results - Upd Pend Items, and then Treasury Report on Receivables, and then Preparer

RUN_SF220_1

ARSTFED

Federal Customer Statements

Contains customer summary information that shows the amount billed, earned, and collected for each customer. Also contains reimbursable details for each customer that is determined by gathering information from PeopleSoft General Ledger, PeopleSoft Contracts, and PeopleSoft Receivables. (PSJob)

Accounts Receivable, and then Customer Interactions, and then Statements, and then Create Federal Statements, and then Statement Parameters

FEDERAL_CUST_STMT

ARXCUSTCONV

Customer Conversations

Contains a list of customer conversations by conversation date, including conversation description, conversation entered by, and comments.

  • Accounts Receivable, and then Customer Interactions, and then Conversations, and then Customer Conversations Report, and then Customer Conversations

  • Accounts Receivable, and then Collections Workbench

    Click the Conversations tab then the Conversations Report link.

  • Accounts Receivable, and then Receivables WorkCenter, and then Reports/Queries

    Click the Customer Conversations Report link on the Reports/Processes pagelet.

RUN_ARXCUSTCONVER

ARXPRINTRT

Miscellaneous Cash Receipt

Creates a cash receipt for a payment when the Deposit Type is Miscellaneous Receipts, with manually entered receipt information. (BI Publisher)

Accounts Receivable, and then Payments, and then Online Payments, and then Regular Deposit, and then Payments

Click the Receipts link.

PAY_RECEIPT_AR

FSX2025

EFT File Cover Sheet

Creates a cover letter that you can send with the electronic funds transfer (EFT) file for all drafts or direct debits associated with a business unit that have a Remitted status. (BI Publisher)

Accounts Receivable, and then Drafts, and then Remit Drafts to Bank, and then Create EFT Payment Cover Sheet, and then Create EFT File Cover Sheet

RUN_FIN2025

See also the product documentation for PeopleTools: PeopleSoft Process Scheduler.