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.
|
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
|---|---|---|---|
|
AR01001 System Function |
Lists system functions. (SQR) |
|
RUN_AR01001 |
|
AR01002 Entry Type/Entry Reason |
Lists valid automatic entry information as of a specified effective date. (SQR) |
|
RUN_AR01002 |
|
AR01003 Auto Entry Type |
Lists valid automatic entry information as of a specified effective date. (SQR) |
|
RUN_AR01003 |
|
AR01004 Item Entry Type |
Lists valid item entry information as of a specified effective date. (SQR) |
|
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) |
|
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) |
|
RUN_AR01007 |
|
AR11001 Group Control By Entry Date |
Lists all group control records by entry date, shown in the entry currency. (SQR) |
|
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) |
|
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) |
|
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) |
|
RUN_AR11002P |
|
ARX11003 Item Detail |
Shows item detail by line item, accounting date, entry type, description, terms, due date, and amount. (BI Publisher) |
|
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. |
|
RUN_AR11003PIT |
|
AR11004 Actual Matches Report |
Lists pending items that the Automatic Maintenance Application Engine process created and set to post. (SQR) |
|
RUN_AR11004 |
|
AR11005 Potential Matches Report |
Lists new worksheet items that the Automatic Maintenance process placed on maintenance worksheets. (SQR) |
|
RUN_AR11005 |
|
AR20001 Deposit Summary |
Lists detailed information for deposits, in either the business unit base currency or the entry currency. (SQR) |
|
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. |
|
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) |
|
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) |
|
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) |
|
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) |
|
RUN_AR20003P |
|
AR20005 Receivables Activity Report |
Lists each receivable with an associated write-off. (SQR) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
RUN_AR30005 |
|
AR30006 Aging by Chartfield |
Lists calculated aged receivables by customer, item and ChartField selection. Option to exclude interunit customers. (SQR) |
|
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) |
|
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) |
|
RUN_AR30009 |
|
AR31001 TableSet Customers |
Lists all customers and customer addresses within a TableSet. (SQR) |
|
RUN_AR31001 |
|
AR31002 Business Unit Customers |
Lists all customers and customer addresses within a business unit. (SQR) |
|
RUN_AR31002 |
|
AR31003 TableSet Contacts |
Lists all customers and customer contacts within a TableSet. (SQR) |
|
RUN_AR31003 |
|
AR31004 Business Unit Contacts |
Lists all customers and customer contacts within a business unit. (SQR) |
|
RUN_AR31004 |
|
AR_AR32X000 Collections Workbench Statement Image |
Same as ARX32000S, ARX32001, and ARX32002. This statement image is generated for the Collections Workbench. |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
RUN_AR32000 |
|
ARX32100 Draft Statement |
Lists the items that are in a draft. (BI Publisher) |
|
RUN_AR32100 |
|
ARX32101 Draft Document |
Includes the actual draft document for drafts that you have created, but have not been preapproved. (BI Publisher) |
|
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) |
|
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) |
|
RUN_AR32103 |
|
ARX32104 Dishonored Drafts |
Lists all drafts that have a Dishonored status. (BI Publisher) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
RUN_AR33000 |
|
ARX33006 Dunning Letter Preview Report |
Provides a preview of which dunning letters will print. (BI Publisher) |
|
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) |
|
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) |
|
RUN_AR34002 |
|
ARX34003 Customer Item Inquiry |
Lists detailed item information by customer, including entry type, balance, reference, dispute, terms, and discount date. (BI Publisher) |
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) |
|
RUN_AR34004 |
|
AR34006 Memo Status Changes |
Lists any memo status code and the operator ID for any changed memo status. (SQR) |
|
RUN_AR34006 |
|
ARX35000 Overdue Charge Print |
An overdue or finance charge invoice model that you may modify as necessary. (BI Publisher) |
|
RUN_AR35000 |
|
ARX37501 Direct Debit Remittance Advice |
Generates the direct debit remittance advice to send to the bank. (BI Publisher) |
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
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) |
|
RUN_AR60001PIT |
|
ARX70001 Pending Item Archive Candidates |
Lists the pending item archive candidates. (BI Publisher) |
|
RUN_AR70001 |
|
ARX70002 Payment Archive Candidates |
Lists the payment archive candidates. (BI Publisher) |
|
RUN_AR70002 |
|
ARX70003 Item Archive Candidates |
Lists the closed item archive candidates. (BI Publisher) |
|
RUN_AR70003 |
|
ARX70004 Statement Archive Candidates |
Lists customer statements that are candidates to be archived. (BI Publisher) |
|
RUN_AR70004 |
|
ARX70005 Action List Archive Candidates |
Lists item and customer actions that are candidates to be archived. (BI Publisher) |
|
RUN_AR70005 |
|
ARX70006 Direct Debit Archive Candidate |
Lists direct debits that are candidates to be archived. (BI Publisher) |
|
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) |
|
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) |
|
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. |
|
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) |
|
FEDERAL_CUST_STMT |
|
ARXCUSTCONV Customer Conversations |
Contains a list of customer conversations by conversation date, including conversation description, conversation entered by, and comments. |
|
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) |
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) |
|
RUN_FIN2025 |
See also the product documentation for PeopleTools: PeopleSoft Process Scheduler.