Manage customer account credit limits in Dynamics 365 Finance and Dynamics 365 Customer Insights

Applies to: Dynamics 365 Finance, Dynamics 365 Customer Insights, Dynamics 365 Supply Chain Management, Dynamics 365 Commerce

This article describes the setup, configuration, and design considerations for managing customer account credit limits in Dynamics 365 Finance and Dynamics 365 Customer Insights.

Credit limits help financial institutions control the maximum amount of money that a customer can borrow. In other industries, especially industries with business-to-business sales models, credit limits help the organizations restrict the total balance that is unpaid by a specific customer, or the maximum number of products that a customer can order at any given time. This way, organizations can reduce the risk for unpaid balances and the need to write off bad debt. Additionally, it encourages customers that order frequently to keep their accounts current, which helps improve an organization's cash flow.

Dynamics 365 Finance helps organizations define and periodically update customer credit limits. If your organization requires credit limit check in your order-to-cash business processes, the requirement must be included as part of your project. The setup and configuration can be done at any time during the design phase of your project. You can also add the check for credit limit later if you decide not to implement this feature during your initial go-live.

Customer credit limit stakeholders

Many people in an organization should contribute to the decision-making process and design of the process for setting customer credit limits in your Dynamics 365 project. Stakeholders include, but is not limited to the following list:

  • Finance stakeholders – Examples: CFO, Controller, Accounting manager

  • Accounts receivable stakeholders – Examples: Accounts receivable manager, Credit and collections manager

  • Sales stakeholders – Examples: VP of sales, Sales Directors, General Managers

  • Operations stakeholders – Examples: COO, Risk managers, Fraud managers

Set customer credit limits process flow

The following diagram illustrates the business process. Each solid gray rectangle on the diagram represents an end-to-end business process. The solid blue rectangle represents the business process area. The diagram shows the subprocesses for the business process area. The arrows on the diagram show the flow of the business process in an organization. If a subprocess can lead to more than one other subprocess, the parallel subprocesses are shown as branches.

Set customer credit limit process flow diagram.

The process flow diagram includes the following steps.

  1. Create a customer (a prerequisite business process before you start).

  2. Start

  3. Request financial statements, credit references, and/or other pertinent data from customer (manual step).

  4. Gather Dun & Bradstreet data, perform ratio analysis, and so on (manual step).

    Note

    If you use Dynamics 365 Customer Insights and Dun & Bradstreet, use the integration capabilities to automatically gather data about the customer. Learn more at Enrich company profiles with Dun & Bradstreet.

  5. Establish a customer credit rating, and propose terms and credit limit (manual step).

  6. Set credit limit and check mandatory box if applicable in Finance.

  7. Enter credit ratings in Finance.

  8. Optionally, add the DUNS number in Finance.

  9. Choose the payment terms and the method of payment in Finance.

  10. Review and update relevant delivery terms as needed in Finance.

  11. Submit the proposed changes in workflow in Finance.

  12. Review the proposed credit limit, rating, and payment terms in Finance.

  13. Approval

    1. If not approved, adjust the credit limit, alter the terms and the method of payment.

    2. If approved, go to step 14.

  14. The credit limit, rating, terms, and method of payment is automatically saved to the customer record.

  15. End

Steps 3-9 are in one swim lane that's dedicated to an Accounts receivable clerk or Accounts receivable manager.

Steps 10-14 are in another swim lane that's dedicated to an Accounts receivable manager or Accounting manager.

Implementing credit limits for customer accounts

You can define rules in Dynamics 365 Finance to automatically place orders on hold when the criteria are met. When an order is on a credit hold, the order cannot be processed further until the order is released from the hold. Dynamics 365 includes multiple ways to put an order on hold. The following tables and sections describe the various configurations and operational processes that are part of setting customer credit limits in Dynamics 365 applications.

Tip

A variety of terminology and concepts are used throughout this article to describe the business process. For definitions and explanations of key terms and concepts, see Glossary of terms in Dynamics 365 business processes.

The following sections show the configurations available, and the sequence recommended for setting up the configurations from top to bottom. Learn more about the terms used in the table at Business processes, steps, and how to find things.

Basic credit limit checking

