Understanding Collections Workbench Detail Tabs

This topic provides information about the detail tabs and content found on the Collections Workbench.

This table lists the system-defined tabs, usage, and links to page information:

Tab Name

Usage

Aging

View the current and past due balances, the high balance and high past due balance, and the balance and past due balance dates for the selected customer, as well as balances for any customer in the customer hierarchy.

See Reviewing Customer Aging on the Collections Workbench.

Contracts

View balances by contract and contract line, and select and review items by contract and contract line.

Available only if your business has implemented PeopleSoft Contracts.

See Reviewing Contracts Information on the Collections Workbench.

Conversations

View a conversation's details related to the selected customer or contract values.

See Managing Customer Conversations and Promises on the Collections Workbench.

Corporate Accounts (Customer Hierarchy)

Also known as Customer Hierarchy.

Review customer hierarchy information.

Reviewing the Customer Hierarchy on the Collections Workbench.

Correspondence

Review correspondence history, including any statements or dunning letters associated with this customer.

See Reviewing Customer Correspondence on the Collections Workbench.

Credit Profile

View the current and past circumstances of the selected customer's credit.

See Reviewing the Customer's Credit Profile on the Collections Workbench

Items

View an item list associated with the selected customer based on the item status.

See Researching Customer Item Information on the Collections Workbench.

Payments

View the outstanding and complete payment information for a customer and/or contract, and the payment performance for a customer.

See Reviewing Customer Payment Information on the Collections Workbench.

Direct Journal Payments

Review direct journal payments.

See Reviewing Direct Journal Payments on the Collections Workbench

The Aging tab displays the customer current and past due balances, the high balance and high past due balance, and the balance and past due balance dates for the selected customer, as well as balances for any customer in the customer hierarchy. The current aged date appears and will be updated if you click an icon on this tab to update the aging. The Customer Aging grid contains the aging category, aging ID, the aging amount and currency, and the count.

See Understanding the Aging Application Engine Process.

See Setting Up Aging.

The Contracts tab is available only if your PeopleSoft Financials installation integrates with PeopleSoft Contracts. You can retrieve Contracts data by entering contracts and/or customer information in the Collections Workbench header. This tab displays balances by contract and contract line, and you can select and review items by contract and contract line. In addition, a contracts filter enables you to narrow your search of selected attributes. For a given contract or contract line, the system returns multiple values for Billing Specialist and Billing Authority, which can be displayed including names and phone numbers, and for Projects, which shows Project Costing business unit, contracts project, and contracts activity.

You can also access the Contracts Console page for a selected contract to display a summary of contract lines, amounts, related projects, and milestones.

The Conversations tab enables you to display a conversation's details related to the selected customer or contract values. You can search for specific conversations by creating a filter of selected attributes. You name and save each filter so that you can use it to search for those conversations again. When the details of a conversation appear on the Conversations grid, you can access the conversation by clicking the link associated with the conversation's date.

This tab also enables you to access the Conversations component to add a new conversation, as well as add any promise details on the Conversations page. You can access the Customer Contacts page from the Conversations tab and add a contact or click a link associated with a contact's name to modify a contact's information.

You can access the Promise Date Inquiry from the Conversations tab and search for promises by selecting various attributes. You indicate whether you want to show all of the promises based on your search criteria, or group the promises by customer, business unit, collector, or supervisor.

See Understanding Conversations.

See Setting Up Promise Date Options for a Customer.

See Reviewing Conversations and Promises.

When you select a customer to search for in the header of the Customer Workbench, you are required to select either corporate, correspondence, remit from, or no relationship as the customer relationship level. The selected relationship level determines the type of customer hierarchy that has been created for this customer and displays it on the Customer Hierarchy tab of the Customer Workbench. However, if the selected customer is not part of a customer hierarchy or you select the No Relationship value, then nothing will appear on the Customer Hierarchy tab.

The multilevel customer hierarchy that appears on the Customer Hierarchy tab is set up based on values that you select on General Info page (Customers > Customer Information > Create Customer Information). The information that you select on the Customer General Info page for a customer displays in the customer hierarchy for the selected relationship on the Customer Hierarchy page (Accounts Receivable, Customer Accounts, Customer Information, Customer Hierarchy).

The level that you select in the header also accumulates the item and past due balances for each level of customer in the selected customer hierarchy and displays them on the Customer Hierarchy tab along with each customer's credit limit.

If the Customer Hierarchy tab displays a hierarchy with multiple levels of customers, then each of the tabs on the Collections Workbench is updated with data for each level of customer in the customer hierarchy, based on the selected customer level at the top of the Collections Workbench page.

See Corporate Customers.

See Reviewing Additional Customer Account Information.

See Installation Options - Customer Page.

The Correspondence tab enables you to review any statements associated with this customer. You can drill down to the details for each form of correspondence. You can also view this customer's statements and send a statement as an attachment by e-mail.

Depending on the level of customer that you select in the header (corporate, correspondence, or remit from) if a customer hierarchy is associated with this customer, then any correspondence related to each of the customers appearing at each level of the hierarchy appear in the list of conversations on the Conversations tab.

Furthermore, you can extract dunning letter info, preview a letter, delete an item from a letter, and print a letter using the Correspondence tab.

