Order is in Credit Management. D365: Best Practices for Effective Credit Control

Author

Reads 758

A cheerful man holds a credit card indoors, providing ample copy space for text.
Credit: pexels.com, A cheerful man holds a credit card indoors, providing ample copy space for text.

In Dynamics 365, effective credit control is crucial to minimize bad debt and maintain a healthy cash flow. A well-implemented credit management system can help you achieve this.

Setting up a credit limit for each customer is a good starting point, as it allows you to monitor and control the amount of credit extended to each customer. This can be done in the Customer Card in D365.

Having a clear credit policy in place is essential to ensure that all customers are treated fairly and consistently. This policy should outline the terms and conditions of credit, including the payment terms and credit limits.

Regularly reviewing and updating the credit limits and payment terms for each customer is necessary to reflect changes in their creditworthiness. This can be done on a periodic basis, such as quarterly or annually.

Setting Up Rules

To set up blocking rules and exclusion rules, navigate to the Credit management > Setup > Credit management setup > Blocking rules page.

Credit: youtube.com, How to Set Up Credit Blocking Rules in Microsoft D365: Avoid Going Over the Credit Limit

You can create two types of rules: Blocking creates a rule that blocks an order, while Exclusion creates a rule that excludes a rule from blocking an order.

To create a blocking rule, select the type of rule you are setting up, and then choose the Account status that causes the rule to place a sales order on hold.

Eight categories are available for creating blocking and exclusion rules, including Account status, Days overdue, Amount overdue, Terms of payment, and Credit limit expired.

Here are the steps to select the type of rule and Account status:

1. Select the type of rule that you are setting up.

2. Select the Account status that causes the rule to place a sales order on hold or to exclude it.

Note that the Release sales order checkbox is available for all blocking rules, allowing the exclusion rule to release the sales order without considering any other rules that can block sales orders.

Managing Overdue Payments

Credit: youtube.com, How to Streamline Credit & Collections Workflows in Microsoft Dynamics 365

Managing Overdue Payments can be a daunting task, but understanding the basics can make a huge difference. To set up a blocking rule for overdue payments, you need to select the range of customers it applies to.

To specify the range, you'll need to choose an account group, which is a crucial step. If you're using a risk group, you must select an account group first.

A blocking rule is set up by selecting the type of rule and entering the overdue amount before an order is placed on credit management hold. This amount is the threshold that must be exceeded for the rule to trigger.

Here's a quick rundown of the key settings:

By understanding these settings, you can effectively manage overdue payments and keep your credit management on track.

Days Overdue

Managing overdue payments can be a complex task, but it's essential to control cash flow and prevent bad debt.

You can block sales orders for customers with invoices that have been past due for a certain number of days. This is done by selecting the range of customers the rule is valid for and specifying the account or group used in the range.

Credit: youtube.com, Unpaid Invoices | How to Deal with Late-Paying Clients | Collect Money Owed on Overdue Payments

To block sales orders, you need to select a risk group to use criteria for applying a credit management hold. This can include factors like the customer's Dun and Bradstreet rating, years in business, and time as a customer.

The type of rule you're setting up is also crucial. The Blocking option creates a rule that blocks an order, while the Exclusion option creates a rule that excludes another rule from blocking an order.

You can set the number of days overdue allowed for the selected blocking rule before an order is placed on credit management hold for review. For example, you can block sales orders if invoices are more than 61 days past due.

Here's a breakdown of how to set up a blocking rule:

  • Select the range of customers the rule is valid for
  • Specify the account or group used in the range
  • Select a risk group
  • Choose the Blocking option
  • Set the number of days overdue allowed

Note that if you're using a risk group, you must select an account group first. Also, the number of days overdue represents an additional number of grace days added to the number of days beyond the payment due date before the invoice is considered overdue.

Overdue Amount

Credit: youtube.com, Collecting Overdue Payments.

To manage overdue payments effectively, it's essential to understand how to set up blocking rules for customers with outstanding invoices. You can start by selecting the range of customers this rule applies to.

When setting up a blocking rule, you'll need to specify the account or group used in the range. This is crucial in narrowing down the list of customers who will be affected by the rule.