(Finance – Credit and collections management)

Use this option when you need to perform a basic credit limit check on Free text invoices, Project invoices, and Sales orders. This option allows you to select the level of warning or error and when the credit limit check will be performed.

Process step Process stage Process modifiers App, navigation, and entity
Credit and collections parameters Initialize; Base; Configuration Gold; At least one FIN: Credit and collections > Setup > Credit and collections parameters > Credit tab > Credit limit FastTab

DMF: CustomerParameters
Establish customer terms of payment Design; Fundamental; Configuration Gold; At least one is required; Multiple are recommended FIN: Accounts receivable > Payments setup > Payment days

DMF: PaymentTerm
Establish customer methods of payment Design; Fundamental; Configuration Gold; At least one is required; Multiple are recommended FIN: Accounts receivable > Payments setup > Methods of payment

DMF: CustomerPaymentMethod
Payment days Design; Optional; Configuration Gold; Multiple are recommended FIN: Accounts receivable > Payments setup > Payment days

DMF: PaymentDay
Cash discount codes Design; Optional; Configuration Gold; Multiple are recommended FIN: Accounts receivable > Payments setup > Cash discount

DMF: CashDiscount
Set customer credit and terms Design; Fundamental; Operations Gold; At least one is required; Multiple are recommended; Continuous FIN: Accounts receivable > Customers > All customers

DMF: CustomersV3

Credit holds

(Finance – Credit and collections management)

Use this option when you need more control over the credit limits and checking process for Sales orders. This option does not work with Project invoices or Free text invoices.

Process step Process stage Process modifiers App, navigation, and entity
Credit management reasons Design; Fundamental; Configuration Gold; At least 1; More than one recommended FIN: Credit and collections > Setup > Credit management setup > Credit management reasons

DMF: CredManBlockReason
Exchange rate types Design; Fundamental; Configuration Early; Gold; At least one; More than one recommended FIN: General ledger > Currencies > Exchange rate types

DMF: ExchangeRateType
Credit and collections parameters Design; Fundamental; Configuration Early; Gold; At least one FIN: Credit and collections > Setup > Credit and collections parameters > Credit tab > Credit limit FastTab

DMF: CredManParameters
Credit management workflows Design; Optional; Configuration Gold; More than one recommended FIN : Credit and collections > Setup > Credit management workflows

Use the Versions > Export and Import buttons on the Credit management workflows page to move configuration between environments.
Blocking rules Design; Optional; Configuration Gold; More than one recommended FIN: Credit management > Setup > Credit management setup > Blocking rules

DMF: CredManBlockExclusionRule
Credit management groups Design; Optional; Configuration Gold; More than one recommended FIN: Credit and collections > Setup> Credit management setup > Credit management groups

DMF: CredManGroup, CredManCreditLimitCustGroupLine, CredManCreditLimitCustGroup
Account statuses Design; Fundamental; Configuration Early; Gold; At least one; More than one recommended FIN: Credit and collections > Setup> Credit management setup > Account statuses

DMF: CredManAccountStatus
Scoring groups Design; Optional; Configuration Gold; More than one recommended FIN: Credit and collections > Setup> Credit management setup > Risk > Scoring groups

DMF: CredManRiskGroup, CredManCustRiskScore
Guarantee/insurance types Design; Optional; Configuration Gold; More than one recommended FIN: Credit and collections > Setup > Insurance and guarantees > Insurances and guarantee types

DMF: CredManGuaranteeInsuranceType
Coverage types Design; Optional; Configuration Gold; More than one recommended FIN: Credit and collections > Setup > Insurance and guarantees > Coverage types

DMF: CredManInsuranceCoverageType
Automatic credit limits Design; Optional; Configuration Gold; More than one recommended FIN: Credit and collections > Setup> Credit management setup > Risk > Automatic credit limits

DMF: CredManCreditLimitRule, CredManCreditLimitRuleLine
Set customer credit and terms Design; Fundamental; Operational Gold; At least one; More than one recommended; Continuous FIN: Accounts receivable > Customers > All customers

DMF: CustomersV3
Set customer group credit limit Design; Fundamental; Operational Gold; At least one; More than one recommended; Continuous FIN: Credit and collections management > Customers > Customer credit groups