The Credit Profile tab describes the current and past circumstances of the selected customer's credit. You can see everything that you need both about this customer's credit and any customer's within the selected customer's remit from, correspondence, and corporate hierarchy, depending on the multilevel hierarchies that have been set up for the selected customer. The Credit Profile tab for the selected customer contains:

  • The current and past due balances as of the current system date.

  • The credit limit amount

  • A risk score and risk level.

  • An assigned collector.

  • The credit class.

  • The D&B Rating (Dun & Bradstreet rating).

  • The fiscal year to date record of the number of open, kept, and broken promises.

  • A link to the Customer Messages page, which provides details or enables you to add details about a customer message.

  • History including all or various aspects of the history.

  • Aged date.

  • Posted date.

Customer Balances

You can click the customer's balance amount link to display the Items tab, which includes all open items that make up the total balance for the customer. You can also click the customer's past due amount link to display a detail list of the items for which the due date has passed that are included in this balance.

Risk Scoring

A risk score is calculated based on the set up and processing of specific risk scoring rules by the Risk Scoring program (RUN_AR_RISK). You can set up one or more risk scoring rules for selected SetID, customer, or customer group. The range value entered in a risk score is used in conjunction with the risk scoring weight to compute the risk score. The system computes the Range Value * Risk Scoring Weight = Risk Score.

The Risk Scoring program is run as part of a nightly batch run after the ARUPDATE and AR_AGING processes have completed. This ensures that the most current risk score appears on the Credit Profile tab of the Collections Workbench and in the customer's Credit Profile. The AR_RISK program relies on updated history and aging information to compute the most accurate risk score. The Risk Score process does not take into account the Dun & Bradstreet rating for this customer.

The Risk Score condition enables the Condition Monitor to create action items based on a customer's risk score.

Risk score setup and processing are discussed in detail in other sections of the PeopleSoft Receivables and PeopleSoft Order to Cash Common Information documentation.

See Setting Up Risk Scoring Rules.

See Generating Risk Scores.

See Understanding Exception and Collection Processing Options.

Promise Tracking

Open, kept, and broken promises for this customer are based on the Promise Tracking functionality on the Conversations page. A summary of these promises are listed on the credit tab and a breakdown of these promise statuses appears on the Conversations tab, which is described in a later section.

Customer Messages

When you click a link to access the Customer Message page, you can review or update the message code, the start and end dates of the message, the action required, and the hold code, if applicable. You can also indicate whether you want Customer Messages to appear on the Collections Workbench.

See General Information - Messages Page.

The Direct Journal Payments tab allows you to review direct journal payments.

You can budget check direct journals, complete direct journals and post direct journals to GL using the actions available for each direct journal payment.

The Direct Journal Payments tab data is populated only if Track Direct Journal Customer check box is selected on the Installation Options - Receivables Page.

The Items tab enables you to display an Item List associated with the selected customer based on the item status. You can also set up one or more filters to narrow your search for items similar to the way you set up filters for the Action List. The Item List is identical the Item List component (Accounts Receivable > Customer Accounts > Item Information > Item List). You can access the Account Overview component (Accounts Receivable > Customer Accounts > Customer Information > Account Overview) to view the selected customer's balance, the most recent item and payment activity, and summarized aging information. You can also click links to view detailed credit data, such as the customer's risk code or dispute status.

You can select an Item Action option to perform an action. For example, you can generate a report for a customer, such as generate a dunning letter (DUNONL multiprocess job) or run the customer item inquiry report (ARX34003). Or you can view or perform an action for all of the selected items. The Item Action options are also available on the Item List page.

Depending on the level of customer that you select in the header (corporate, correspondence, or remit from) if a customer hierarchy is associated with this customer, then the items purchased by the customer and all other customers defined at the same level or a lower level in the hierarchy appear in the Item List.

Note: Dunning letter actions can be performed on the Correspondence tab.

See Item List Page.

See Item Action Page.

The Payments tab displays the outstanding and complete payment information for a customer and/or contract and the payment performance for a customer. If you select a SetID, customer, and business unit in the Collections Workbench header, the system will display this information for that specific business unit. If you leave the business unit blank, the system will display the totals on the Outstanding Payments, Complete Payments, and Payment Performance grids for all business units that apply to the selected customer.

With PeopleSoft Contracts integration, you can also search payments (credit items, payments, drafts, and direct debits) based on contract ID, contract line, contract type, billing specialist, billing authority, or reference award number, or a combination thereof, for the following:

  • On Account Items

  • Prepayments

  • Credit Memos

  • Outstanding Payments

  • Complete Payments

When you select the Payments tab, an On Account balance link enables you to access the Items tab and view any new On Account items for the selected criteria. You can also click the Prepayments total amount, which displays any items with prepayments that comprise this total.

You can set up one or more search filters to search for outstanding and complete payments. You select check boxes on the Payments tab to display payments in process, unapplied payments, drafts and direct debits in the Outstanding Payments grid. This grid displays the details for each payment and enables you to click the Deposit ID link to drill down to the Review Payments – All Payments page for regular payments, Draft Control page for drafts, and the Direct Debit Control page for direct debits.

You can use the search filter, select the Direct Debit and Draft check boxes, and enter a date range to display completed payments on the Complete Payments grid. This grid displays details about each completed payment. You can click a link to view the Item Activity From a Payment page, which displays how the completed payment affected each item.

The Payment Performance grid for customers displays the weighted average days and amount, which is the average number of days and amount it took to complete payments falling within a specified year and accounting period and an overall weighted average.

Depending on the level of customer that you select in the header (corporate, correspondence, or remit from) if a customer hierarchy is associated with this customer, then all outstanding payments for every customer that is at the same level or a lower level in the hierarchy appear in the Outstanding Payments list on the Payments tab.

See Customer History Calculations in the Receivables Update process.