Receivables Reports

Appendix: Receivables Reports

This appendix provides an overview of Receivables reports and enables you to:

View summary tables of all reports.
View report details.

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

Receivables Reports: A to Z

This table lists the Receivables reports, sorted alphanumerically by report ID. The reports listed are Structured Query Reports (SQRs) and Crystal 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)	Set Up Financial/Supply Chain, Product Related, Receivables, Reports, System Functions, 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, Product Related, Receivables, Reports, Entry Type Entry Reason, 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, Product Related, Receivables, Reports, Auto Entry Type, 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, Product Related, Receivables, Reports, Item Entry Type, Item Entry Type	RUN_AR01004
AR01006 Payment Predictor Method Report 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. (Crystal)	Set Up Financial/Supply Chain, Product Related, Receivables, Reports, Predictor Method By Customer, Predictor Method By Customer	RUN_AR01006
AR01007 Payment Predictor Methods by SetID	Contains the steps involved in the Payment Predictor method used as the default for the specified setID. (Crystal)	Set Up Financial/Supply Chain, Product Related, Receivables, Reports, Predictor Method By TableSet, 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, Pending Items, Reports, Group Control By Entry Date, Group Control By Entry Date	RUN_AR11001
AR11001P 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. (Crystal)	Accounts Receivable, Pending Items, Reports, Group Control - Point in Time, 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, Pending Items, Reports, Pending Item By Entry Date, Pending Item By Entry Date	RUN_AR11002
AR11002P AR 11002 Pending Items	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. (Crystal)	Accounts Receivable, Pending Items, Reports, Pending Item - Point in Time, Pending Item - Point in Time	RUN_AR11002P
AR11003 Item Detail	Shows item detail by line item, accounting date, entry type, description, terms, due date, and amount. (Crystal)	Accounts Receivable, Pending Items, Reports, Item Detail, Item Detail	RUN_AR11003
AR11003P Item Detail by Due Date	Shows item detail by line item, accounting date, entry type, description, terms, due date, and amount. (Crystal) 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, Pending Items, Reports, Item Detail - Point in Time, 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, Receivables Maintenance, Automatic Maintenance, Actual Matches Report, 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, Receivables Maintenance, Automatic Maintenance, Potential Matches Report, 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, Payments, Reports, Deposit Control by Entry Date, Deposit Control by Entry Date	RUN_AR20001
AR20001P Deposit Control	Lists detailed information for deposits, in either the business unit base currency or the entry currency. (Crystal)	Accounts Receivable, Payments, Reports, Deposit Control - Point in Time, 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, Payments, Reports, Payment Detail, Payment Detail	RUN_AR20002
AR20002P 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. (Crystal)	Accounts Receivable, Payments, Reports, Payment Detail - Point in Time, 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, Payments, Reports, Payment Summary, Payment Summary	RUN_AR20003
AR20003P 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. (Crystal)	Accounts Receivable, Payments, Reports, Payment Summary - Point in Time, Payment Summary - Point in Time	RUN_AR20003P
AR20005 Receivable Activity Report	Lists each receivable with an associated write off. (Crystal)	Accounts Receivable, Receivables Update, Posting Results Upd Pend Items, Receivables Activity Report, Receivables Activity	RUN_AR20005
AR20006 1099-C Form for Cancelled Debt	This form is required by the Internal Revenue Service in the U.S. to summarize how much debt has been cancelled, that is written off and all collection attempts completed without success. (Crystal)	Accounts Receivable, Receivables Update, Posting Results Upd Pend Items, Receivables 1099-c Report, Receivables 1099-c	RUN_AR20006
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, Payments, Reports, Payment Predictor Detail, 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, Payments, Reports, Payment Predictor Summary, 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, Payment, Reports, Unmatched MICR Identifiers, 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, Receivables Analysis, Aging, Aging Detail by Tree Rpt, Aging Detail By Tree	RUN_AR30001
AR30002 Aging Summary by Tree	Lists aged base currency open balances for every customer. 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, Receivables Analysis, Aging, Aging Summary by Tree Rpt, Aging Summary By Tree	RUN_AR30002
AR30003 Aging Detail by Business Unit	Lists aged open balances for every item. 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, Receivables Analysis, Aging, Aging Detail by Unit Rpt, 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. (SQR) See Generating Aging Reports.	Accounts Receivable, Receivables Analysis, Aging, Aging Summary by Unit Rpt, 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, Customer Accounts, Customer Reports, Cash Forecast, Cash Forecast	RUN_AR30005
AR30006 Aging by Chartfield	Lists calculated aged receivables by customer, item and ChartField selection. (SQR) See Generating Aging Reports.	Accounts Receivables, Receivables Analysis, Aging, Aging by Chartfield Rpt, Aging By Chartfield	RUN_AR30006
AR30007 Summary Aged Report by Reason Code	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. (SQR) See Generating Aging Reports.	Accounts Receivable, Receivables Analysis, Aging, Aging by Reason Rpt, Run AR30007	RUN_AR30007
AR31001 TableSet Customers	Lists all customers and customer addresses within a TableSet. (SQR)	Accounts Receivable, Customer Accounts, Customer Reports, Customers by SetID, Customers By SetID	RUN_AR31001
AR31002 Business Unit Customers	Lists all customers and customer addresses within a business unit. (SQR)	Accounts Receivable, Customer Accounts, Customer Reports, Customers by Unit, Customers By Unit	RUN_AR31002
AR31003 TableSet Contacts	Lists all customers and customer contacts within a TableSet. (SQR)	Accounts Receivable, Customer Accounts, Customer Reports, Contacts by SetID, Contacts By SetID	RUN_AR31003
AR31004 Business Unit Contacts	Lists all customers and customer contacts within a business unit. (SQR)	Accounts Receivable, Customer Accounts, Customer Reports, Contacts by Unit, Contacts By Unit	RUN_AR31004
AR32000 Open Item Statement	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. (Crystal)	Accounts Receivable, Customer Interactions, Statements, Print Statements, Statement Print	RUN_AR32000
(NLD) AR32A00 Open Item Statement	A customer statement model 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. (Crystal)	Accounts Receivable, Customer Interactions, Statements, Print Statements, Statement Print	RUN_AR32000
AR32001 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. (Crystal)	Accounts Receivable, Customer Interactions, Statements, Print Statements, Statement Print	RUN_AR32000
(NLD) AR32A01 Balance Forward Statement	Customer Statement model 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. (Crystal)	Accounts Receivable, Customer Interactions, Statements, Print Statements, Statement Print	RUN_AR32000
AR32002 Open Item Draft Statement	The same as AR32000 but in addition it lists the items that are closed but are in an open draft (accepted drafts that have not been collected). (Crystal)	Accounts Receivable, Customer Interactions, Statements, Print Statements, Statement Print	RUN_AR32000
AR32100 Draft Statement	Lists the items that are in a draft. (Crystal)	Accounts Receivable, Drafts, Reports, Draft Statement, Draft Statement	RUN_AR32100
AR32101 Draft Document	Includes the actual draft document for drafts that you have created, but have not been preapproved. (Crystal)	Accounts Receivable, Drafts, Reports, Draft Documents, 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, Drafts, Reports, Draft Reports, 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, Drafts, Reports, Remittance/Discount Form, Remittance/Discount Form	RUN_AR32103
AR32104 Dishonored Drafts	Lists all drafts that have a Dishonored status. (Crystal)	Accounts Receivable, Drafts, Reports, Dishonor Activity, Dishonor Activity	DRAFT_RUN_ARDISH01
AR3210X EFT Draft Inbound Exception Report	List drafts that processed successfully and errors for draft remittance files sent by the bank. (Crystal)	Accounts Receivable, Drafts, Reports, Bank Remit Exception Report	EFT_DR_EXCEPT
AR33000 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
(NLD) AR33A00 All Levels Dunning Letter	A dunning letter model 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
AR33001 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33001
(NLD) AR33A01 Level 1 Dunning Letter	Dunning letter model 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33001
AR33002 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
(NLD) AR33A02 Level 2 Dunning Letter	Dunning letter model 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
AR33003 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
(NLD) AR33A03 Level 3 Dunning Letter	A dunning letter model that includes a dunning letter 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. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
AR33004 Customer Follow Up Letter	Letter that contains the text that you define. The system generates a letter for each customer that contains a follow-up letter code on the Conversation page for the customer. (Crystal) See Generating and Printing Follow-Up Letters.	Accounts Receivable, Customer Interactions, Customer Follow-Up Letter, Customer Follow Up Letter	RUN_AR33004
AR33005 Dunning Letter Control Report	Shows the dunning letters that were printed from all dunning runs. For example, use to see which letter was last sent to a customer. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
AR33006 Dunning Letter Preview Report	Provides a preview of which dunning letters will print. (Crystal)	Accounts Receivable, Customer Interactions, Dunning Letters, Print Letter, Dunning Letter Print	RUN_AR33000
AR34001 AR/AP Balance by Customer	Lists all open vouchers for each vendor ID that corresponds to the selected customer ID. It also lists all items for the customer. The vouchers are grouped by vendor ID, by payables business unit within vendor and currency within payables business unit. (Crystal)	Accounts Receivable, Customer Accounts, Customer Reports, AR/AP Balance by Customer, AR_AP Balance by Customer	RUN_AR34001
AR34002 AR/AP Balances by SetID	Lists all open vouchers for each vendor ID that corresponds to all customer IDs within the selected SetID. It also lists all items for the customer. The vouchers are grouped by vendor ID, payables business unit within vendor and currency within payables business unit. (Crystal)	Accounts Receivable, Customer Accounts, Customer Reports, AR/AP Balance by SetID, AR_AP Balance by TableSet	RUN_AR34002
AR34003 AR Customer Item Inquiry	Lists detailed item information by customer, including entry type, balance, reference, dispute, terms, and discount date. (Crystal)	Accounts Receivable, Customer Accounts, Item Information, Item List, Item List Select Generate an Open Item Report in the Item Action field and click Go on the Item List page.	ITEM_LIST
AR34004 Unrealized Gains by Doubtful Items from Revaluation Process	Lists doubtful items that have unrealized gain or loss after running the Revaluation Application Engine process (AR_REVAL). (Crystal)	Accounts Receivable, Receivables Update, Revaluation, Unreal Gain Doubtful Items, Unreal Gain Doubtful Items	RUN_AR34004
AR34006 Memo Status Changes	Lists any memo status code and the operator ID for any changed memo status. (SQR) See (USF) Tracking Memo Status Changes.	Accounts Receivable, Customer Accounts, Item Information, Memo Status Change Report, Memo Status Changes	RUN_AR34006
AR35000 Finance Charge Invoice	An overdue charge invoice model that you may modify as necessary. (Crystal)	Accounts Receivable, Customer Interactions, Overdue Charges, Print Overdue Charges, Overdue Charge Print	RUN_AR35000
AR3750X EFT Direct Debit 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 exception was found. (Crystal)	Accounts Receivable, Direct Debits, Remit to Bank, Bank Remit Exception Report, 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, Payments, Reports, Accounting Entries, Accounting Entries Accounts Receivables, Drafts, Reports, Accounting Entries, Accounting Entries Accounts Receivable, Pending Items, Reports, Accounting Entries, Accounting Entries	RUN_AR50001
AR50001P 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. (Crystal)	Accounts Receivable, Payments, Reports, Acctg Entries - Point in Time, Accounting Entries - Point in Time Accounts Receivable, Pending Items, Reports, Acctg Entries - Point in Time, Accounting Entries - Point in Time	RUN_AR50001PIT
AR50002P 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. (Crystal)	Accounts Receivable, Pending Items, Reports, Accting Entries - Point in Time, Accounting Entries - Point in Time	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, Receivables Analysis, Receivables Reports, Business Unit Activity, Unit Activity	RUN_AR60001
AR60001P Item Activities 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. (Crystal)	Accounts Receivable, Receivables Analysis, Receivables Reports, Business Unit Activity - PIT, Unit Activity - Point in Time	RUN_AR60001P
AR60002P Item Activities by Entry Type/Origin	Shows a picture of business unit activity for a selected date range summarized by entry type and origin ID. You specify a point in time when you run the report. (Crystal)	Accounts Receivable, Receivables Analysis, Receivables Reports, Business Unit Activity - PIT, Unit Activity - Point in Time	RUN_AR60001PIT
AR60003P Item Activities 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. (Crystal)	Accounts Receivable, Receivables Analysis, Receivables Reports, Business Unit Activity - PIT, Unit Activity - Point in Time	RUN_AR60001PIT
AR60004P Item Activities 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. (Crystal)	Accounts Receivable, Receivables Analysis, Receivables Reports, Business Unit Activity - PIT, Unit Activity - Point in Time	RUN_AR60001PIT
AR60005P Item Activities 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. (Crystal)	Accounts Receivable, Receivables Analysis, Receivables Reports, Business Unit Activity - PIT, Unit Activity - Point in Time	RUN_AR60001PIT
AR70001 Pending Item Archive Candidates	Lists the pending item archive candidates. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Pending Candidate Report, Pending Archive Candidates	RUN_AR70001
AR70002 Payment Archive Candidates	Lists the payment archive candidates. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Payment Candidate Report, Payment Archive Candidates	RUN_AR70002
AR70003 Closed Item Archive Candidates	Lists the closed item archive candidates. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Item Candidate Report, Item Archive Candidates	RUN_AR70003
AR70004 AR Statement Archive Candidates	Lists customer statements that are candidates to be archived. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Statement Candidate Report, Statement Archive Candidates	RUN_AR70004
AR70005 AR Action List Archive Candidates	Lists item and customer actions that are candidates to be archived. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Action List Candidate Report, Run AR70005	RUN_AR70005
AR70006 AR Direct Debit Archive Candidates	Lists direct debits that are candidates to be archived. (Crystal)	Accounts Receivable, Receivables Update, Archive Receivables, Direct Debit Candidate Report, Run AR70006	RUN_AR70006
AR80019 Federal Customer Statement	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 General Ledger, Contracts, and Receivables. (Crystal)	Accounts Receivable, Customer Interactions, Statements, Create Federal Statements, Statement Parameters	RUN ARSTFED
ARCMCHK Owner Action Status	Provides the total number of actions open, completed, and cancelled for each action owner during the reporting period. (SQR)	Accounts Receivable, Customer Interactions, Actions, Action Status by Owner Rpt, Action Status by Owner Rpt	RUN_ARCMCHCK
ARCMCUST Condition Status by Owner and Customer	Provides the total number of open, completed, and cancelled actions for each action owner during the reporting period. The report is sorted by customer and condition. (SQR)	Accounts Receivable, Customer Interactions, Actions, Condition Status by Owner Rpt, Condition Status by Owner Rpt	RUN_ARCMCUST
ARSF2209 Receivables Due from the Public	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. (SQR) See Understanding the Receivables Due From the Public Report.	Accounts Receivable, Receivables Updates, Posting Results - Upd Pend Items, Report On Receivables (SF220–9), Preparer	RRUN_SF220_1
FIN2025 Electronic Funds Transfer Accompanying Form	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. (Crystal)	Accounts Receivable, Drafts, Remit Drafts to Bank, Create Cover Sheet, Create EFT File Cover Sheet	RUN_FIN2025