Selecting a risk group can further limit the list of customers who will be placed on credit management hold. However, you must first select an account group before choosing a risk group.

To set up the rule, you'll need to select the type of rule you're creating, which in this case is an "Overdue amount" rule.

The next step is to enter the overdue amount for the selected blocking rule. This is the amount that must be exceeded before a customer is placed on credit management hold for review.

Credit: youtube.com, How To Manage Overdue Payments and Debt Recovery | Business Acceleration Playbook

You can choose from a variety of value types, including percentages, to determine how much of the credit limit has been used. However, for "Overdue amount" rules, you're limited to selecting a percentage.

The final step is to enter the credit limit threshold value for the selected rule. This is the amount that must be exceeded before a customer is placed on credit management hold.

Here's a summary of the steps to set up an "Overdue amount" rule:

  1. Select the range of customers that this rule is valid for.
  2. Specify the account or group used in the range.
  3. Select a risk group if desired.
  4. Select the type of rule (in this case, "Overdue amount").
  5. Enter the overdue amount for the selected blocking rule.
  6. Choose a value type (percentage only for "Overdue amount" rules).
  7. Enter the credit limit threshold value for the selected rule.

Limit Expired

If a customer's credit limit has expired, it can lead to delayed payments and strained relationships. This is where the Credit limit expired tab comes in, helping you manage such situations effectively.

To set up a blocking rule for expired credit limits, select the range of customers it applies to, such as all customers or a specific group. You'll also need to specify the account or group used in the range.

Selecting a risk group further narrows down the list of customers who will be placed on credit management hold. This is a useful step, especially if you're working with multiple account groups.

Credit: youtube.com, Excel Essentials -- Level UP! -- Conditional Formatting for Due Dates and Expiration Dates

The type of rule being set up is also an important consideration. In this case, we're focused on blocking orders due to expired credit limits.

To determine when an order should be placed on credit management hold, enter the number of days the credit limit has been expired. This represents additional grace days added to the expired credit limit.

Payment Terms and Ranking

Payment terms are a crucial aspect of credit management in D365. Selecting the correct terms of payment is essential to ensure that orders are not blocked unnecessarily.

To set up blocking rules, you need to select the type of rule you're setting up, either blocking or exclusion, and then choose the terms of payment that cause the rule to place an order on hold.

You can rank payment terms to force credit control rules to be executed when payment terms are changed. This means assigning a ranking value to each payment term, with higher-ranked terms triggering a credit check.

Credit: youtube.com, Best Use Cases for Credit Management in D365 Finance and Supply Chain

To rank payment terms, go to Credit management > Setup > Credit management setup > Rank payment terms. Here, you can select the payment terms to rank and assign a ranking value, such as 1, 2, 3, or 10, 20, 30.

Note that you can use the same value for most payment terms, so that only one or two payment terms trigger a credit check. This can help streamline your credit management process.

If you change the payment terms on an order to terms that are ranked higher than the old terms, the order will be sent to credit management and require approval.

Here's a summary of the steps to rank payment terms:

  1. Go to Credit management > Setup > Credit management setup > Rank payment terms.
  2. Select the payment terms to rank.
  3. Assign a ranking value to each payment term.

Orders can be excluded from credit management even if there are rules in place, which is useful for certain scenarios.

It's worth noting that there's a bug in the current version of D365 that prevents rank assignment for payment terms, affecting the functionality of blocking sales orders based on payment terms ranking change.

Order and Invoice Management

Credit: youtube.com, Sales Order and Credit Management in 365WineTrade

To manage orders and invoices effectively, it's essential to understand the credit management process in D365. Sales orders can be placed on hold if the blocking rule applies to the value of the sales order, and the range of customers that this rule is valid for must be selected.

You can view the hold list on the All credit holds page, which displays all sales orders placed on hold and the holds removed when the credit issues have been mitigated. This centralized view provides a clear picture of all transactions that require attention.

The hold list can be filtered by various reasons, including overdue invoices, specific account status, and payment terms. The blocking reason is displayed for each sales order in the hold list, and you can view the blocking reasons to understand why the sales order was placed on hold.

