AR (Accounts Receivable) Event Processing
The system creates a tickler for the AR tickler event when a bill to customer’s A/R account qualifies for an AR event rule.
One tickler is created for each A/R account that qualifies; if an A/R account qualifies for more than 1 event rule, the system creates 1 tickler for the first event rule, in processing sequence order, that qualifies.
Note: The system does not allow multiple ticklers for the AR event (the Allow multiple ticklers field must be unselected).
When is the AR event evaluated? The system evaluates the AR event when you run the Evaluate AR Tickler periodic function (program name PFR0073).
Graduating AR ticklers: Each time you run the Evaluate AR Tickler periodic function, the system determines is any existing AR ticklers should be graduated.
• If an AR tickler exists for an A/R account and the A/R account qualifies for a new event rule, based on processing sequence order, the system keeps the existing tickler open and applies the new event rule to the tickler.
• If an AR tickler exists for an A/R account and the A/R account qualifies for the event rule currently assigned to the existing tickler, the system does not create a new tickler and keeps the existing tickler without any updates.
• If an AR tickler exists for an A/R account and the A/R account no longer qualifies for the current event rule and does not qualify for any other AR event rules, the system resolves the tickler; see Resolving AR Ticklers.
The system updates the existing tickler with the information related to the event rule that is now associated with the tickler:
• Rule number updates to the new event rule assigned to the tickler.
• Category updates to the category for the new event rule.
• Priority updates to the priority for the new event rule.
• Assigned to updates to the assigned to user/group for the new event rule.
• Assigned date updates to the date the tickler is graduated.
• Supervisor group updates to the supervisor group for the new event rule.
• Date to notify supervisor updates, based on the new supervisor group assigned.
• Tickler procedures updates to the procedures for the new event rule.
• if the tickler was in-process, the system changes the status back to open.
• if the Notify user/group field is selected for the new event rule, the system sends a Tickler Reassignment email; see Tickler Notification for a sample email. Note: The system sends a Tickler Reassignment email only if the new event rule has a different assigned to user/group from the previous event rule assigned to the tickler.
• the system creates a tickler history record, indicating the tickler has been graduated from one event rule to another.
You can define the following criteria for an AR event rule.
Note: If you enter a total A/R comparison and an A/R aging column for an event rule, the system creates a tickler if the total A/R meets the comparison criteria and some of the A/R dollars falls into the specified aging column; the system does not look for the specified total A/R amount to fall into the specified aging column.
Criterion |
Event rule set up |
The total A/R (positive or negative) for a bill to customer meets the total A/R comparison on the event rule. |
Enter a comparison value (valid values are GT greater than, GE greater than or equal to, LT less than, LE less than or equal to) in the Comparison field and a dollar amount in the Total A/R field. Note: You can only define a whole number for the total A/R. The system rounds the actual A/R total for a bill to customer to the nearest whole dollar to determine if an AR tickler should be created. Total A/R is the total dollar amount due from or owed to the bill to customer; a negative amount indicates a credit balance. All credit open items decrease this balance; all debit open items increase it. You can review the total A/R for a bill to customer on the Work with Open Items Screen. |
The A/R aging column where a portion of the open A/R dollars is located matches the A/R aging column on the event rule. |
Enter a value in the Aging column field. You define the A/R aging buckets in the following system control values: • A/R Aging 1 Column Heading (A93) • A/R Aging 2 Column Heading (A94) • A/R Aging 3 Column Heading (A95) • A/R Aging 4 Column Heading (A96) • A/R Aging 5 Column Heading (A97) • A/R Aging 6 Column Heading (A98) You can review A/R aging for a bill to customer on the Display Aging Pop-Up Window (A/R Inquiry). |
|
If the Net A/R Credits in Each Age ’Bucket’ When Aging A/R Items (E14) system control value is selected, credit amounts are included in the appropriate aging buckets and are netted against the debit amounts. To age bill to customers Run the Customer Bill To Aging periodic function (program name ACR0121). The Age by Date Type (C02) system control value defines how open items age. If set to DUE, open items age based on their due date; if set to INVOICE, open items age based on their invoice date. |
Example 1: The following event rules are defined for the AR event rule, in processing sequence order.
• Event rule 1: Aging column is over 120 days and Total A/R is greater than $10,000.00
• Event rule 2: Aging column is over 120 days and Total A/R is greater than $5,000.00
• Event rule 3: Aging column is over 120 days and Total A/R is greater than $1,000.00.
You run the Evaluate AR Tickler periodic function and:
• A/R account 5 qualifies for event rule 3 (over 120 days and total A/R is $1,500)
• A/R account 9 qualifies for event rule 3 (over 120 days and total A/R is $2,000)
The system creates a tickler for each A/R account.
You run the Evaluate AR Tickler periodic function again and:
• A/R account 5 qualifies for event rule 2 (over 120 days and total A/R is $5,600)
• A/R account 9 qualifies for event rule 3 (over 120 days and total A/R is $2,000)
The system graduates the existing tickler for A/R account 5 to event rule 2; the existing tickler for A/R account 192 continues using rule 3.
You run the Evaluate AR Tickler periodic function again, and:
• A/R account 5 qualifies for event rule 1 (over 120 days and total A/R is $12,000)
• A/R account 9 does not qualify for any rules (over 120 days and total A/R is $500)
The system graduates the existing tickler for A/R account 5. The system resolves the existing tickler for A/R account 9.
An AR tickler is resolved when you:
• select Resolve for a tickler at the Work with Tickler Screen (user/group view) or Workflow Management Screen.
• run the Evaluate AR Ticklers periodic function (program name PFR0073), if the tickler no longer applies to any AR event rules.
• run the Evaluate Create/Resolve Ticklers periodic function (program name PFR0072), if the tickler no longer applies to any AR event rules.