Receivables Selected Reports

This section provides detailed information about individual reports, including important fields. The reports are listed alphanumerically by report ID.

AR01006 - Predictor Method by Customer Report

For each method and qualifier combination, the report lists:

Step	Step number. The Payment Predictor Application Engine process (ARPREDCT) performs the actions associated with a step if the payments match the remittance information defined for the step. For each step, you define a different method for identifying customers and for the references supplied.
Condition	Condition the payment must match to perform an action. Each step must include a First condition and optionally one or more of the conditions for underpayments and overpayments.
Action	Action that Payment Predictor performs on the payment that matches the step and condition requirements.
Algorithm	Algorithm group assigned to the condition if the selected action executes an algorithm group.
Tolerances	Tolerance amount that an underpayment or overpayment must exceed or be less than for a condition.
Control	Business unit and customer provided for an action that places the payment or remaining amount on account.
Item Info (item information)	System function that Payment Predictor uses to create an item for an action that generates an item.

AR11001P - Group Control By Entry Date Point in Time Report

Define a Point in Time type when you run the report.

PIT Type (point in time type)

Specify the type of date range for the group control records to include in the report. Options are:

Day: Includes records entered on the current day only.

MTD (month to date): Includes records entered from the beginning of the month through the current date.

Range: Includes records entered during the date range that you specify in the From Date and To Date fields.