Here are the reasons why a sales order can be placed in the hold list:

  1. The customer has an invoice that has been overdue for a specified number of days.
  2. The order has a specific account status.
  3. The order has specific terms of payment.
  4. The customer has an expired credit limit.
  5. The customer has an overdue amount and has used a specified percentage of its credit limit.
  6. The sales order exceeds a certain amount.
  7. The customer has exceeded a certain percentage of its credit limit.
  8. The payment terms differ from the default payment terms for the customer.
  9. The settlement discounts differ from the default settlement discount for the customer.

Setup Sales Order Rules

Credit: youtube.com, Quote, Sales Order, and Invoice Relationship Diagram

To setup sales order rules, you need to select the type of rule that applies to the value of the sales order. This is done by choosing the sales order option from the blocking rule menu.

You then need to select the range of customers that this rule is valid for, and specify the account/group used in the range. Additionally, you can select a risk group to further limit the list of customers that go on credit management hold.

The type of rule you are setting up is also a crucial step, as it determines the behavior of the rule. You can choose from a variety of rule types, including blocking and exclusion rules.

To block a sales order, you need to specify the account status that causes the rule to place a sales order on hold. This can be done by selecting the account status from the blocking rule menu.

Credit: youtube.com, How to create Sales Invoice for the approved Sales Orders?

Here are some examples of blocking rules:

  • Credit Limit Expired category
  • Applied to all customers in the high-risk group
  • Block if credit limit expired for more than 10 days

Note that you can also create exclusion rules that override blocking rules and allow a sales order to be processed. This is done by selecting the exclusion rule type and specifying the account status that excludes the rule.

To activate the sales order rules, you need to enable the blocking rules on the Credit management > Setup > Credit management setup > Blocking rules page.

Consider reading: Order Management System

Improve AR

To improve your accounts receivable management, invest in initiatives that enhance AR effectiveness. This will benefit your organization in the long run.

Setting up rules to place a sales order on credit hold can help fight bad debts and increase cash flows in receivables and credit management. This is especially useful when dealing with clients who have a history of not paying on time.

Maintaining detailed records of labor, items, and/or services is crucial for accurate invoicing. This will help prevent mistakes and misunderstandings with clients.

If this caught your attention, see: Credit Cards Can Help When Paid off on Time Regularly

Credit: youtube.com, Invoices: What You NEED TO KNOW

Billing clients at regular intervals helps prevent delays and ensures a steady cash flow. Make sure to send bills as quickly as possible to keep things on track.

Providing explicit payment conditions on the invoice helps prevent mistakes and ensures clients understand what's expected of them. This includes including all agreed-upon conditions and adhering to them.

Approval and Workflow

Approval and workflow are crucial components of credit management in Dynamics 365. You can create Credit management workflows to control the release of credit holds, which will be sent to the workflow for approval before being released or rejected.

To automate the release process, include tasks for release with posting or release without posting in your workflow. This will enable the workflow approval to release the sales order automatically. However, if there's a failure in the release process, you'll need to recall the sales order, fix the issue, and resubmit it to the workflow.

A rigorous credit approval process is also essential for good AR management. This involves authorizing consumer credit to dependable customers who are more likely to make timely payments, thereby reducing the risk and expectations on your AR teams.

Automatically Releasing

Credit: youtube.com, How to build Power Automate Approval Workflows for SharePoint | Step by Step Tutorial

You can automatically release sales orders from the hold list if the reason for the hold has been mitigated.

To do this, select the Evaluate for release menu and then choose to process all blocking rules or just the selected lines.

A slider will appear so you can select a single customer, but leaving it blank will review all customers.

The process will run in the background, allowing you to continue working on other tasks.

If you select batch processing, the process will run in batch mode, which may take some time to complete.

You can refresh the status of the orders by clicking the Refresh button.

If all blocking reasons are cleared, the sales order can be automatically released.

The Automatically release parameter in Credit and collections > Setup > Credit and collections parameters > Credit > Auto release tab determines whether to post the order automatically or manually.

Credit: youtube.com, Smartsheet Automations: Create Automated Approval Process!

If set to With posting, you'll be prompted to post the document using the posting page.