DMF: N/A

Sales order holds

(Supply chain management – Sales order management)

Use this option when you need other types of holds, or when you have complex rules that need to be evaluated for sales orders. This option does not work for Project invoices or Free text invoices. Use this option in combination with any other options.

Basic sales order holds can help you manually manage credit limits and credit holds. Fraud rules (an advanced feature of the sales order hold functionality) can be used to automatically check for certain conditions. However, we generally recommend that you consider an alternative approach for managing credit limit checking in Dynamics 365. For more information about how to use sales order holds, see Manage order holds.

Check holds

(Commerce – Call center)

Use this option when you use a call center channel with Dynamics 365 Commerce, and you want to automatically place orders that are paid by check on a hold. The holds can be automatically released after a specified amount of time, or you can use a manual process to release the orders once the check has cleared the bank. You can use this option in combination with the Credit limit workbench option.

Process step Process stage Process modifiers App, navigation, and entity
Enable order completion Initialize; Fundamental; Configuration Early; Gold; At least one COM: Retail and commerce > Channel setup > Call center setup > Call center parameters

DMF: N/A
Call center channel Initialize; Fundamental; Configuration Early; Gold; At least one COM: Retail and commerce > Channels > Call centers > All call centers

DMF: RetailCallCenter
Call center payment methods Initialize; Fundamental; Configuration Early; Gold; At least one COM: Retail and commerce > Channel setup > Call center setup > Payment methods

DMF: RetailTenderType, RetailStoreTenderType
Check hold parameters Initialize; Fundamental; Configuration Early; Gold; At least one COM: Retail and commerce > Channel setup > Call center setup > Call center parameters

DMF: N/A
Create sales orders with check payments Operate; Optional; Operational COM: Sales and marketing > Sales orders > All sales orders

DMF: SalesOrderV3
Create free text invoices with check payments Operate; Optional; Operational COM: Accounts receivable > Invoices > All free text invoices

DMF: N/A
Manage check holds Operate; Optional; Operational COM: COM: Retail and commerce > Channels > Call centers > Check holds

DMF: N/A

Credit limit workbench

(Commerce – Call center)

Use this option when you use a Call center channel with Dynamics 365 Commerce and need to prevent a Sales order or Free text invoice from being processed when the customer balance exceeds the limits you define. This option does not work for Project invoices, and it does not work in combination with the Credit holds option.

Process step Process stage Process modifiers App, navigation, and entity
Basic credit limit checking See the section above for the prerequisites.
Enable on account payments for customers Design; Configuration; Optional Gold; Continuous COM: Sales and marketing > Customers > All customers

DMF: CustomersV3
Enable customer account payment method in Commerce site builder Develop; Configuration; Optional CSB: Site setting > Extensions

DMF: N/A
Enable the customer account payment method on the checkout page for the B2B e-commerce site Develop; Configuration; Optional CSB: Checkout page

DMF: N/A
Create call center orders with on account payments Operate; Optional; Operational COM: Sales and marketing > Sales orders > All sales orders

DMF: SalesOrderV3
Manage call center orders over the credit limit Operate; Optional; Operational COM: Retail and commerce > Channels > Call centers > Credit limits

DMF: N/A

Next steps

If you want to implement Dynamics 365 solutions to assist with your order to cash business processes, use the following resources and steps to learn more. (Links are added, when the articles are ready.)

  1. Set customer credit limits (The article that you're currently reading)

  2. Update customer credit limits

  3. Block or close customer accounts

  4. Handle non-sufficient fund (NSF) payments from customers

  5. Process customer account statements

  6. Dispute and resolve invoice discrepancies

  7. Process and write-off bad debts

  8. Create and process interest notes

  9. Create and process collection letters

  10. Detect fraudulent orders

The following patterns are available to help guide your implementation of the set customer credit limits business process.

Use the following resources to learn more about the processes for setting customer credit limits in Dynamics 365.

Contributors

This article is maintained by Microsoft. It was originally written by the following contributors.

Principal author:

  • Rachel Profitt | Principal Program Manager, FastTrack for Dynamics 365