Customer Credit Rule Maintenance

If you edit this topic, review Customer Credit Rule Maintenance Database Information.

Menu Path: Credit and Collections Images\bluerarw.gif Module Setup Images\bluerarw.gif Credit Images\bluerarw.gif Customer Credit Rule Maintenance

Purpose

Overview

Use Customer Credit Rule Maintenance to define credit rules for a credit customer. These credit rules are used to determine when sales orders go on credit hold, as well as how other credit monitoring tasks are created.

Note It is not necessary to assign credit rules to each customer. A customer’s credit rules can default from their assigned credit division or credit group set up in Group Credit Rule Maintenance. If a customer’s rules are different from the default rules, then you can override the rules for the customer. The customer, group, and division values are displayed for every rule, and you can see whether the customer value is an override of the default value.

Every credit customer must be assigned to a credit group and a credit division.

Note You should organize credit customers into logical credit groups and credit divisions. For example, you could use credit groups to group credit customers that have the same credit checking rules. You could use credit divisions to group credit customers that are in the same industry.

For database information for this window, see Customer Credit Rule Maintenance Database Information.

Customer Overrides

The credit customer follows the rules of its default group or division. To override the rules for the default group or division, select the appropriate Override check box, and enter the override rule.

Note The Customer fields always display the rule in effect for this customer. If the Override check box is cleared, then the rule displayed comes from the default group or division. If the Override check box is selected, then this customer has a rule different than the default group or division.

Minimum Credit Score, Credit Limit, Credit Limit Overage %, Credit Insurance, and Actual Credit Score are credit rules considered important enough to:

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Customer Credit Rule Maintenance window.

Update

Click this button to update the credit rules for the selected customer.

OK

Click this button to accept an action. This button is only available after you click the Update button in the ribbon.

Cancel

Click this button to cancel an action. This button is only available after you click the Update button in the ribbon.

First

Click this button to display the first customer.

Prev

Click this button to display the previous customer.

Next

Click this button to display the next customer.

Last

Click this button to display the last customer.

Credit Change History

Click this button to display Credit Change History Inquiry, which allows you to view changes made to credit rules for the selected customer. This button is only available if the Key Rules or Payment Terms tab is displayed.

Related Customer

Click this button to display Related Customer Inquiry, which allows you to view all customers related to a credit customer and their payment overrides. This button is only available if the Payment Terms tab is displayed.

Fields and Buttons

Field or Button

Description

Customer Code

Enter the customer code of a credit customer, or click the Lookup button to select a customer code. For information on the functions of the credit customer, see Structure and Concepts.

Name

Enter the customer name of a credit customer, or click the Lookup button to select a customer name. For information on the functions of the credit customer, see Structure and Concepts.

Credit Group

Enter the credit group for the selected customer, or click the Lookup button to select a credit group.

Note You can also assign a credit group to a customer in Customer Maintenance.

Dun & Bradstreet Number

Enter the ID number assigned by Dun & Bradstreet to the selected customer.

Credit Division

Enter the credit division for the selected customer, or click the Lookup button to select a credit division.

Note You can also assign a credit division to a customer in Customer Maintenance.

Display Currency

Click the Lookup button to select the currency for all amounts displayed in this window. This defaults to the default general ledger currency. The Lookup button is disabled when you are updating a customer's credit rules.

Default Rules

Select whether the default rules for the customer come from the customer's credit group or credit division.

Example If Group is selected, and the credit group for a customer is ABC, then the customer will follow ABC’s credit rules unless overridden, or until the credit group is changed for the customer.

Key Rules Tab Fields and Buttons

Field or Button

Description

Minimum Credit Score

If you want to override the credit group or credit division minimum credit score, select the Override check box. You can then enter the minimum credit score below which orders are put on credit hold in the Customer field. Orders only go on credit hold if the Credit Score Hold check box is selected on the Credit Options tab. A history of changes to the minimum credit score is maintained for audit purposes.

