top of page

Credit Management Part 9 - Blocking Rules

Updated: Nov 2, 2023

Tip of the Day: In Microsoft D365 Finance and Supply Chain (D365 F&SC), Part 9 What’s in Credit Management? This blog is the next part of a multi-part blog series detailing the Credit Management functionality in Dynamics 365 for Finance and Operations. Look for additional releases in this series!


To advance your consulting skills, let me share my Microsoft Dynamics D365 F&SC expertise with you by signing for my post notifications at www.intraclouddynamics.com or www.aliciakeener.com or subscribe to my YouTube Channel @aliciakeener6544




Blocking rules are rules that are setup to determine if an order will be put on hold.

To setup Blocking rules, go to Credit and collections > Setup > Credit management setup > Blocking rules.



There are 9 Blocking Rules. Blocking Rules are setup based on the Customer (Table), and/or Account/Group (Group), and/or Risk Group (Group), or All.

Here’s the hierarchy of how the credit process reads the table (notice that blocking always takes precedence over exclusion).

Table look at Blocking

Table look at Exclusion

Group look at Blocking

Group look at Exclusion

All look at Blocking

All look at Exclusion



· Blocking Rules #1-7

  • Days Overdue – Looks at how many days past due the customer account is to determine if the Sales Order should be put on hold.



  • Account Status – Looks at the customer’s account status to determine if the Sales Order should be put on hold.





  • Terms of Payment – Looks at the Sales Order Terms of Payment to determine if the Sales Order should be put on hold. This is in additional to payment terms ranking. This rule checks for specific payment terms.



  • Credit Limit Expired – This looks at the customer’s credit limit expiration date and adds grace days. If the credit limit has expired and the added grace days are exceeded, the Sales Order will be put on hold if the rule type in = blocking.

Note: This is an important point to pay attention to. . .just because a customer’s credit limit

has expired does not cause an order to go on hold. The setup of these rules is what

determines if the credit expiration date cause the order to go on hold.



  • Overdue Amount – This is a combination of how much the customer is overdue and how much of their credit limit they have used by percent or amount.


This is saying, if US-001 is overdue $10K and over 80% of their credit limit has been used, then, put the order on hold.




  • Sales Order – This looks at the Sales Order amount. The first rule that is looked at is All - Exclusion - Release Sales Order. The All - Exclusion - Release Sales Order combination is unique to this rule because it tells the credit hold logic to look at it first. The reason for this special combination is so that you can setup a “golden rule” so that certain order amounts are never put on hold regardless of how the other 9 rules are setup.


In this example, we’re saying:

- If the Sales Order is $1K or less, do not put the Sales Order on hold.

- If the customer is US-001 and the Sales Order is $20K or less, do not put the Sales Order on hold.

- If the customer is in account/group number = major, and the order is $10K or less, do not put the Sales Order on hold.

- If the order is $500K or more, put the Sales Order on hold.





  • Credit Limit Used – This looks at the customer’s credit limit and calculates the percent used to determine if the order should be put on hold. If the percent of the credit limit has been exceeded, the Sales Order will be put on hold if the rule type in = blocking. If you don’t have this rule setup, then, the customer’s credit limit is not going to be check even though there’s a credit limit setup on the customer’s record.

Note: This is an important point to pay attention to. . .just because a customer has a not used

all their credit limit does not mean they can continue to place orders. The setup of this rule

is what determines if the customer has enough credit for the order.


In this example, we’re saying:

If the customer has used 90% or more of their credit limit but the order on hold.







  • Block Rule #8

o Rank Payment Terms – If the user changes the default Payment Terms on the Sales Order, the hold process looks to see what the new Payment Terms is “ranked” as. . .if the “rank” on the new Payment Terms is different from the “ranking” on the default Payment Terms, this can trigger the Sales Order to be put on Hold so that the order has to be reviewed before the order can be processed.


Here you will see a list of the payment terms that you’ve setup in Accounts Receivable. Beside each of the payment terms, you can enter the rank. The rank is used to determine if the sales order should go on an automatic hold.


For example, if the customer’s default payment terms are Net 1 and the payment terms on the order are changed to Net 10. Since both payment terms have a rank of 1, the system will not trigger a sales order hold. However, if the payment terms on the order are changed to Net 45. Since the customer’s default payment terms has a rank of 1, and the new payment terms has a rank of 4, the system will trigger a sales order hold.


Go to Credit and collections > Setup > Credit management setup > Rank payment terms.







  • Block Rule #9

o Rank Settlement Discounts – Here you will see a list of the cash discounts that you’ve setup in Accounts Receivable. Beside each of the cash discounts, you can enter the rank. The rank is used to determine if the sales order should go on an automatic hold.


For example, if the customer’s default cash discount is 0.5%D10 and the cash discounts on the order are changed to 0.5%D30. Since both cash discounts have a rank of 1, the system will not trigger a sales order hold. However, if the cash discounts on the order are changed to 1%D07. Since the customer’s default cash discounts has a rank of 1, and the new cash discounts has a rank of 2, the system will trigger a sales order hold.


Go to Credit and collections > Setup > Credit management setup > Rank settlement discounts.








Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page