If set to Without posting, you'll need to post the order manually.

Here's a summary of the steps:

  1. Select the Evaluate for release menu.
  2. Choose to process all blocking rules or just the selected lines.
  3. Leave the customer dropdown blank to review all customers.
  4. Click Ok to start the process.
  5. Refresh the status of the orders periodically.

Approval Workflow

Approval Workflow is a crucial aspect of managing credit and sales orders. You can create Credit management workflows to control the release of credit holds.

These workflows will send orders marked for release or rejection to a workflow where they must be approved first before being released or rejected. If you include tasks for release with posting or release without posting in your workflow, the workflow approval will release the sales order.

If there's a failure in the release process, you can recall the sales order from workflow, fix the issue, and submit it again. This ensures that orders are only released when everything is in order.

A well-designed workflow approval process helps reduce the risk of giving credit to unreliable customers. By setting up a rigorous procedure for authorizing consumer credit, you can guarantee that you give credit to customers who are more likely to make timely payments.

Credit: youtube.com, Create an approval workflow | Approval Process

In Microsoft Dynamics 365, you can automatically place orders on hold using complex rules. These rules can be defined based on various criteria such as days overdue, amount overdue, terms of payment, and credit limit expired.

You can also force an on-hold situation for customer sales orders, and release them automatically if the blocking reasons are changed. For example, if a payment is made, the order can be released automatically.

To activate this functionality, don't forget to turn it on in the Microsoft Feature management screen. This will enable you to balance the credit risk of your customers more effectively.

Cash Application and Collection

In order to manage your accounts receivable effectively, it's essential to have a well-managed cash application process. This process allocates incoming money to the appropriate customer accounts and invoices, reducing inconsistencies and accelerating your accounts receivable.

Cash application has become more complex with the increasing variety of payment options available, including credit cards, electronic debit, Automated Clearing House, wire transfers, and traditional checks. These alternatives make it challenging for cash application professionals to acquire transaction data from different sources.

If this caught your attention, see: Cash Advance from Credit Card to Bank Account

Credit: youtube.com, Collect 365 Credit Management Software for Microsoft Dynamics 365 Business Central.

A strict structure is necessary to ensure that all customers pay on time, which helps prevent the volume of receivables, the cost of financing these receivables, and the risk and expense of bad debts from increasing. This structure is a crucial aspect of accounts receivable management, specifically the collection of funds from clients.

Customer and Sales Order Management

To manage sales orders effectively, you can select the range of customers that a blocking rule is valid for, specifying the account or group used in the range. This helps ensure that the rule applies only to the intended customers.

When setting up blocking rules, you can choose to further limit the list of customers that go on credit management hold by selecting a risk group. However, an account group must be selected first.

To view sales orders placed on hold, you can access the Credit management hold list on the All credit holds page. This list displays all sales orders placed on hold and the holds removed when credit issues have been mitigated.

Credit: youtube.com, Credit and Collections - Credit Management

The Credit management hold list provides a centralized view of all transactions that require attention, showing information for the legal entities that you have access to. You can view the hold list for various reasons, including overdue invoices, specific account status, and exceeded credit limits.

The blocking reason is displayed for each sales order in the hold list, and if there's more than one reason for the hold, the reason displays "Multiple". You can use blocking reasons to view the reasons why the sales order was placed on hold.

Here are some common reasons why a sales order can be placed in the hold list:

  • The customer has an invoice that has been overdue for a specified number of days.
  • The order has a specific account status.
  • The order has specific terms of payment.
  • The customer has an expired credit limit.
  • The customer has an overdue amount and has used a specified percentage of its credit limit.
  • The sales order exceeds a certain amount.
  • The customer has exceeded a certain percentage of its credit limit.
  • The payment terms differ from the default payment terms for the customer.
  • The settlement discounts differ from the default settlement discount for the customer.

To manage active order holds, you can evaluate for release, reject with reason, or release with/without posting.

General Configuration and Parameters

To configure general parameters for credit management in D365, navigate to Credit and Collections → Setup → Credit and Collection Parameters. You can then expand the Credit Management Checkpoint tab to access various triggers for auto checks.

