PeopleSoft Receivables Selected Reports
This appendix provides detailed information about individual reports, including important fields. The reports are listed alphanumerically by report ID.
For each method and qualifier combination, the report lists:
Field or Control |
Description |
|---|---|
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. |
Define a Point in Time type when you run the report.
Field or Control |
Description |
|---|---|
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. |
Define parameters for the Pending Item by Entry Date (SQR) report.
Field or Control |
Description |
|---|---|
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. |
The 1099-C form for Cancellation of Debt is required by the Internal Revenue Service (IRS) in the United States to summarize how much debt has been written off for a specific customer. For an overview of 1099-C report generation and instructions for setting up and running the 1099-C report, see
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.
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.
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.
This SQR 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:
Field or Control |
Description |
|---|---|
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. |
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. |