Example The minimum credit score is 65. A sales order entered for a credit customer that has an actual credit score of 50 is put on credit hold.

If you override this rule, you can enter a new effective date. If you select a date in the future, the Future Change check box is selected after you save the customer's credit rules. This check box is selected as a reminder that the rule will change at some future date in Credit Task Refresh.

Example If today is 06/30/2020 and the minimum credit score for customer A will be increased on 07/31/2020, enter 07/31/2020 as the new effective date.

Credit Limit

If you want to override the credit group or credit division credit limit, select the Override check box. You can then enter the basic amount of the credit limit authorized for the customer in the Customer field. Orders only go on hold if the Credit Limit Hold check box is selected on the Credit Limit tab. A history of changes to the credit limit is maintained for audit purposes.

If you override this rule, you can enter a new effective date. If you select a date in the future, the Future Change check box is selected after you save the customer's credit rules. This check box is selected as a reminder that the rule will change at some future date in Credit Task Refresh.

Example If today is 06/30/2020 and the credit limit for customer A will be increased on 07/31/2020, enter 07/31/2020 as the new effective date.

Credit Limit Overage %

If you want to override the credit group or credit division credit limit overage percentage, select the Override check box. You can then enter the overage percentage to create an over limit credit task in the Customer field. This acts as an additional credit safeguard. If a credit user has credit approval for up to 5,000 (per order), then multiple orders under 5,000 could be approved to drive the total credit exposure to significantly exceed the credit limit. When the credit limit is exceeded beyond this overage percentage, an over limit credit task is created. An over limit credit task only gets closed automatically when the total credit exposure falls below the credit limit overage.

Example The credit limit is 100,000 for credit customer A. The customer's credit limit overage percentage is 10%. When the credit exposure exceeds 110,000 for credit customer A, an over limit credit task is created.

Note In Credit Task Management when an order is released from a credit limit credit hold, if the customer has an over limit credit task, a warning message appears.

If you override this rule, you can enter a new effective date. If you select a date in the future, the Future Change check box is selected after you save the customer's credit rules. This check box is selected as a reminder that the rule will change at some future date in Credit Task Refresh.

Example If today is 06/30/2020 and the credit limit overage percentage for customer A will be increased on 07/31/2020, enter 07/31/2020 as the new effective date.

Credit Insurance

If you want to override the credit group or credit division credit insurance amount, select the Override check box. You can then enter the amount of credit insurance in the Customer field. This is informational only, and does not affect any accounts receivable processing. A history of changes to the credit insurance amount is maintained for audit purposes.

If you override this rule, you can enter a new effective date. If you select a date in the future, the Future Change check box is selected after you save the customer's credit rules. This check box is selected as a reminder that the rule will change at some future date in Credit Task Refresh.

Example If today is 06/30/2020 and the credit insurance for customer A will be increased on 07/31/2020, enter 07/31/2020 as the new effective date.

Actual Credit Score

Enter the customer's actual credit score. A history of changes to the actual credit score is maintained for audit purposes.

If you enter an actual credit score, you can enter a new effective date. If you select a date in the future, the Future Change check box is selected after you save the customer's credit rules. This check box is selected as a reminder that the rule will change at some future date in Credit Task Refresh.

Example If today is 06/30/2020 and the credit score for customer A will be increased on 07/31/2020, enter 07/31/2020 as the new effective date.

Credit Check Update Limit

If you want to override the credit group or credit division credit check update limit, select the Override check box. You can then enter the amount that a sales order can be increased before being credit checked again in the Customer field.

Example The credit check update limit is set to 300. The sales order is 1000. An update is made to the sales order which increases it to 1500. In this case, the update amount is 500, which exceeds the update limit of 300, so the system performs a credit check. If the credit limit is exceeded, the order is put on credit hold.

Credit Check Backorders

If you want to override the credit group or credit division credit check backorders rule, select the Override check box. You can then select the Customer check box if when backorders are released (allocated), you want related sales orders to be credit checked, if the backorder credit date has passed.