YTD (year to date): Includes records entered from the beginning of the year through the current date.

AR11002 - Pending Item By Entry Date Report

Define parameters for the Pending Item by Entry Date report.

Separate DR/CR Amount Fields (separate direct debit and credit amount fields)	Select to have direct debits and credits in separate columns.
Posted	Select to include only posted items.

AR21001 - Payment Predictor Detail Report

The report indicates the status of each payment processed by the Payment Predictor process:

Applied payments were completely applied.
Processed payments were considered, met the criteria of the method, but did not get as far as having items selected for them.
Worksheet payments may be completely applied with review required, partially applied, or could have the creation of a worksheet specified by the method.
Not processed payments were not even considered, possibly because they didn't meet the method criteria.
Excluded payments were not processed because they involve more than one currency.

AR21002 - Payment Predictor Summary Report

The report indicates the status of each payment processed by the Payment Predictor process:

Applied payments were completely applied.
Processed payments were considered, met the criteria of the method, but did not get as far as having items selected for them.
Worksheet payments may be completely applied with review required, partially applied, or could have the creation of a worksheet specified by the method.
Not processed payments were not even considered, possibly because they didn't meet the method criteria.
Excluded payments were not processed because they involve more than one currency.

AR21003 - Unmatched MICR Identifiers Report

The report indicates the status of each payment processed by the Payment Predictor process:

Applied payments were completely applied.
Processed payments were considered, met the criteria of the method, but did not get as far as having items selected for them.
Worksheet payments may be completely applied with review required, partially applied, or could have the creation of a worksheet specified by the method.
Not processed payments were not even considered, possibly because they didn't meet the method criteria.
Excluded payments were not processed because they involve more than one currency.

AR30005 - Cash Forecast Report

The report shows open balances on an as of date by customer in the base currency. It also displays the amount of cash that you can expect to receive in the cash forecast categories. The system determines in which period the cash will be received using the average days late figure for a customer.

The amounts in each forecast category are based on the number of days that you enter in the Days Per Category field on the Cash Forecast page. For example, if you enter 30, the categories on the report would be:

Pre-Forecast	The open balance on the as of date.
Forecast 1	The amount you would expect to receive 1 to 30 days after the as of date.
Forecast 2	The amount you would expect to receive 31 to 60 days after the as of date.
Forecast 3	The amount you would expect to receive 61 to 90 days after the as of date.
Post-Forecast	The amount you would expect to receive 91 days or more after the as of date.
In Dispute	The total amount of items in dispute.