Credit: youtube.com, Credit Management Configurations and End to End Demo in Microsoft Dynamics 365 Finance & Operations

Five triggers are available for auto checks, which decide if a sales order will be placed on hold. These triggers can be customized with grace days, such as 2 days for confirmation and picking list steps.

To define grace days for each check, you can specify the number of days allowed before a sales order is placed on hold. This can help prevent unnecessary holds and improve the overall order management process.

Limit Used

To set up a blocking rule based on the credit limit used, you'll need to select the "Credit limit used" option. This type of rule applies to the customer credit limit amount utilized.

The first step is to select the range of customers that this rule is valid for. You'll need to choose from a list of options to determine which customers will be affected by this rule.

After selecting the range, you'll need to specify the account or group used in that range. This will help narrow down the list of customers that will be subject to the rule.

Close-up of a man holding a wallet with various credit cards, showcasing everyday finance essentials.
Credit: pexels.com, Close-up of a man holding a wallet with various credit cards, showcasing everyday finance essentials.

If you want to further limit the list of customers that go on credit management hold, you can select a risk group. However, if you're using a risk group, you'll need to select an account group first.

Next, you'll need to select the type of rule you're setting up, which in this case is "Credit limit used". This will ensure that the rule is applied correctly.

Finally, you'll need to specify the threshold remaining, which defines the percentage of the credit limit that will block the sales order. If the value of an order increases the amount of the credit limit used above this percentage, the order will be placed on hold.

Parameters Configuration

In the Credit and Collections section, you'll find the Parameters Configuration settings that determine how your sales orders are handled.

To access these settings, navigate to Credit and Collections → Setup → Credit and Collection Parameters.

There are five triggers available for auto checks, which decide if a sales order will be placed on hold.

You can define grace days for each check, such as 2 days for confirmation and picking list steps.

Invoicing and Accounting

Credit: youtube.com, How to create and post a credit note for a purchase order based vendor invoice in D365 Finance

Invoicing and Accounting is a crucial part of credit management in D365, as it directly affects customer relations and cash flow. A well-managed invoicing process ensures timely payments and reduces the time spent on collections.

To charge professionally and efficiently, maintain detailed records of labor, items, and services billed. This helps prevent mistakes and ensures accurate invoicing.

Regular billing intervals can help prevent delays and ensure timely payments. Sending bills promptly is essential, as it helps maintain a smooth accounts receivable process.

Free Text Invoice & Order Support

Free text invoices, orders, and project invoices don't currently use the credit management system's blocking rules and hold list. This means they won't be flagged if there's an issue with the credit limit.

For sales orders, credit management is available, but for free text invoices, point of sales orders, and call center orders, temporary credit limits and insurance/guarantees are used to adjust the credit limit.

Project invoices are not supported in credit management, so you'll need to use temporary credit limits and insurance/guarantees for those as well.

To ensure accurate invoicing, it's essential to maintain detailed records of labor, items, and services billed, and provide explicit payment conditions to prevent mistakes.

Invoicing

Credit: youtube.com, Difference between Purchase Order and Invoice Accounts Payable

Invoicing is a critical part of the accounts receivable process, and it's essential to get it right to ensure smooth cash flow and customer relationships.

To start, make sure your bills are correct by keeping detailed records of labor, items, and services provided. This will help prevent errors and misunderstandings with clients.

Providing explicit payment conditions on the invoice is also crucial to avoid any mistakes. Include all agreed-upon conditions to ensure transparency and trust with your customers.

Determine how often to bill clients and stick to regular intervals to prevent delays. Sending bills promptly will help maintain a positive cash flow.

Ensure your bills are easy to understand and look professional. Include payment arrangements and due dates to avoid any confusion.

For another approach, see: Do Credit Cards Help Your Credit Score

Felicia Koss

Junior Writer

Felicia Koss is a rising star in the world of finance writing, with a keen eye for detail and a knack for breaking down complex topics into accessible, engaging pieces. Her articles have covered a range of topics, from retirement account loans to other financial matters that affect everyday people. With a focus on clarity and concision, Felicia's writing has helped readers make informed decisions about their financial futures.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.