Credit Check Backorder Days

If you want to override the credit group or credit division credit check backorder days, select the Override check box. You can then enter the number of days since the sales order was placed (or backorders released) to wait before credit checking a backorder in the Customer field. This is used to calculate the backorder credit date.

Payment Terms Tab Fields and Buttons

Field or Button

Description

Standard Payment Terms

If you want to override the credit group or credit division standard payment terms, select the Override check box. You can then enter the standard payment terms to use for sales order entry, and manual invoice and debit memo entry in the Customer field, or click the Lookup button to select the payment terms.

Credit Memo Override Payment Terms

If you want to override the credit group or credit division credit memo override payment terms, select the Override check box. You can then enter the standard payment terms to use for return order entry, and manual credit memo entry in the Customer field, or click the Lookup button to select the payment terms.

Approved for Finance Payment Terms

If you want to override the credit group or credit division Approved for Finance Payment Terms setting, select the Override check box. You can then select the Customer check box if the customer is approved for finance terms, or clear the Customer check box if the customer is not approved for finance terms. Orders for the customer can use finance payment terms only if this check box is selected for the customer (or credit group/division if no override is set).

Change All Related Customers

Select this check box to copy any changes made to the customer's credit rules to all customers that share the customer's credit customer. There could be many related customers for a single credit customer, so it can be time-consuming to make individual customer changes.

Credit Aging Tab Fields and Buttons

Field or Button

Description

Customer/Group/Division

Select Group or Division to view the customer's credit group or credit division credit aging values. Select Customer to display and/or modify customer override aging values.

Past Due Days

If you want to override the credit group or credit division aging buckets, enter the number of days to include in the past due bucket you are creating. These past due buckets are displayed for credit customers in Credit Hold Inquiry.

Example If the first past due bucket being created is 1-15 days past due, enter 15. If the 2nd past due bucket being created is 31-40 days, enter 10.

Note The last bucket must contain 999 past due days. This will help prevent situations where significantly past due transactions might be excluded.

Credit Priority

If you want to override the credit group or credit division aging buckets, enter the priority assigned to a credit hold task in Credit Task Management if one of the credit hold reasons is past due.

Add

Click this button to add another past due bucket to the Credit Aging grid.

Remove

Click this button to remove the selected past due bucket from the Credit Aging grid.

Credit Aging

This grid displays credit aging buckets for the customer, credit group, or credit division. This grid includes the following columns:

  • Past Due Bucket # - This column displays the sequential number of each past due bucket.

Example If the first past due bucket is for 1-15 days past due, then this bucket is bucket 1.

  • Past Due Days - Enter the past due days for each bucket.

  • Past Due Aging Label - Enter the label associated with each past due bucket. This label initially defaults based on the previous buckets past due days, but can be manually overridden.

Example If the first past due bucket being created has 15 past due days, then the label defaults to 1-15 .

  • Priority - Enter the priority assigned to a credit hold task in Credit Task Management if one of the credit hold reasons is past due.

Credit Options Tab Fields and Buttons

Field or Button

Description

Allowed to Place Orders

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to allow orders to be entered for the customer.

Example If customer A and customer B are linked to credit customer C, and this check box is cleared for customer C, you cannot enter a sales order for customers A, B, or C.

Credit Check Option

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then click the Lookup button to the right of the Customer field, and select one of the following options:

  • All - Perform credit check rules on sales orders for customers in the credit group or credit division.

  • None - Bypass credit check rules for customers in the credit group or credit division.

Example For a credit group that includes Wal-Mart and similar credit customers, you may select None because of the size and creditworthiness of such companies.

Note If a customer’s credit is suspended in Credit Suspend and Stop Order Management, the option Credit Suspend or Stop Orders displays in this field, even though it cannot be manually selected.

Future Credit Check Days

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the number of days that controls whether a future credit check for a sales order occurs in the Customer field.

