Manage customer account credit limits in Dynamics 365 Finance and Dynamics 365 Customer Insights - Dynamics 365 (2024)

  • Article

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.

Manage customer account credit limits in Dynamics 365 Finance and Dynamics 365 Customer Insights - Dynamics 365 (1)

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 .

  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 stepProcess stageProcess modifiersApp, navigation, and entity
Credit and collections parametersInitialize; Base; ConfigurationGold; At least oneFIN: Credit and collections > Setup > Credit and collections parameters > Credit tab > Credit limit FastTab

DMF: CustomerParameters

Establish customer terms of paymentDesign; Fundamental; ConfigurationGold; At least one is required; Multiple are recommendedFIN: Accounts receivable > Payments setup > Payment days

DMF: PaymentTerm

Establish customer methods of paymentDesign; Fundamental; ConfigurationGold; At least one is required; Multiple are recommendedFIN: Accounts receivable > Payments setup > Methods of payment

DMF: CustomerPaymentMethod

Payment daysDesign; Optional; ConfigurationGold; Multiple are recommendedFIN: Accounts receivable > Payments setup > Payment days

DMF: PaymentDay

Cash discount codesDesign; Optional; ConfigurationGold; Multiple are recommendedFIN: Accounts receivable > Payments setup > Cash discount

DMF: CashDiscount

Set customer credit and termsDesign; Fundamental; OperationsGold; At least one is required; Multiple are recommended; ContinuousFIN: 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 stepProcess stageProcess modifiersApp, navigation, and entity
Credit management reasonsDesign; Fundamental; ConfigurationGold; At least 1; More than one recommendedFIN: Credit and collections > Setup > Credit management setup > Credit management reasons

DMF: CredManBlockReason

Exchange rate typesDesign; Fundamental; ConfigurationEarly; Gold; At least one; More than one recommendedFIN: General ledger > Currencies > Exchange rate types

DMF: ExchangeRateType

Credit and collections parametersDesign; Fundamental; ConfigurationEarly; Gold; At least oneFIN: Credit and collections > Setup > Credit and collections parameters > Credit tab > Credit limit FastTab

DMF: CredManParameters

Credit management workflowsDesign; Optional; ConfigurationGold; More than one recommendedFIN : 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 rulesDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit management > Setup > Credit management setup > Blocking rules

DMF: CredManBlockExclusionRule

Credit management groupsDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit and collections > Setup> Credit management setup > Credit management groups

DMF: CredManGroup, CredManCreditLimitCustGroupLine, CredManCreditLimitCustGroup

Account statusesDesign; Fundamental; ConfigurationEarly; Gold; At least one; More than one recommendedFIN: Credit and collections > Setup> Credit management setup > Account statuses

DMF: CredManAccountStatus

Scoring groupsDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit and collections > Setup> Credit management setup > Risk > Scoring groups

DMF: CredManRiskGroup, CredManCustRiskScore

Guarantee/insurance typesDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit and collections > Setup > Insurance and guarantees > Insurances and guarantee types

DMF: CredManGuaranteeInsuranceType

Coverage typesDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit and collections > Setup > Insurance and guarantees > Coverage types

DMF: CredManInsuranceCoverageType

Automatic credit limitsDesign; Optional; ConfigurationGold; More than one recommendedFIN: Credit and collections > Setup> Credit management setup > Risk > Automatic credit limits

DMF: CredManCreditLimitRule, CredManCreditLimitRuleLine

Set customer credit and termsDesign; Fundamental; OperationalGold; At least one; More than one recommended; ContinuousFIN: Accounts receivable > Customers > All customers

DMF: CustomersV3

Set customer group credit limitDesign; Fundamental; OperationalGold; At least one; More than one recommended; ContinuousFIN: 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 stepProcess stageProcess modifiersApp, navigation, and entity
Enable order completionInitialize; Fundamental; ConfigurationEarly; Gold; At least oneCOM: Retail and commerce > Channel setup > Call center setup > Call center parameters

DMF: N/A

Call center channelInitialize; Fundamental; ConfigurationEarly; Gold; At least oneCOM: Retail and commerce > Channels > Call centers > All call centers

DMF: RetailCallCenter

Call center payment methodsInitialize; Fundamental; ConfigurationEarly; Gold; At least oneCOM: Retail and commerce > Channel setup > Call center setup > Payment methods

DMF: RetailTenderType, RetailStoreTenderType

Check hold parametersInitialize; Fundamental; ConfigurationEarly; Gold; At least oneCOM: Retail and commerce > Channel setup > Call center setup > Call center parameters

DMF: N/A

Create sales orders with check paymentsOperate; Optional; OperationalCOM: Sales and marketing > Sales orders > All sales orders

DMF: SalesOrderV3

Create free text invoices with check paymentsOperate; Optional; OperationalCOM: Accounts receivable > Invoices > All free text invoices

DMF: N/A

Manage check holdsOperate; Optional; OperationalCOM: 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 stepProcess stageProcess modifiersApp, navigation, and entity
Basic credit limit checkingSee the section above for the prerequisites.
Enable on account payments for customersDesign; Configuration; OptionalGold; ContinuousCOM: Sales and marketing > Customers > All customers

DMF: CustomersV3

Enable customer account payment method in Commerce site builderDevelop; Configuration; OptionalCSB: Site setting > Extensions

DMF: N/A

Enable the customer account payment method on the checkout page for the B2B e-commerce siteDevelop; Configuration; OptionalCSB: Checkout page

DMF: N/A

Create call center orders with on account paymentsOperate; Optional; OperationalCOM: Sales and marketing > Sales orders > All sales orders

DMF: SalesOrderV3

Manage call center orders over the credit limitOperate; Optional; OperationalCOM: 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.

  • Manually set customer credit limits
  • Set customer credit limits for a group of customers

Related resources

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

  • Update customer risk scores.

  • Update customer balance statistics.

  • Collect on overdue payments.

  • Blog post: Dynamics 365 Finance Credit Management

  • Configure Accounts receivable and credit and collections

  • Configure accounts receivable in Dynamics 365 Finance

  • Perform accounts receivable daily procedures in Dynamics 365 Finance

  • Set up collections

  • Configure credit and collections in Dynamics 365 Finance

  • Process credit and collections in Dynamics 365 Finance

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

Feedback

Was this page helpful?

Get product support

Feedback

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.

Submit and view feedback for

Manage customer account credit limits in Dynamics 365 Finance and Dynamics 365 Customer Insights - Dynamics 365 (2024)

References

Top Articles
Latest Posts
Article information

Author: Kieth Sipes

Last Updated:

Views: 5433

Rating: 4.7 / 5 (47 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Kieth Sipes

Birthday: 2001-04-14

Address: Suite 492 62479 Champlin Loop, South Catrice, MS 57271

Phone: +9663362133320

Job: District Sales Analyst

Hobby: Digital arts, Dance, Ghost hunting, Worldbuilding, Kayaking, Table tennis, 3D printing

Introduction: My name is Kieth Sipes, I am a zany, rich, courageous, powerful, faithful, jolly, excited person who loves writing and wants to share my knowledge and understanding with you.