Quick answer: Business Central integrates with Dynamics 365 Sales through Microsoft Dataverse, allowing selected ERP and CRM data to be synchronised between the two applications. Depending on the configured mappings and synchronisation settings, businesses can connect customers, contacts, products, pricing, sales orders and other relevant records to create a more connected sales-to-operations process.
For businesses using Microsoft Dynamics 365 Business Central for finance, inventory and operations and Dynamics 365 Sales for customer and sales management, integration can reduce duplicate data entry and give sales teams access to relevant operational information without moving between disconnected systems.
Table of Contents
- What is Business Central Integration with Dynamics 365 Sales?
- How Does Business Central and Dynamics 365 Sales Integration Work?
- What Data Can Be Synchronized Between Business Central and Dynamics 365 Sales?
- Business Central Integration with Dynamics 365 Sales: Key Benefits
- Business Central vs Dynamics 365 Sales: Why Integrate Both?
- How to Integrate Business Central with Dynamics 365 Sales
- Business Central and Dynamics 365 Sales Data Mapping
- Can Business Central and Dynamics 365 Sales Synchronise Sales Orders?
- Common Business Central and Dynamics 365 Sales Integration Challenges
- Business Central and Dynamics 365 Sales Integration Use Cases
- Business Central Integration with Dynamics 365 Sales for UK Businesses
- When Should You Integrate Business Central with Dynamics 365 Sales?
- Business Central Integration with Dynamics 365 Sales: Implementation Considerations
- How Dynamics Square Can Help with Business Central Integration
- Related Dynamics 365 Resources
- Frequently Asked Questions
What is Business Central Integration with Dynamics 365 Sales?
Business Central Integration with Dynamics 365 Sales connects Microsoft's ERP and CRM applications through Microsoft Dataverse. Business Central manages core business processes such as finance, purchasing, inventory and order processing, while Dynamics 365 Sales is designed around leads, opportunities, accounts, contacts and sales activities.
The integration allows selected information to move between the two systems according to configured integration table mappings, field mappings and synchronisation rules. Records can also be coupled between Business Central and Dynamics 365 Sales so that related information can be synchronised between the applications.
This means a sales team can work in Dynamics 365 Sales while accessing relevant ERP information from Business Central, rather than relying on spreadsheets, manual updates or repeated data entry.
How Does Business Central and Dynamics 365 Sales Integration Work?
The integration uses Microsoft Dataverse as the connection layer between Business Central and Dynamics 365 Sales. Microsoft provides standard integration settings and mappings for common sales scenarios, while businesses can modify mappings when their processes require additional fields or different synchronisation logic.
Business Central
Finance, inventory, products, customers, orders and operations
↓
Microsoft Dataverse
Integration layer, table mappings, field mappings and synchronisation
↓
Dynamics 365 Sales
Accounts, contacts, leads, opportunities, quotes and sales activities
Microsoft's current documentation identifies integration table mappings, integration field mappings, synchronisation rules and coupled records as key parts of the synchronisation process.
Does Business Central integration with Dynamics 365 Sales work in real time?
Not necessarily. This is an important distinction when planning the integration.
Business Central can synchronise data with Dataverse on a scheduled basis using synchronisation jobs. Microsoft notes that scheduled synchronisation does not guarantee real-time data consistency between the two services. Businesses that require real-time scenarios may need to consider options such as Business Central virtual tables or APIs, depending on the specific requirement.
Therefore, the integration should be designed around the required business process rather than assuming every record will update instantly in both systems.
What Data Can Be Synchronized Between Business Central and Dynamics 365 Sales?
Business Central provides standard mappings between several Business Central tables and Dynamics 365 Sales entities. The exact synchronisation direction depends on the entity and configuration.
| Business Central | Dynamics 365 Sales | Typical use |
|---|---|---|
| Customer | Account | Customer and account information |
| Contact | Contact | Contact information |
| Item | Product | Product catalogue and product information |
| Resource | Product | Service or resource products |
| Unit of Measure | Unit Group | Product measurement information |
| Sales Price | Price List | Pricing information |
| Sales Order | Order | Sales order processing |
| Salesperson/Purchaser | User | Salesperson information |
These are examples of Microsoft's standard integration mappings. Additional mappings and field-level logic can be configured where a business needs to support customised processes.
Business Central Integration with Dynamics 365 Sales: Key Benefits
1. Connect sales and back-office operations
Dynamics 365 Sales gives sales teams dedicated tools for managing leads, accounts and opportunities, while Business Central manages the operational and financial side of the business. Integration connects these processes so that sales and operations can work from related business information.
2. Reduce duplicate data entry
When the same customer, product or order information has to be entered into separate applications, businesses can create duplicate records and manual errors. Configured synchronisation can reduce unnecessary rekeying between Business Central and Dynamics 365 Sales.
3. Give sales teams access to relevant ERP information
Salespeople may need information about products, prices, inventory or orders when dealing with customers. Connecting Dynamics 365 Sales with Business Central can make relevant operational information available within the wider sales process.
4. Improve customer and account visibility
Customer information can be synchronised between Business Central and Dynamics 365 Sales, helping teams maintain a more consistent view of accounts and contacts across CRM and ERP processes.
5. Support a connected quote-to-order process
When the sales process moves from opportunity and quotation towards order fulfilment, integration can connect CRM activities with Business Central's order and operational processes.
6. Create a foundation for further Microsoft integrations
Dataverse is used across Microsoft's business application ecosystem. Once the core integration is designed correctly, businesses can consider additional integrations involving Power Platform and other Dynamics 365 applications where appropriate.
For broader integration requirements, see our Dynamics 365 Business Central Integration Guide.
Business Central vs Dynamics 365 Sales: Why Integrate Both?
Business Central and Dynamics 365 Sales have different primary roles, so businesses do not necessarily need to choose between them.
| Business Central | Dynamics 365 Sales |
|---|---|
| ERP platform | CRM platform |
| Financial management | Lead management |
| Inventory management | Opportunity management |
| Purchasing and supply chain | Account and contact management |
| Sales orders and invoicing | Sales activities and pipeline management |
| Operations and fulfilment | Customer engagement |
Business Central includes sales and customer management functionality, but organisations with more complex sales processes may require the dedicated capabilities available in Dynamics 365 Sales.
Read our detailed Business Central vs Dynamics 365 Sales comparison to understand how the two applications differ.
How to Integrate Business Central with Dynamics 365 Sales
The exact implementation process depends on your Business Central environment, Dynamics 365 Sales configuration, data structure and integration requirements. However, the core process generally involves the following stages.
1. Review your existing Business Central and Dynamics 365 Sales environments
Start by identifying which applications, companies, environments, users and business processes need to be connected. Review existing customisations and third-party integrations before changing the integration architecture.
2. Connect Business Central with Microsoft Dataverse
For new integrations between Business Central and Dynamics 365 Sales, Microsoft uses Dataverse as the integration layer. The assisted setup experience helps configure the connection and relevant integration settings.
3. Configure integration table mappings
Integration table mappings establish the relationship between Business Central tables and Dataverse or Dynamics 365 Sales entities.
For example, a Business Central customer can be mapped to an account in Dataverse. The mapping determines which records are considered equivalent between the systems.
4. Configure integration field mappings
Table mapping is only part of the process. Field mappings determine which fields in Business Central correspond with columns in Dataverse.
This is particularly important when your organisation uses custom fields, different naming conventions or specific business rules.
5. Configure record coupling
Coupling links a Business Central record with its corresponding Dataverse or Dynamics 365 Sales record. Coupled records can then participate in synchronisation according to the configured mappings.
6. Select the data that needs to synchronise
Do not automatically synchronise every available record. Identify the data required for your sales and operational processes, such as customers, contacts, products, pricing and sales orders.
7. Test synchronisation before going live
Test representative records and business scenarios before enabling the integration for production users. Check customer matching, product information, pricing, order data, permissions and synchronisation errors.
8. Monitor synchronisation jobs
After deployment, monitor synchronisation jobs and investigate failures promptly. A successful integration is not only about connecting the systems; it also requires ongoing monitoring and maintenance.
Microsoft provides dedicated guidance for setting up the integration, configuring mappings, coupling records and synchronising data between Business Central and Dynamics 365 Sales.
Business Central and Dynamics 365 Sales Data Mapping
Data mapping is one of the most important parts of the integration. A poorly designed mapping can result in duplicate records, missing information or incorrect values being transferred between systems.
Before implementation, define:
Which system is the source for each data type.
Which fields need to be synchronised.
Which fields are mandatory.
How duplicate records will be identified.
Which records should be created automatically.
Which records should only be updated.
Which direction the data should synchronise.
How custom fields and values should be translated between systems.
Microsoft allows integration field mappings to be modified when the standard configuration does not match an organisation's requirements.
Can Business Central and Dynamics 365 Sales Synchronise Sales Orders?
Yes. Business Central supports sales-order integration scenarios with Dynamics 365 Sales, including bidirectional synchronisation options depending on the configured setup.
This can help connect the CRM sales process with Business Central's order processing and fulfilment activities. However, the exact behaviour depends on the integration configuration and the version and setup of the applications.
Microsoft's current training content specifically covers configuring bidirectional sales-order synchronisation between Business Central and Dynamics 365 Sales. Read more about - Sales Order Agent Explained: Features, Setup, and Benefits.
Common Business Central and Dynamics 365 Sales Integration Challenges
Data duplication
Customer and contact records can become difficult to manage when the two applications contain overlapping data. Define matching and coupling rules before synchronisation.
Custom fields and processes
Standard mappings may not cover every business requirement. Custom fields and workflows may require additional mapping or development.
Different data structures
The same business concept may be represented differently in Business Central and Dynamics 365 Sales. Field mapping and transformation rules need to account for these differences.
Synchronisation errors
Integration jobs can fail because of missing values, invalid mappings, permissions, configuration problems or incompatible data. Monitoring and troubleshooting processes should therefore be included in the implementation plan.
Incorrect assumptions about real-time synchronisation
Not every integration scenario provides instant updates. Scheduled synchronisation and real-time requirements should be treated as separate architectural considerations.
Large data volumes
Initial synchronisation can involve a significant amount of historical data. Businesses should decide what needs to be migrated or synchronised rather than transferring unnecessary records.
Business Central and Dynamics 365 Sales Integration Use Cases
Wholesale and distribution
A sales representative can work with customer and product information in Dynamics 365 Sales while Business Central manages inventory, purchasing, orders and finance.
Manufacturing
Manufacturers can connect their sales process with operational data in Business Central, helping sales teams work with relevant product and order information.
For manufacturing-specific ERP requirements, see our guide to Dynamics 365 for manufacturing.
Professional services
Professional services businesses can use Dynamics 365 Sales for opportunity and account management while Business Central supports financial and operational processes.
Growing B2B businesses
As a B2B organisation grows, sales data and operational data often become increasingly difficult to manage manually. Connecting CRM and ERP systems can create a more structured sales-to-order workflow.
Business Central Integration with Dynamics 365 Sales for UK Businesses
For UK organisations, integration planning should consider more than simply connecting two applications. Your implementation should reflect the way your teams manage customers, pricing, sales orders, finance, inventory and reporting.
It is also important to review existing Microsoft applications and integrations before introducing another connection. For example, organisations already using Power BI, Power Apps, Power Automate, Microsoft Teams or other Dynamics 365 applications may benefit from designing the integration as part of a wider Microsoft business application architecture.
If you are moving from an older ERP platform, you may also want to review our Business Central integration guide before defining your integration roadmap.
When Should You Integrate Business Central with Dynamics 365 Sales?
Integration may be worth considering when:
Your sales team needs access to ERP information.
Customer data is maintained in more than one system.
Sales orders are manually re-entered into Business Central.
Sales and finance teams use disconnected data.
Product and pricing information needs to be shared between CRM and ERP.
Manual data transfer is creating errors or delays.
Your sales process is becoming too complex for basic ERP sales functionality.
If your requirement is primarily finance, inventory and operations, Business Central may be sufficient on its own. If you need more advanced CRM and sales pipeline capabilities, Dynamics 365 Sales can complement Business Central.
Businesses that need both can design an integrated CRM and ERP environment rather than managing the two applications separately.
Business Central Integration with Dynamics 365 Sales: Implementation Considerations
Before starting the project, document the integration requirements clearly.
| Area | Questions to answer |
|---|---|
| Data | Which customers, products, contacts and transactions need to synchronise? |
| Ownership | Which application is the source of truth for each data type? |
| Mapping | Which Business Central fields correspond to Dynamics 365 Sales fields? |
| Frequency | Does the process require scheduled or more immediate data access? |
| Customisation | Are custom fields, workflows or entities involved? |
| Security | Which users need access to integrated information? |
| Testing | Which sales and operational scenarios must be tested before launch? |
| Support | Who will monitor integration jobs and resolve synchronisation issues? |
How Dynamics Square Can Help with Business Central Integration
Connecting Business Central with Dynamics 365 Sales is not simply a matter of switching on synchronisation. The integration needs to reflect your sales process, data structure, customisations and operational requirements.
Dynamics Square UK helps businesses plan and implement Microsoft Dynamics 365 solutions, including Business Central, Dynamics 365 Sales, CRM integration and wider Microsoft business application projects.
Our team can help you assess your existing systems, define the required data mappings, configure the integration, test synchronisation and support your users after implementation.
Need help with Business Central Integration with Dynamics 365 Sales?
Speak to Dynamics Square UK about your CRM and ERP integration requirements. We can help you understand what should be synchronised, how the integration should be structured and what implementation approach fits your business.
Contact Dynamics Square UK for a Business Central integration consultation
Related Dynamics 365 Resources
Ready to connect Business Central and Dynamics 365 Sales? Contact Dynamics Square UK to discuss your integration requirements.
Frequently Asked Questions
Business Central Integration with Dynamics 365 Sales connects Microsoft's ERP and CRM applications through Dataverse. It allows selected data to be synchronised between Business Central and Dynamics 365 Sales according to configured table mappings, field mappings and synchronisation rules.
Business Central integrates with Dynamics 365 Sales through Microsoft Dataverse. The integration uses table mappings, field mappings, synchronisation rules and record coupling to connect relevant data between the two applications.
Depending on the configured integration, businesses can synchronise data such as customers, contacts, products, units of measure, pricing, sales orders and salesperson information. Microsoft provides standard mappings that can also be modified to support specific business requirements.
Yes. Business Central supports sales-order integration scenarios with Dynamics 365 Sales, including bidirectional synchronisation options depending on the configuration.
Not necessarily. Standard scheduled synchronisation does not guarantee real-time data consistency. The appropriate integration approach depends on the business requirement, and real-time scenarios may require alternative options such as APIs or virtual tables.
Microsoft Dataverse provides the integration framework that connects Business Central with Dynamics 365 Sales and other Dynamics 365 applications. It supports the tables, mappings and synchronisation processes required to exchange selected data.
A standard integration can use Microsoft's assisted setup and standard mappings. However, businesses with custom fields, complex workflows, non-standard processes or additional integration requirements may need technical configuration or development support.
Common challenges include data mapping, duplicate records, custom fields, permissions, synchronisation errors, different data structures and deciding which application should be the source of truth for specific information.
No. Dynamics 365 Sales and Business Central have different primary purposes. Dynamics 365 Sales focuses on CRM and sales processes, while Business Central manages ERP processes such as finance, inventory, purchasing and operations. Businesses may use both applications together when they need connected CRM and ERP capabilities.
The cost depends on factors such as the applications involved, number of users, data volume, customisations, number of entities, integration requirements and implementation effort. A standard integration will generally require less work than a highly customised CRM and ERP environment.
For a clearer understanding of your requirements, speak with a Dynamics 365 integration specialist before estimating the implementation scope.
.png&w=3840&q=75&dpl=dpl_5tNRQp1WB9jPSaWp811oqqAvwXpn)