Example If you enter 30, then the sales order will not be credit checked until the required date is within 30 days of today’s date. This keeps future sales orders from using up a current credit limit.

Inactive Customers Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders for inactive credit customers on credit hold based on the number of days since the last order entered in the Days Since Last Order field.

Days Since Last Invoice

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the number of days since the last invoice after which orders are put on credit hold in the Customer field. Orders only go on credit hold if you select the Inactive Customers Hold check box.

Example You enter 90 in this field. If today is 6/30/2020, then if there has been no order placed since 4/1/2020, a placed sales order goes on credit hold.

Order Class Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders for a specific order class on credit hold if they are greater than a specific threshold amount. If you select this check box, enter the order class in the Order Class field and the threshold amount in the Order Class Threshold Amount field.

Order Class

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter an order class for which to put sales orders on credit hold (for order amounts greater than the amount entered in the Order Class Threshold Amount field) in the Customer field, or click the Lookup button to select an order class. Orders only go on credit hold if you select the Order Class Hold check box.

Order Class Threshold Amount

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the amount greater than which orders of the order class entered in the Order Class field go on credit hold in the Customer field. Orders only go on credit hold if you select the Order Class Hold check box.

Example You enter 1000 in this field and enter DS in the Order Class field. An order placed for 1200 for order class DS is put on credit hold.

Non-Default Payment Terms Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders on credit hold if the payment terms for the sales order are different than the default payment terms for the customer.

Example The default payment terms are Net/30. A sales order entered with payment terms of Net/60 is put on credit hold.

Credit Score Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders on credit hold if the credit score for a credit customer is less than the minimum credit score entered in the Minimum Credit Score field on the Key Rules tab.

NSF Payment Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders on credit hold if there has been an NSF payment for the related paying customer based on the number of days in the Days since last NSF Payment field.

Days since last NSF Payment

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the number of days since the last NSF payment for a related paying customer to put orders on credit hold in the Customer field. Orders only go on credit hold if you select the NSF Payment Hold check box.

Example You enter 60 in this field. If today is 6/30/2020, then a NSF payment made since 5/1/2020 will result in the sales order going on credit hold.

Credit Card Authorization Basis

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then click the Lookup button to select the monetary amount for credit card authorizations for the credit group or credit division. Select one of the following:

  • Default - Use the amount specified in Order Class Maintenance.

  • Minimum Charge - For Worldpay, a zero amount AVS Only transaction.

  • Order Total - The total amount of the order.

  • Shippable Amount - The shippable amount of the order. If there is no shippable amount, an authorization is made for 1 in the currency of the order.

For information on how this setting affects credit card transactions, see Credit Card Orders.

Authorize Over Amount %

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the percentage over the amount for allocated products to authorize during pick demand creation.

This percentage should account for the following:

  • Freight that may be added during shipping (not known, not on the order before shipping)

  • Backordered quantities on the order that may come into inventory and ship with the shipment being prepared

Credit Past Due Tab Fields and Buttons

Field or Button

Description

Past Due Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders on credit hold if the adjusted past due balance is greater than or equal to the amount entered in the Minimum Past Due Balance field or the percentage entered in the Minimum Past Due Percentage field.

Grace Days

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the number of days to add to the due date before considering it past due for calculating a past due hold in the Customer field.

Example The due date for an invoice is 6/30/2020 and the grace days is 7. The invoice is not considered past due for purposes of the past due hold until 7/8/2020.

Minimum Past Due Balance

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the minimum past due balance that will trigger a past due hold in the Customer field.

Note This rule will only be used if the balance is greater than 0. If a percentage is also entered in the Minimum Past Due Percentage field, then both rules must be passed for credit checking purposes.

Example The minimum past due balance is 100. The adjusted past due balance is 75. A sales order will not go on past due credit hold.

Minimum Past Due Percentage

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the minimum past due percentage that will trigger a past due hold in the Customer field.

Note This rule will only be used if the percentage is greater than 0. If an amount is also entered in the Minimum Past Due Balance field, then both rules must be passed for credit checking purposes.

