This chapter provides an overview of exception and collection processing options and discusses how to:
Set up action owners.
Set up workflow notification for action owners.
Set up exception reasons and collection codes.
Set up hold and message codes for credit holds.
Set up conditions.
Set up actions and action templates.
Assign customers to a collection group.
Set up collection and assessment rules.
Implement self-service web components.
Note. This chapter is required. You must complete the tasks discussed in this chapter to implement exception and collection processing.
See Also
Defining Receivables Installation Options
Receivables enables you to monitor a customer's account and take action when a condition occurs, such as reaching a credit limit or exceeding a user-defined balance due. It also enables you to create deductions, put an item in dispute or collection, and track and manage these items.
If a customer violates a condition, the Condition Monitor Application Engine process (AR_CNDMON) determines what is the appropriate action plan. The Condition Monitor process creates the actions and assigns them to an owner on a user-defined date. If field values on items, item activity, item distribution lines, and the customer match a user-defined criteria, the Condition Monitor also creates actions and assigns them to an action owner on a user-defined date.
You specify the type of owner, such as collector, credit analyst, receivables (AR) specialist, or sales person, for each type of condition. You also define the rules that the Condition Monitor process uses to determine whether a customer has violated a condition or whether an item meets specified criteria, and to determine if it should create an action plan for the customer or item.
See Also
Understanding Exception and Collection Processing
To set up action owners, use the Collector (COLLECTOR_TABLE), Credit Analyst (CR_ANALYST_TABLE), and AR Specialist (AR_SPECIALIST) components.
This section provides an overview of action owners, list common elements for action owner setup pages, describes the pages to set up collectors, credit analysts, and AR (receivables) specialists, and discusses how to set up sales people.
Action owners are the individuals who perform the tasks for the actions assigned to customers or items. An action owner can be either a collector, credit analyst, AR specialist, or sales person. The Condition Monitor process assigns an action owner based on the type of action owner in the collection or assessment rule, and it assigns the value for that type of action owner in the Item (PS_ITEM) table. If you are monitoring information at the business unit-level, and the items have different action owners, the system uses the action owner that is assigned to the collection customer (monitoring level).
If you create an action online, you manually assign the action owner. You can also assign actions online to brokers. Brokers access their actions in the self-service web pages.
You assign the action owners to items on the pending item entry pages, the View/Update Item Details - Detail 1 page, or the Bill to Options page for the customer.
If you want to assign all actions to a single action owner, you specify the user ID of that person on the Installation Options - Receivables page. Also, if you do not specify a user ID for individual credit analysts, collectors, AR specialist, or sales persons, the Condition Monitor assigns the actions that are assigned to those individuals to the default action owner that you specify in the installation options.
See Also
Setting Up Brokers and Customers for Self-Service Transactions
Before you set up action owners, you must set up a user profile for them using the User Profiles component (USERMAINT).
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Security
User ID |
Enter the ID from the PeopleSoft user profile for the individual. If you do not specify a user ID, the system assigns actions for the individual to the default action owner defined in installation options and will not assign any actions to the individual action owner. |
Name and Telephone |
Enter the name and telephone number. They are informational only. |
Fax Number and Title |
Enter the fax number and title. They are informational only. |
Email Address |
Enter the email address. This is used for notifications if workflow is set up; otherwise, it is informational only. |
Page Name |
Object Name |
Navigation |
Usage |
COLLECTOR_TABLE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Collector, Collector |
Define valid collectors to manage collections. |
|
CR_ANALYST_TABLE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Credit Analyst, Credit Analyst |
Establish valid credit analysts to manage credit. |
|
AR_SPECIALIST |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, AR Specialist, Receivable Specialist |
Establish valid AR specialists to manage deduction and disputed items. |
|
EX_PERSONAL_DATA2 |
Set Up Financials/Supply Chain, Common Definitions, Employee Data, Create/Update Personal Data, Personal Data (Edit) |
Set up an employee ID for a sales person. |
|
MEMBER_TYPE_TABLE |
Set Up Financials/Supply Chain, Common Definitions, Team Members, Team Member Types, Team Member Types |
Define sales person team types. |
|
MEMBER_PERSON1 |
Set Up Financials/Supply Chain, Common Definitions, Team Members, Team Member Personal Data, Member Data |
Set up a team member. |
|
MEMBER_PERSON3 |
Set Up Financials/Supply Chain, Common Definitions, Team Members, Team Member Personal Data, Member Commission |
Associate a team member with a sales person team type. |
|
TEAM_MEMBER_TABLE |
Set Up Financials/Supply Chain, Common Definitions, Team Members, Support Team Members |
Assign a sales person to a support team. |
Sales person is a required field on every item in the system. A sales person in Receivables is a support team member. Several reports enable you to summarize aging according to the sales person hierarchy in your organization. You must enter at least one team member in a setID, because a default support team is a required field for customers and the default support team must have at least one sales person. Each item has a sales person associated with it as well, so you will see the sales person code on the item entry and status pages. If a pending item does not have an assigned sales person, the Receivable Update Application Engine process (ARUPDATE) assigns a sales person using the default support team member with a sales person type and the lowest priority.
To set up sales people:
Create an employee ID for each sales person on the Personal Data (Edit) page.
Create a support team type for sales people on the Team Member Types page.
You must select the Is this a Sales Person? check box.
Create a team member for each sales person on the Team Member Personal Data - Member Data page.
Assign the support team member to a support team type for sales people on the Team Member Personal Data - Member Commission page.
Set up the sales person as a support team member on the Support Team Members page.
See Also
Setting Up Customer Support Personnel
This section provides an overview of workflow notification setup and lists the pages used to setup workflow notification for action owners.
The system sends an email to action owners to notify them of new actions and places the action on their worklist if you set up users for workflow notification. The email includes a universal record locator (URL) to the Action page, where the action owner works the action.
To set up users for workflow notification:
Set up a user profile for each user who will receive notification.
Set up workflow processing information on the User Profiles - Workflow page.
Enter their email address information on the User Profiles - Email Addresses page, if you want users to receive an email notification.
Assign a workflow user to each customer on the Miscellaneous General Info page.
Note. Perform this task only if you generate the additional workflow notifications on the Notification Run Control page.
Enter the universal record locator (URL) for the AR_NOTIFYURL URL identifier on the URL Maintenance page.
The system places this URL in email notifications to access the Action page. The URL is the portal URL and varies depending on your system setup. This is an example: http//adntas79.peoplesoft.com:6200/psp/EM_EP881TS1_Ts064700/EMPLOYEE/ERP.
See Also
Assigning Actions and Sending Notification
Generating Additional Workflow Notifications
Entering Optional Customer Data
Enterprise PeopleTools PeopleBook: PeopleSoft Security
Enterprise PeopleTools PeopleBook: System and Server Administration
Page Name |
Object Name |
Navigation |
Usage |
User Profile - Workflow |
USER_WORKFLOW |
PeopleTools, Security, User Profiles, Workflow, Workflow |
Enter workflow processing information for the user. |
User Profile - Email Addresses |
USER_EMAIL |
PeopleTools, Security, User Profiles, General Click the Edit Email Addresses link on the General page. |
Enter the email address of the action owner to which you will send the notification. |
Miscellaneous General Info |
CUST_GENERAL_MISC |
Customer, Customer Information, General Information, Miscellaneous General Info |
Assign a workflow user to a customer. |
URL Maintenance |
URL_TABLE |
PeopleTools, Utilities, Administration, URLs, URL Maintenance |
Set up the URL for the AR_NOTIFYURL URL identifier for workflow notification for actions. |
To set up exception reasons and collection codes, use the Deduction Reason (DEDUCTION_TABLE), Dispute Reason (DISPUTE_TABLE), and Collection Reason (COLLECTION_TABLE) components.
This section provides an overview of exception reasons and collection codes and discusses how to:
Exception reasons identify the reason that an item is a deduction or is disputed. Collection codes normally identify the collection agency for an item or customer.
You can define unique aging rules for deduction, disputed, or collection items by using the reason or collection code.
This section discusses:
Deduction reasons
Dispute reasons
Collection codes
Deduction Reasons
You create deductions by using the payment or draft worksheet. The Payment Predictor Application Engine process (ARPREDCT) also creates deductions. The Payment Predictor process assigns the default deduction reason for the business unit to the deduction. With the worksheets, you can use the default deduction reason for the business unit or unique reasons based on the entry reason for the deduction. If you want to use unique reasons for entry reasons, you must create deduction reason codes that are the same as the entry reason codes for the deduction (DED) entry type. The system looks at the Deduction Reason table (PS_DEDUCTION_TABLE) to determine whether there is a matching value to the entry reason. If there is a matching value, it assigns the appropriate deduction reason. Otherwise, it uses the default deduction reason for the business unit. You can override the default deduction reason as needed on the worksheet or later on the View/Update Item Details - Detail 1 page.
If you make an item a deduction by using the View/Update Item Details - Detail 1 page, you manually assign a deduction reason.
Assign an AR specialist to a deduction reason if you want to assign specialists to deductions by reason.
Add a deduction reason for each reason that you need to describe deductions.
Dispute Reasons
You can place both customers and items in dispute. When you place a customer in dispute on the Credit Profile page or place an item in dispute on the View/Update Item Details - Detail 1 page, you enter the dispute reason.
Assign an AR specialist to a dispute reason if you want to assign specialists to disputed items by reason.
Add a dispute reason for each reason that you use when putting a customer or item in dispute.
Collection Codes
You can place both customers and items in collection. When you place a customer in collection on the Credit Profile page or place an item in collection on the View/Update Item Details - Detail 1 page, you enter the collection code.
Add a code for each collection code that you want to use. For example, you may want to add a code for each collection agency, or you may create codes indicating the reason that an item or customer is in collection.
See Also
Page Name |
Object Name |
Navigation |
Usage |
DEDUCTION_TABLE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Deduction Reason, Deduction Reason |
Define deduction reasons including rules for aging deductions and optionally a default AR specialist for the reason. |
|
DISPUTE_TABLE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Dispute Reason, Dispute Reason |
Define dispute reasons including rules for aging disputes and optionally a default AR specialist for the reason. |
|
COLLECTION_TABLE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Collection Code, Collection Code |
Define collection codes including rules for aging items in collection. |
Access the Deduction Reason page.
Access the Dispute Reason page.
Access the Collection Code page.
To define hold and message codes for credit holds, use the Hold Codes (HOLD_CD) and Messages (MESSAGE_TBL) components.
This section provides an overview of hold and message codes and discusses how to:
Define hold codes.
Define messages codes for credit holds.
When you attach messages to customers regarding their accounts, you must enter a message code. The codes that you define on the Messages page comprise the prompt list for the message field. For each code, you supply message text and define an action to take. You must select Credit Related Message for the message type for credit hold messages.
When you place a customer on a credit hold, you must enter a message code that is designated as a credit related message. Receivables uses hold codes in two ways:
The Condition Monitor process checks for a Credit Hold condition and takes action if a credit hold exists on a customer's account.
When you use the Place a Customer on Hold action in an action template, you specify the message code that is associated with the hold code as an action parameter that you want to place on the customer's account.
Page Name |
Object Name |
Navigation |
Usage |
HOLD_CD |
Set Up Financials/Supply Chain, Product Related, Receivables, Payments, Hold Codes, Hold Codes |
Define hold codes. Create a hold code for each reason that you use for putting a customer on hold. |
|
MESSAGE_TBL |
Set Up Financials/Supply Chain, Product Related, Receivables, Options, Messages, Messages |
Define message codes and select the message type. |
The codes that you define on this page appear on the Messages page for customers designated with an action of Hold.
Message Type |
Select Credit Related Message for credit holds. |
Specify a value in the Action group box.
None |
Indicates no action. |
Reject |
Indicates that the system will reject an order if you attach this message to the customer. Only Order Management uses the Reject action. It has no effect on Receivables processing. |
Hold |
Indicates that a customer is on hold. If you select Hold, you must enter an appropriate hold code, one that you established on the Hold Codes page. If a customer has an action of Hold on the Messages page, the value appearing in the Hold Code field is the short description that you defined on the Hold Codes page. Several check boxes become available if you select Hold. These check boxes are used only by Order Management. |
Note. The action value that you select on this page displays in the Action field on the Messages page for the customer.
To set up conditions, use the Condition Definition (AR_COND_DEF), Condition Definition User (AR_COND_DEF_USER), and Condition Priority (AR_COND_PRIORITY) components.
This section provides an overview of conditions and discusses how to:
Set up system-defined conditions.
Set up user-defined conditions.
Reorder condition priorities.
A condition occurs when there is a change of status for a customer's account, such as reaching a credit limit or exceeding a user-defined balance due. A condition also occurs when you create a new deduction or disputed item. The Condition Monitor process checks for customer's accounts or items that meet these conditions and creates an action based on templates and rules that you define. The process looks at the conditions for the customers with the same roles as the role that you select in each condition definition.
PeopleSoft delivers several system-defined conditions. You must set up the system-defined conditions for at least one setID. Most of the field values for the system-defined conditions are automatically populated by the system. You can also set up your own four-character user-defined conditions. Each condition is monitored at the customer-level or the item-level.
The following table describes the system-defined conditions. You define the details for the condition trigger on the Collection Rule, Assessment Rule, and Assessment Rule User pages.
Page Name |
Object Name |
Navigation |
Usage |
AR_COND_DEF |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Condition Definition, Condition Definition |
Review and define a single system-defined condition. Displays all information for a condition. |
|
AR_COND_DEF_USER |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Condition Definition User, Condition Definition User |
Set up user-defined conditions. |
|
AR_COND_PRIORITY |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Condition Priority, Condition Priority |
Review all conditions at one time. Reorder the priority of a condition. Displays limited information for each condition. |
Access the Condition Definition page.
Parameters
The fields in the Parameter group box—Amount, Count, Days, Percent, and # Periods (number of periods)—control the entry of parameters on the Assessment Rule page. Each condition may have one or more parameter flags set. The parameters are system-defined, and you cannot modify them. The values are Required, Optional, or one of the following values:
Only One |
You must enter a value in only one of the fields flagged as Only One and the other fields with this flag must be blank. |
All or None |
You must enter a value in all fields flagged as All or None or leave all of them blank. |
One or All |
You must enter a value in at least one of the fields flagged as One or All or enter a value in all of the fields with this flag. |
The following table lists all of the parameters for each field for each condition:
Condition |
Amount |
Days |
Count |
Percent |
Number of Periods |
Explanation |
Collection (COLL) |
Required |
Required |
|
|
|
Both amount and days are required. |
Approaching Credit Limit (ACLA) |
One or All |
|
|
One or All |
|
Either amount or percent must be entered, or both can be entered. |
Exceeded Credit Limit (ECLA) |
|
|
|
|
|
No parameters can be entered. |
Approaching Credit Limit Expiration (ACLD) |
|
Required |
|
|
|
Days is required. |
Exceeded Credit Limit Expiration Date (ECLD) |
|
|
|
|
|
No parameters can be entered. |
Credit Hold Exists (CHLD) |
|
|
|
|
|
No parameters can be entered. |
Conversation Follow Up (CFLU) |
|
|
|
|
|
No parameters can be entered. |
Large Amount Coming Due (LACD) |
Required |
Required |
|
|
|
Both amount and days are required. |
Key Statistics Exceeded (KSTE) |
Only One |
|
Only One |
All or None |
All or None |
Either amount or count must be entered; either percent and period must be entered, or both fields must be blank. |
Entry Type/Reason Code (ETRC) |
Optional |
Optional |
|
|
|
Both amount and days are optional. |
Deduction Item (DEDN) |
|
|
|
|
|
No parameters can be entered. |
Disputed Item (DISP) |
|
|
|
|
|
No parameters can be entered. |
Online Item (ONLN) |
|
|
|
|
|
No parameters can be entered. |
User-defined (any four-character code) |
|
|
|
|
|
No parameters can be entered. |
Access the Condition Definition User page.
This page is similar to the Condition Definition page. However, you can define only a condition role and assign a priority.
See Also
Setting Up System-Defined Conditions
Access the Condition Priority page.
This page contains the same fields as the Condition Definition page except that it has fewer fields.
Priority |
Enter a new number to reorder the condition priority. The conditions display in priority order. The priority number determines the order in which an action for the condition appears in the action list if a customer has multiple actions. The lower the number the higher the action associated with the condition will be. |
Condition |
Click a condition link to access the Condition Definition page and view all condition details. |
To set up actions and action templates, use the Action Code (ACTION_CODE) and Action Template (AR_TEMPLATE_TBL) components.
This section provides an overview of action definitions and action templates and discusses how to:
Review or define the actions.
Define action templates.
Actions are activities that an action owner performs in response to the condition of a customer's account, such as sending a follow-up letter or putting an account on hold. Actions are also activities that an action owner performs for items, such as deduction and disputed items.
Receivables provides nine actions. However, you can add additional actions. Each action definition controls how you enter data in action templates.
Action templates define whether the system automatically performs the action or whether the system marks the action as Proposed. If an action is proposed, the action owner decides whether to take the action.
You must enter an action parameter for some actions. These parameters provide additional instructions for the system to use when it performs the action. For example, the Send a Follow-up Letter (OLTR) action needs a letter code.
The following table lists the system-defined actions:
Code |
Description |
Requires Action Parameter? |
Can Be Automated? |
Create an Alert |
N |
N |
|
Call the Customer |
N |
N |
|
Send Dunning Letter |
Y |
Y |
|
Downgrade Credit Rating |
N |
N |
|
Place Customer on Hold |
Y |
Y |
|
Send Other Letter |
Y |
Y |
|
Refer to Collection Agency |
Y |
N |
|
Send Statement of Account |
N |
Y |
|
Write off Customer Balance |
N |
N |
You must set up the system-defined actions for at least one setID. Most of the field values for the system-defined actions are automatically populated by the system. You can also define user-defined actions by using a four-letter code.
An action template outlines a set of escalating actions that the system performs based on the period of time that the customer or item has been in the action plan for the condition.
You specify which template the Condition Monitor uses when you define the collection and assessment rules. Each template may contain multiple actions. You specify the number of days that you want to elapse between the time that the condition occurred and the time that the action should take place. Based on the number of days that the condition for a customer or item has existed, the system determines which action to use. You can set up the action template to send a notification to the action owner, the supervisor for the action owner, or a specialist a specified number of days before or after the action due date.
If you use the following actions, you must set up additional tables before creating action templates:
Action |
Prerequisite Table Setup |
Sending a Dunning Letter (DLTR) |
Letter codes and dunning IDs. |
Place a Hold Message on a Customer (HOLD) |
Hold codes and message codes. |
Send a Follow-up Letter (OLTR) |
Letter codes. |
Refer to a Collection Agency (REFR) |
Collection codes. |
Send a Statement (STMT) |
Statement IDs. |
See Also
Setting Up Correspondence Options
Page Name |
Object Name |
Navigation |
Usage |
ACTION_CODE |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Action Code, Action Definition |
Review the definition for each action and change the action status. Define new actions. |
|
AR_TEMPLATE_TBL |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Action Template, Action Template |
Define a set of actions to perform for a condition in an escalating order based on the number of days that the condition has existed. |
Access the Action Definition page.
Access the Action Template page.
Enter the action parameter if the action definition requires a parameter for the action. This table describes the type of parameter to enter for each type of action:
Action |
Type of Parameter |
Send a dunning Letter (DLTR). |
Letter code. Note. To use the letter assigned to the action, you must assign a customer a dunning ID that uses a Dunning by Action List dunning method. Otherwise, the system uses the letter codes based on the rules for the dunning ID. |
Place a hold message on a customer (HOLD). |
Message code. |
Send a follow-up letter (OLTR). |
Letter code. |
Refer to a collection agency (REFR). |
Collection code. |
Note. Enter a positive number to send the notification after the due date and a negative number to send the notification before
the due date. To send the notification on the due date enter 0. You must run the Condition Monitor process to send the notification. If you leave the fields blank, the process does not
send notification.
The system does not include weekends and holidays when it calculates the notification date. The system uses the business calendar
that you selected for the general ledger business unit associated with the receivables business unit to determine what days
are holidays and weekend days. You select the calendar in the Holiday List field on the General Ledger Definition - Definition page.
You may want to group customers so that you can define collection and assessment rules for a group of customers instead of all customers associated with a setID or a single collection customer. Receivables provides a group type called Coll (collection) so that you can create customer groups that are used exclusively for collection and exception processing.
To assign customers to groups:
Create each customer group by using the Collection group type on the Customer Group Table page.
Assign the customer to a group by using the Collection group type on the General Information - Customer Group Info page.
See Also
Establishing Customer Group Tables
Assigning Individual Customers to Customer Groups
To set up collection and assessment rules, use the Schedules (SCHEDULES), Collection Rules (AR_COLLECTION_RULE), Assessment Rule (AR_ASSESS_RULE), and Assessment Rule SQL (AR_ASSESS_RULE_SQL) components.
This section provides an overview of collection and assessment rules, lists common elements, and discusses how to:
Define schedules.
Set up collection rules.
Define assessment rules without SQL.
Define assessment rules using SQL.
The Condition Monitor process uses the collection and assessment rules to evaluate the nature of a condition to determine whether to create an action for the customer or item.
You define rules at the following assessment levels:
Level |
Rule Applies To |
SetID |
All customers assigned to the setID. |
Customer group |
Only for customers in the customer group that you specify. |
Customer |
Only for customers that you specify. |
Rules that are at the customer level override rules that are at the other two levels, and rules that are at the customer group level override rules for setIDs. From a maintenance standpoint, you should set up defaults at the highest possible level so that if a change is required, you do not have to go to every instance at a lower level to make the change.
Collections rules apply only to the Collection (COLL) condition. The rules for collection conditions are based on both the amount and the number of days past due for outstanding balances. When the Condition Monitor process runs, it determines the age of the oldest past due item on a customer's account and the total amount past due to determine if a collection condition exists.
Assessment rules without SQL are for customer-level conditions other than the collection condition. The assessment rules are based on the existence of data specified in the rule or the comparison of data against a specified value. For example, the rule may say that the Approaching Credit Limit Expiration (ACLD) condition is violated if the numbers of days that are remaining for the customer's credit limit is less than 21 days. These rules are used for system-defined conditions other than collection conditions and item-level conditions, such as deductions and disputed items.
Assessment rules with SQL criteria are for item-level conditions and user-defined conditions. The assessment rules are based on a value in a specified field or fields on an item's record. For example, a rule may specify that the Condition Monitor process should create an action plan if the Deduction field is Y and the deduction date is 2 days less than the current system date. You need to be familiar with building SQL statements to create these assessment rules. The SQL criteria can also use fields from the Item Activity (PS_ITEM_ACTIVITY), Item Distribution (PS_ITEM_DST), Customer (PS_CUSTOMER), and Customer Options (PS_CUST_OPTION) tables. You can use assessment rules with SQL criteria only for user-defined conditions.
If you plan to define assessment rules with SQL criteria, you must create messages in the message catalog that appear as the description text on action lists.
If you create an assessment rule for these conditions, you must set up additional tables before you create the assessment rules:
Condition |
Prerequisite Table Setup |
Entry Type/Reason (ETRC) |
Define the entry type and reasons to use in the assessment rules. |
Key Statistics Exceeded (KSTE) |
Define system-defined or user-defined history IDs to use in the assessment rules. |
See Also
Page Name |
Object Name |
Navigation |
Usage |
SCHEDULE |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Schedules, Schedules |
Create the schedules that you assign to the collection and assessment rules. |
|
AR_CRULE_TBL |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Collection Rule, Collection Rule |
Enter the rules for the Collection condition. |
|
AR_ARULE_TBL |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Assessment Rule, Assessment Rule |
Enter the rules for the system-defined conditions other than collection conditions. |
|
AR_ARULE_SQL |
Set Up Financials/Supply Chain, Product Related, Receivables, Assessment Rule User, Assessment Rule User |
Enter the rules for user-defined conditions using SQL criteria. |
|
AR_ARULE_SQL_SBP |
Click the SQL Statement button on the Assessment Rule User page. |
View the free-form SQL statement for an assessment rule or copy the statement to test it using a SQL query tool |
Define the schedules that the Condition Monitor uses to determine the frequency and days to run a collection or assessment rule. You can select any frequency that you want.
See Also
Access the Collection Rule page.
Specifying Validation Criteria
Your selection criteria determine how you enter information in the grid.
Days |
Select to enable entry of a value only in the From Day column in the first row. The system assigns the value for the from day for subsequent rows by incrementing the value in the To Day field from the previous row by 1. You can enter any values that you want in the From Amount and To Amount columns. |
Amount |
Select to enable entry of an amount in the From Amount field in the first row. The system assigns the from amount for subsequent rows by incrementing the amount in the To Amount field from the previous row by .01. You can enter any values that you want for the From Day and To Day columns. |
No Check |
Select to enable entry of any values that you choose in the day and amount fields. You must make sure that there are no gaps or overlaps in the criteria. |
Entering Validation Information
Access the Assessment Rule page.
Parameters
The Condition Monitor process uses the criteria in the Parameters group box to determine whether the condition has been violated. If a condition does not require a specific criteria, the field is unavailable. The following table identifies the type of criteria that are applicable for each condition:
Condition |
Operator |
Amount |
Days |
Count |
Percent |
Number of Periods |
Approaching Credit Limit (ACLA) |
|
X |
|
|
X |
|
Approaching Credit Limit Expiration (ACLD) |
|
|
X |
|
|
|
Exceeding Credit Limit (ECLA) |
|
|
|
|
|
|
Exceeded Credit Limit Expiration Date (ECLD) |
|
|
|
|
|
|
Credit Hold Code Exists (CHLD) |
|
|
|
|
|
|
Conversation Follow Up (CFLU) |
|
|
|
|
|
|
Entry Type/Reason Code (ETRC) |
X |
X |
X |
|
|
|
Key Statistics Exceeded (KSTE) |
X |
X |
|
X |
X |
X |
Large Amount Coming Due (LACD) |
|
X |
X |
|
|
|
Deduction Item (DEDN) |
|
|
|
|
|
|
Disputed Items (DISP) |
|
|
|
|
|
|
Defining Rule Parameters
Operator |
Select an operator such as less than or equal to (Less/Equal) if you are creating a comparison rule for a Key Statistics Exceeded (KSTE) or Entry Type/Reason Code (ETRC) condition. |
Amount |
Enter the monetary amount for the comparison. |
Count |
Enter the count of times for the comparison. |
Percent |
If you are creating a rule for the Approaching Credit Limit (ACLA) condition, enter the percent to trigger the condition when customers' outstanding balances reaches the percentage that you enter of their credit limits. For example, a customer's credit limit is 100,000.00 EUR and you enter 80 percent. The Condition Monitor creates an action when the customer's outstanding balance reaches 80,000.00 EUR. If you are creating a rule for the Key Statistics Exceeded (KSTE) condition, enter the number of periods and the percent for the rule. The Condition Monitor process uses these values to determine if a key statistic has changed. Enter the relative period to compare in the # Periods (number of periods) field. The current period is considered to be period 0, so if you want to monitor the change between the current period and the same period last quarter, you would enter 3 in the # Periods field. Then, enter either a positive or a negative number in the Percent field. The Condition Monitor process calculates the percentage change between the current period and the comparison period and then compares the change, using the operator that you entered and the percent for the rule. |
Access the Assessment Rule User page.
This section provides an overview of Receivables self-service components and discusses how to:
Set up brokers and customers for self-service transactions.
Set up sales people for self-service transactions.
Self-service web components provide your employees, customers, and individuals outside of your organization with secure and convenient access to information.
PeopleSoft delivers several self-service web components as templates. You can use PeopleSoft Enterprise Application Designer to modify these web components just as you would any application components.
Receivables provides the following web components:
Component |
Description |
Items (ITEM_RVW_CST_SS), (ITEM_RVW_BKR_SS), and (ITEM_RVW_SLS_SS) |
Provides details for individual items, including the amount, status, and reference information (such as the associated invoice number, payment ID, and contacts). It also provides links to actions and conversations associated with an item. |
Actions (ACTION_RVW_SS) |
Provides a list of tasks assigned to individuals to take on an item and option to view the status for a task. |
Note. Customers and brokers access the self-service web components from the Customer portal and sales people access the self-service web components from the Employee portal.
The user profile that you create for each individual who accesses your self-service web application determines the web pages that the user can access. You create user profiles in PeopleTools on the User Profiles component. You assign a role to each user profile and you link roles to permission lists. Each permission list identifies the pages that individuals assigned to a role can access. To modify the access for specific web pages for each role, you modify the permission list for the user’s role.
Note. If you modify a permission list, you change the access for all users who are assigned to roles to which the permission list is linked.
You also use the user profile to define the data to which the user has access. For example, you associate the user profile for a customer contact with a specific contact ID. When a customer logs on to the self-service web application, they receive access to item information only for the customers assigned to that contact ID.
Receivables provides self-service web pages for the following roles. We deliver sample definitions for each of these roles and have assigned sample permission lists to each role:
Customers
Brokers
Sales people
Sales people and brokers have access to self-service web pages where they can perform these tasks:
View items.
Maintain actions.
Review conversations.
Customers have access to a self-service web page that enables them to view items.
The values that appear on the search results pages and search filter pages vary, based on the user’s role, just as they do in other PeopleSoft applications. We associated one or more of the roles that we deliver with each self-service role menu.
See the information about permission lists in the Enterprise PeopleTools PeopleBook: PeopleSoft Security.
You must perform several tasks to enable brokers and customers to use the self-service web pages. The setup defines which self-service web pages the brokers and customers can access and also identifies to which items they will have access.
To set up brokers and customers:
Create separate permission lists for brokers and customers by using the Permission Lists component (ACCESS_CNTRL_LISTX).
Use the following permission lists in the sample database as examples:
Use the EPAR2100 permission list for brokers.
Use the EPAR2200 permission list for customers.
Create separate roles for brokers, customers, and sales people by using the Roles component (ROLEMAINT).
Use the following roles in the sample database as examples:
Use the Broker role for brokers.
Use the Customer role for customers.
Create a contact for each customer and broker on the Contact page.
Enter the customers that are associated with the contact on the Contact Customer page.
For broker contacts, you must also select the Broker Customer check box on the Self Service Security tab for the customers that correspond to the broker ID on the deductions that you want them to view.
When a customer or broker contact accesses the Items component, the system displays items for only the customers that you enter.
Link the contact to a user profile on the Contact User Profile page.
The roles that you assign to the contact determine which self-service menus the contact can access. Assign the Customer role to your customer contacts and the Broker role to your broker contacts.
Note. You can also use the User Profiles component to create a profile for a contact. If you use the User Profiles component, select Customer Contact for the ID Type and then assign the appropriate contact ID to the Attribute Value.
Set up the setID user preference for the user on the Define User Preferences - Overall Preferences page.
For brokers, select the Broker Customer check box on the General Info page for the customer.
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Security
Defining Overall User Preferences
You must perform several tasks to enable sales people to use the self-service web pages. The setup defines which self-service web pages the sales people can access and also identifies to which items they will have access.
To set up sales people for self-service transactions:
Create an employee ID for each sales person on the Personal Data (Edit) page.
Create a separate permission list for sales people.
Use the EPAR2300 permission list in the sample database as an example.
Create a role for sales people.
Use the Sales Person role in the sample database as an example.
Create a user profile for the sales person.
Select Employee for the ID Type and then assign the appropriate employee ID to the Attribute value. Assign the Sales Person role to the user profile.
Create a support team type for sales people on the Team Member Types page.
Set up the sales person as a support team member on the Team Member Personal Data - Member Data page.
Associate the same employee with the sales person as you did in the user profile.
Assign the support team member to a support team type for sales people on the Team Member Personal Data - Member Commission page.
Specify the setID user preference for the user on the Define User Preferences - Overall Preferences page.
The sales person for each item is one of the members of a sales support team. The system displays only items to which a sales person is assigned in the Sales Person 1 or Sales Person 2 fields for the item.
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Security
Setting Up Customer Support Personnel
Defining Overall User Preferences