Example The minimum past due percentage is 10%. The adjusted past due balance is 200 and the total accounts receivable balance is 1,000 (so the past due percent is 20%). A sales order will go on past due credit hold.

Example The minimum past due percentage is 10% and the minimum past due balance is 100. The adjusted past due balance is 200 and the total accounts receivable balance is 1,000 (so the past due percentage is 20%). The sales order will go on past due credit hold because both the balance and the percentage rules were violated.

Include Finance Charges

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to include finance charges in the calculation of adjusted past due balance.

Include Disputed Invoices

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to include disputed invoices in the calculation of adjusted past due balance.

Include Chargebacks

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to include chargebacks in the calculation of adjusted past due balance.

Offset Unapplied Payments

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to use unapplied payments as offsets in the calculation of adjusted past due balance.

Offset On-Accounts

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to use on-account transactions as offsets in the calculation of adjusted past due balance.

Offset Credit Memos

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to use credit memos as offsets in the calculation of adjusted past due balance.

Collection Team Past Due Credit Release

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to allow the collection team to release orders from credit hold if the only credit hold condition is a past due hold. This is sometimes used by larger organizations that have a credit department separate from a collection department. The collection team is sometimes given this option, and these orders appear in Collection Task Management.

Example An order goes on hold for credit limit and past due conditions. This order can only be released by the credit team. An order goes on hold for past due conditions only. This order can be released by the credit team or the collection team if you select this check box.

Credit Limit Tab Fields and Buttons

Field or Button

Description

Credit Limit Hold

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to put sales orders on credit hold if the adjusted accounts receivable balance plus the amount on open sales orders exceeds the credit limit.

Include Disputed Invoices

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want disputed invoices to be included in the calculation of adjusted accounts receivable in the determination of the credit limit hold.

Include Chargebacks

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want chargebacks to be included in the calculation of adjusted accounts receivable in the determination of the credit limit hold.

Credit Alert Tab Fields and Buttons

Field or Button

Description

Use Credit Alerts

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then select the Customer check box if you want to create credit tasks for credit alerts. For more information, see Credit Task Refresh.

Note Unless you are importing payment statistics data, you should not select this check box until you have sufficient data for the comparison months you plan to use.

Comparison Months

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the number of previous full months to use for credit alert calculations in the Customer field. The current month-to-date numbers are additionally used in the calculations.

Example You enter 3 in this field. If it is July 5th, April, May, June, and July (to-date) combined statistics are compared to the low and high trigger values. The next previous 3-month period of January, February, and March is used to determine the trend percentage, and is compared to the low and high trend percentage trigger values.

 Payment Statistics

Select one of the available payment statistics to view or update.

Average Days to Pay (Low Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the average days to pay (ADTP) low trigger amount in the Customer field. When the ADTP is equal to or less than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 30 in this field. If the actual ADTP for the comparison months is 35, no credit task is created.

Average Days to Pay (High Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the average days to pay (ADTP) high trigger amount in the Customer field. When the ADTP is equal to or higher than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 40 in this field. If the actual ADTP for the comparison months is 45, a credit task is created in Credit Task Refresh.

Average Days to Pay (Trend Lower %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the average days to pay (ADTP) trend lower percentage in the Customer field. Based on the comparison months, the average ADTP is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent ADTP is less than next previous ADTP by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter -10 in this field and 3 in the Comparison Months field. It is July 5th and the average ADTP from April-July 5th is 45 and from Jan-Mar is 48. So, the most recent ADTP of 45 minus the next previous ADTP of 48 is -3 days. -3 days divided by 48 equals a -6% trend. Since -6% is greater than the -10% trigger, this trend will not create a credit task.

Average Days to Pay (Trend Higher %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the average days to pay (ADTP) trend higher percentage in the Customer field. Based on the comparison months, the average ADTP is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent ADTP is less than next previous ADTP by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter 10 in this field and 3 in the Comparison Months field. It is July 5th and the average ADTP from April-July 5th is 50 and from Jan-Mar is 35. So, the most recent ADTP of 50 minus the next previous ADTP of 35 is 15 days. 15 days divided by 35 equals a 43% trend. Since 43% is more than the 10% trigger, this trend will create a credit task in Credit Task Refresh.

Weighted Average Days to Pay (Low Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days to Pay (WADTP) low trigger amount in the Customer field. When the WADTP is equal to or less than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 30 in this field. If the actual WADTP for the comparison months is 35, no credit task is created.

Weighted Average Days to Pay (High Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days to Pay (WADTP) high trigger amount in the Customer field. When the WADTP is equal to or higher than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 40 in this field. If the actual WADTP for the comparison months is 45, no credit task is created in Credit Task Refresh.

Weighted Average Days to Pay (Trend Lower %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days to Pay (WADTP) trend lower percentage in the Customer field. Based on the comparison months, the average WADTP is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent WADTP is less than next previous WADTP by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter -10 in this field and 3 in the Comparison Months field. It is July 5th and the average WADTP from April-July 5th is 45 and from Jan-Mar is 48. So, the most recent WADTP of 45 minus the next previous WADTP of 48 is -3 days. -3 days divided by 48 equals a -6% trend. Since -6% is greater than the -10% trigger, this trend will not create a credit task.

Weighted Average Days to Pay (Trend Higher %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days to Pay (WADTP) trend higher percentage in the Customer field. Based on the comparison months, the average WADTP is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent WADTP is less than next previous WADTP by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter 10 in this field and 3 in the Comparison Months field. It is July 5th and the average WADTP from April-July 5th is 50 and from Jan-Mar is 35. So, the most recent WADTP of 50 minus the next previous WADTP of 35 is 15 days. 15 days divided by 35 equals a 43% trend. Since 43% is more than the 10% trigger, this trend will create a credit task in Credit Task Refresh.

Average Days Past Due (Low Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Average Days Past Due (ADPD) low trigger amount in the Customer field. When the ADPD is equal to or less than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 5 in this field. If the actual ADPD for the comparison months is 8, no credit task is created.

Average Days Past Due (High Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Average Days Past Due (ADPD) high trigger amount in the Customer field. When the ADPD is equal to or higher than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 15 in this field. If the actual ADPD for the current month is 20, no credit task is created in Credit Task Refresh.

Average Days Past Due (Trend Lower %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Average Days Past Due (ADPD) trend lower percentage in the Customer field. Based on the comparison months, the average ADPD is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent ADPD is less than next previous ADPD by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter -10 in this field and 3 in the Comparison Months field. It is July 5th and the average ADPD from April-July 5th is 5 and from Jan-Mar is 8. So, the most recent ADPD of 5 minus the next previous ADPD of 8 is -3 days. -3 days divided by 8 equals a -37% trend. Since -37% is less than the -10% trigger, this trend will create a credit task in Credit Task Refresh.

Average Days Past Due (Trend Higher %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Average Days Past Due (ADPD) trend higher percentage in the Customer field. Based on the comparison months, the average ADPD is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent ADPD is less than next previous ADPD by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter 10 in this field and 3 in the Comparison Months field. It is July 5th and the average ADPD from April-July 5th is 50 and from Jan-Mar is 35. So, the most recent ADPD of 50 minus the next previous ADPD of 35 is 15 days. 15 days divided by 35 equals a 43% trend. Since 43% is more than the 10% trigger, this trend will create a credit task in Credit Task Refresh.

Weighted Average Days Past Due (Low Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days Past Due (WADPD) low trigger amount in the Customer field. When the WADPD is equal to or less than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 30 in this field. If the actual WADPD for the comparison months is 35, no credit task is created.

Weighted Average Days Past Due (High Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days Past Due (WADPD) high trigger amount in the Customer field. When the WADPD is equal to or higher than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 40 in this field. If the actual WADPD for the comparison months is 45, a credit task is created in Credit Task Refresh.

Weighted Average Days Past Due (Trend Lower %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Weighted Average Days Past Due (WADPD) trend lower percentage in the Customer field. Based on the comparison months, the average WADPD is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent WADPD is less than next previous WADPD by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter -10 in this field and 3 in the Comparison Months field. It is July 5th and the average WADPD from April-July 5th is 5 and from Jan-Mar is 8. So, the most recent WADPD of 5 minus the next previous WADPD of 8 is -3 days. -3 days divided by 8 equals a -37% trend. Since -37% is less than the -10% trigger, this trend will create a credit task in Credit Task Refresh.

Weighted Average Days Past Due (Trend Higher %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box, and enter the Weighted Average Days Past Due (WADPD) trend higher percentage in the Customer field. Based on the comparison months, the average WADPD is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent WADPD is less than next previous WADPD by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter 10 in this field and 3 in the Comparison Months field.  It is July 5th and the average WADPD from April-July 5th is 50 and from Jan-Mar is 35. So, the most recent WADPD of 50 minus the next previous WADPD of 35 is 15 days. 15 days divided by 35 equals a 43% trend. Since 43% is more than the 10% trigger, this trend will create a credit task in Credit Task Refresh.

Days Sales Outstanding (Low Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Days Sales Outstanding (DSO) low trigger amount in the Customer field. When the DSO is equal to or less than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 5 in this field. If the actual DSO for the comparison months is 8, no credit task is created.

Days Sales Outstanding (High Trigger Amount)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Days Sales Outstanding (DSO) high trigger amount in the Customer field. When the DSO is equal to or more than this amount for the comparison months, a credit task is created in Credit Task Refresh.

Example You enter 5 in this field. If the actual DSO for the comparison months is 3, no credit task is created.

Days Sales Outstanding (Trend Lower %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Days Sales Outstanding (DSO) trend lower percentage in the Customer field. Based on the comparison months, the average DSO is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent DSO is less than next previous DSO by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter -10 in this field and 3 in the Comparison Months field. It is July 5th and the average DSO from April-July 5th is 5 and from Jan-Mar is 8. So, the most recent DSO of 5 minus the next previous DSO of 8 is -3 days. -3 days divided by 8 equals a -37% trend. Since -37% is less than the -10% trigger, this trend will create a credit task in Credit Task Refresh.

Days Sales Outstanding (Trend Higher %)

If you want to override the credit group or credit division settings for this credit rule, select the Override check box. You can then enter the Days Sales Outstanding (DSO) trend higher percentage in the Customer field. Based on the comparison months, the average DSO is calculated for the most recent comparison month period and compared to the next previous comparison month period. If the most recent DSO is less than next previous DSO by this percentage or more, then a credit task is created in Credit Task Refresh.

Example You enter 10 in this field and 3 in the Comparison Months field. It is July 5th and the average DSO from April-July 5th is 50 and from Jan-Mar is 35. So, the most recent DSO of 50 minus the next previous DSO of 35 is 15 days. 15 days divided by 35 equals a 43% trend. Since 43% is more than the 10% trigger, this trend will create a credit task in Credit Task Refresh.

Credit Dates Tab Fields and Buttons

Field or Button

Description

Next Credit Review Date

Enter the next credit review date for the customer, or click the drop-down arrow to select a date. A date must be entered to create a credit task for review dates. For more information, see Refresh Credit Task Refresh.

Next Financial Statement Review Date

Enter the next financial statement review date for the customer, or click the drop-down arrow to select a date. A date must be entered to create a credit task for review dates. For more information, see Refresh Credit Task Refresh.

User Date Fields 1-5

These date labels and dates are user-defined. A date must be entered to create a credit task for review dates. For more information, see Refresh Credit Task Refresh.

Last Invoice Date

Enter the date of the customer's last invoice, or click the drop-down arrow to select a date. This date is updated when invoices are created for the customer. This date may be used to put orders on inactive customer hold.