Dynamics 365 Business Central. Get help from experts and peers in forums, discover blogs, webinars, videos, events, and more. Twitter Feed Twitter Feed. Upcoming Events Adapt. Learn from and connect with your world-wide community - register for the Microsoft Business Applications Summit on May 4, 2021. Dynamics 365 Business Central Connect your financials, sales, service, and operations with an all-in-one business management solution. Easily tailor and extend the application to meet your business or industry-specific needs. Get Dynamics 365 Business Central. Customers are moving to the cloud with Business Central Ullman Dynamics breaks through growth barriers Replacing legacy infrastructure unlocked the flexibility, efficiency, and insight needed to deliver better service to the company’s growing client base. Dynamics 365 Business Central is a cloud-based ERP software that gives small and medium-sized businesses robust features to help them to manage their businesses more efficiently and profitably. Microsoft Dynamics 365 Business Central empowers users with cloud technology. It allows companies to integrate their business processes with Office 365.
The app displaying the Business Central tablet client and Business Central phone client is targeted at users in small and medium sized businesses that want to access data from a tablet or a phone. The main advantages of this offering are portability and flexibility, which allows end users to perform tasks when they are away from their desk. Having a Dynamics 365 Business Central solution that runs on a smaller device also brings it in the hands of many more users and your app is easy to distribute.
Important
The Business Central tablet client and Business Central phone client do not replace the Business Central Web client. Instead, they offer a touch interface for a limited set of application scenarios compared to the Business Central Web client.
The Business Central Web client supports more complex business processes and heavier data entry than it is possible on the Business Central tablet client and Business Central phone client. Business Central is also designed for intensive use, and the user can have multiple windows open at the same time, but this is neither possible in Business Central phone client or Business Central tablet client. For more information, see Differences and Limitations When Developing Pages for the Business Central Mobile App.
The design for the Business Central tablet client is optimized for the touch experience and reduced use of the on-screen keyboard.On the other hand, the design for the Business Central phone client is about touch optimization, given its smaller screen size. The Business Central phone client layout is designed to support one-hand and both hands use, which allows the important data and buttons to be available within thumbs reach.
Note
In this documentation, you will see mentions of Business Central tablet client, Business Central phone client, and Dynamics 365 Business Central Mobile App. Business Central tablet client and Business Central phone client describe the interface tailored to the category of mobile device, which is one of the tools available for developers for designing mobile solutions, whereas Dynamics 365 Business Central Mobile App is the common name for the app across all devices; the end result made with these tools.
Considering the user scenarios
When you design your solution for the Business Central tablet client and the Business Central phone client, you must make sure that scenarios are simple enough to be meaningful and usable. The tablet and phone designs are meant for lighter tasks and are useful, for example, for traveling salespeople or service technicians who need a portable, online, easy-to-use app that provides an overview, for example, of daily tasks and items in stock.
Depending on the scenarios that your tablet and phone solution will support, it will either make sense to create a new Role Center for tablet and phone only, or share the same Role Center across all of the client types. In some cases, it can make sense to have a user sign in with two different profiles, one for a desktop client and one for mobile devices. In other cases, duplicating pages and designing specific duplicates to be device-oriented is the best solution.
If you have existing page objects that you want to make available on Business Central tablet client or Business Central phone client, we strongly recommend that you plan time to evaluate carefully which actions, sections, and fields will be needed for the user scenarios you want to enable. Fields and actions that are not needed should not be visible to users of your app. The UI must be simplified significantly to work well on a small device. For more information, see Designing for Different Screen Sizes on Tablet and Phone.
Supported credential types
Business Central tablet client and Business Central phone client support the same credential types as Business Central Web client. For more information, see Authentication and Credential Types.
See Also
Getting Started Developing for the Dynamics 365 Business Central Mobile App
Differences and Limitations When Developing Pages for the Dynamics 365 Business Central Mobile App
Note
Effective November 2020:
- Common Data Service has been renamed to Microsoft Dataverse. Learn more
- Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more
The sales person role is often considered as one the most outward-facing jobs in a business. However, it can be helpful for sales people to be able to look inward in the business and see what is happening on the back end. By integrating Business Central and Dynamics 365 Sales, you can give your sales people that insight by enabling them to view information in Business Central while they are working in Dynamics 365 Sales. For example, when preparing a sales quote it could be useful to know whether you have enough inventory to fulfill the order. For more information, see Using Dynamics 365 Sales from Business Central.
Note
This topic describes the process of integrating the online versions of Dynamics 365 Sales and Business Central through Dataverse. For information about on-premises configuration, see Preparing Dynamics 365 Sales for Integration on-premises.
Integrating Through Dataverse
Business Central also integrates with Dataverse, which makes it easy to connect and synchronize data with other Dynamics 365 applications, such as Dynamics 365 Sales, or even apps that you build yourself. If you are integrating for the first time, we recommend that you do so through Dataverse. For more information, see Integration with Dataverse.
If you have already integrated Dynamics 365 Sales with Business Central, you can continue to synchronize data using your setup. However, if you upgrade or turn off your Dynamics 365 Sales integration, to turn it on again you must connect through Dataverse. For more information, see Upgrading an Integration with Dynamics 365 Sales.
Note
Reconnecting through Dataverse will apply default synchronization settings, and will overwrite any configurations you have. For example, the default table mappings will be applied.
Integration Settings that are Specific to a Dynamics 365 Sales Integration
Integration with Business Central happens through Dataverse, and there are a lot of standard settings and tables that are provided by the integration. In addition to the standard settings, there are some that are specific to Dynamics 365 Sales. The following sections list those.
Permissions and Security Roles for User Accounts in Sales
When you install the Integration Solution, permissions for the integration user account are configured. If those permissions are changed you might need to reset them. You can do that by reinstalling the Integration Solution by choosing Redeploy Integration Solution on the Dynamics 365 Connection Setup page. The following security roles are deployed:
- Dynamics 365 Business Central Integration Administrator
- Dynamics 365 Business Central Integration User
- Dynamics 365 Business Central Product Availability User
Connection Settings in the Setup Guide
You can use an assisted setup guide to quickly set up the connection and specify advanced features, such as coupling between records.
- Choose Setup and Extensions, and then choose Assisted Setup.
- Choose Set up the Dynamics 365 Sales Connection to start the assisted setup guide.
- Fill in the fields as necessary.
- Optionally, there are advanced settings that can enhance security and enable additional capabilities, such as sales order processing and viewing inventory levels. The following table describes the advanced settings.
| Field | Description |
|---|---|
| Import Dynamics 365 Sales Solution | Enable this to install and configure the integration solution in Dynamics 365 Sales. |
| Publish Item Availability Web Service | Enable people who are using Dynamics 365 Sales to view the availability of items (products) in inventory in Business Central. This requires a Business Central user account with a web services access key. Assigning the key is a two-step process. On the user account in Business Central you must choose the Change Web Service Key action. In the Set Up Dynamics 365 Sales Connection assisted setup guide, you must specify the Dynamics 365 Business Central OData web service URL, and provide Business Central user credentials for accessing the service. For more information, see OData Web Services. |
| Business Central OData Web Service URL | If you enable the web service for viewing item availability, the URL for the OData Web service is provided for you. |
| Business Central OData Web Service Username | The name of the Business Central user account that Dynamics 365 Sales uses to retrieve information about item availability in Business Central through the OData web service. |
| Business Central OData Web Service Accesskey | The access key for the user account that Dynamics 365 Sales uses to get information about item availability from Business Central through the OData web service. The key is assigned to the user chosen in the Business Central OData Web Service Username field. To get the key, choose the Look up value button next to the user name, choose the user, choose Manage, and then Edit. On the user card, choose Actions, Authentication, and then choose Change Web Service Key. |
| Enable Sales Order Integration | When people create sales orders in Dynamics 365 Sales and fullfill orders in Business Central, this integrates the process in Dynamics 365 Sales. For more information, see Enable sales order processing integration. This requires that you provide credentials for an administrator user account in Dynamics 365 Sales. For more information, see Handling Sales Order Data. |
| Enable CDS Connection | Enable the connection to Dataverse. |
| Dynamics 365 SDK Version | This is relevant only if you are integrating with an on-premises version of Dynamics 365 Sales. This is the Dynamics 365 software development kit (also referred to as Xrm) you use to connect Business Central to Dynamics 365 Sales. The version must be compatible with the SDK version that is used by Dynamics 365 Sales, and equal to or newer than the version used by Dynamics 365 Sales. |
Connection Settings on the Microsoft Dynamics 365 Connection Setup Page
Enter the following information for the connection from Dynamics 365 Sales to Business Central.
| Field | Description |
|---|---|
| Dynamics 365 Sales URL | The URL of your Dynamics 365 Sales instance. This enables users to open corresponding records in Business Central from records in Dynamics 365 Sales, such as an account or product. The Business Central records open in Business Central. |
| Dynamics 365 Sales URL | The URL of your Dynamics 365 Sales instance. This enables users to open corresponding records in Business Central from records in Dynamics 365 Sales, such as an account or product. The Business Central records open in Business Central. |
| Item Availability Web Service Enabled | Enable people who are using Dynamics 365 Sales to view the availability of items (products) in inventory in Business Central. If you enable this, you must also provide a user name and an access key for the Dynamics 365 Sales to use to query OData Web Service for availability of items (products). For more information, see OData Web Services. |
| Dynamics 365 Business Central OData Web Service URL | If you enable the Item Availability Web Service, the URL for the OData Web service is provided for you. Set this field to the URL of the Business Central instance to use. To reset the field to the default URL for the Business Central, choose Reset Web Client URL action. This field is relevant only if the Business Central Integration Solution is installed in Dynamics 365 Sales. |
| Dynamics 365 Business Central OData Web Service Username | The name of the user account that the Dynamics 365 Sales uses to get information about item availability from Business Central through OData Web service. |
| Dynamics 365 Business Central OData Web Service Accesskey | The access key for the user account that the Dynamics 365 Sales uses to get information about item availability from Business Central through OData Web service. The key is assigned to the user chosen in the Dynamics 365 Business Central OData Web Service Username field. To get the key, choose the Look up value button next to the user name, choose the user, choose Manage, and then Edit. On the user card, choose Actions, Authentication, and then choose Change Web Service Key. |
| Dynamics 365 SDK Version | If you are integrating with an on-premesis version of Dynamics 365 Sales, this is the Dynamics 365 software development kit (also referred to as Xrm) you use to connect Business Central to Dynamics 365 Sales. The version that you select must be compatible with the SDK version that is used by Dynamics 365 Sales. This version equal to or newer than the version used by Dynamics 365 Sales. |
In addition to the settings above, enter the following settings for Dynamics 365 Sales.
| Field | Description |
|---|---|
| Sales Order Integration is Enabled | Enable users to submit sales orders and activated quotes in Dynamics 365 Sales and then view and process them in Business Central. This integrates the process in Dynamics 365 Sales. For more information, see Enable sales order processing integration. |
| Automatically Create Sales Orders | Create a sales order in Business Central when a user creates and submits one in Dynamics 365 Sales. |
| Automatically Process Sales Quotes | Process a sales quote in Business Central when a user creates and activates one in Dynamics 365 Sales. |
Standard Sales Entity Mapping for Synchronization
Entities in Dynamics 365 Sales, such as orders, are integrated with equivalent types of tables in Business Central,such as sales orders. To work with Dynamics 365 Sales data you set up links, called couplings, between tables in Business Central and Dynamics 365 Sales.
The following table lists the standard mapping between tables in Business Central and Dynamics 365 Sales that Business Central provides.
| Business Central | Dynamics 365 Sales | Synchronization Direction | Default Filter |
|---|---|---|---|
| Unit of Measure | Unit Group | Business Central -> Dynamics 365 Sales | |
| Item | Product | Business Central -> Dynamics 365 Sales and Dynamics 365 Sales -> Business Central | Sales contact filter: Product Type is Sales Inventory |
| Resource | Product | Business Central -> Dynamics 365 Sales and Dynamics 365 Sales -> Business Central | Sales contact filter: Product Type is Services |
| Customer Price Group | Price List | Business Central -> Dynamics 365 Sales | |
| Sales Price | Product Price List | Business Central -> Dynamics 365 Sales | Business Central contact filter: Sales Code is not blank, Sales Type is Customer Price Group |
| Opportunity | Opportunity | Business Central -> Dataverse and Dynamics 365 Sales -> Business Central | |
| Sales Invoice Header | Invoice | Business Central -> Dynamics 365 Sales | |
| Sales Invoice Line | Invoice Product | Business Central -> Dynamics 365 Sales | |
| Sales Order Header | Sales Order | Business Central -> Dynamics 365 Sales | Business Central Sales Header filter: Document Type is Order, Status is Released |
| Sales Order Notes | Sales Order Notes | Business Central -> Dynamics 365 Sales and Dynamics 365 Sales -> Business Central |
Synchronization Rules
The following table lists the rules that control the synchronization between Dynamics 365 Sales and Business Central. These are in addition to rules defined for Dataverse, which also apply. For more information, see Standard Entity Mapping.
Note
Changes to data in that were made by the integration user account are not synchronized. Therefore, we recommended that you do not change data while using that account. For more information, see Setting Up User Accounts for Integrating with Dynamics 365 Sales.
| Table | Rule |
|---|---|
| Units of Measure | Units of measure are synchronized with unit groups in Dynamics 365 Sales. There can only be one unit of measure defined in the unit group. |
| Items | When synchronizing items with Dynamics 365 Sales products, Business Central automatically creates a price list in Dynamics 365 Sales. To avoid synchronization errors, you should not modify this price list manually. |
| Resources | Resources are synchronized with Dynamics 365 Sales products that have product type Service. |
| Customer Price Groups | Customer price groups are synchronized with Sales price lists. |
| Sales Prices | Sales prices that have sales type Customer Price Group and have a sales code defined are synchronized with Dynamics 365 Sales price list lines |
| Opportunities | Opportunities are synchronized with Dynamics 365 Sales opportunities. The Salesperson Code value defines the owner of the coupled table in Dynamics 365 Sales. |
| Posted Sales Invoices | Posted sales invoices are synchronized with sales invoices. Before an invoice can be synchronized, it is better to synchronize all other tables that can participate in the invoice, from salespersons to price lists. The Salesperson Code value in the invoice header defines the owner of the coupled table in Sales. |
| Sales Orders | When sales order integration is enabled, sales orders in Business Central that are created from submitted sales orders in Dynamics 365 Sales are synchronized with sales orders in INCLUDE SALES when they are released. Before you synchronize orders, we recommend that you first synchronize all tables that the are involved with the order, such as sales persons and price lists. The Salesperson Code field in the order header defines the owner of the coupled table in Dynamics 365 Sales. |
Synchronization Jobs for a Sales Integration
The jobs are run in the following order to avoid coupling dependencies between tables. There are additional jobs available from Dataverse. For more information, see Use Job Queues to Schedule Tasks.
- UNITOFMEASURE - Dynamics 365 Sales synchronization job
- RESOURCE-PRODUCT - Dynamics 365 Sales synchronization job
- ITEM-PRODUCT - Dynamics 365 Sales synchronization job
- CUSTPRCGRP-PRICE - Dynamics 365 Sales synchronization job.
- SALESPRC-PRODPRICE - Dynamics 365 Sales synchronization job.
- POSTEDSALESINV-INV - Dynamics 365 Sales synchronization job.
Default Synchronization Job Queue Entries
The following table describes the default synchronization jobs for Sales.
| Job Queue Entry | Description | Direction | Integration Table Mapping | Default Synchronization Frequency (mins) | Default inactivity sleep time (mins) |
|---|---|---|---|---|---|
| UNITOFMEASURE - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales unit groups with Business Central units of measure. | From Business Central to Dynamics 365 Sales | UNIT OF MEASURE | 30 | 720 (12 hrs) |
| RESOURCE-PRODUCT - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales products with Business Central resources. | From Business Central to Dynamics 365 Sales | RESOURCE-PRODUCT | 30 | 720 (12 hrs) |
| ITEM - PRODUCT - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales products with Business Central items. | From Business Central to Dynamics 365 Sales | ITEM-PRODUCT | 30 | 1440 (24 hrs) |
| CUSTPRCGRP-PRICE - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales sales price lists with Business Central customer price groups. | CUSTOMER PRICE GROUPS-SALES PRICE LISTS | 30 | 1440 (24 hrs) | |
| SALESPRC-PRODUCTPRICE - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales product prices with Business Central sales prices. | PRODUCT PRICE-SALES PRICE | 30 | 1440 (24 hrs) | |
| POSTEDSALESINV-INV - Dynamics 365 Sales synchronization job | Synchronizes Dynamics 365 Sales invoices with Business Central posted sales invoices. | From Business Central to Dynamics 365 Sales | INVOICES-POSTED SALES INVOICES | 30 | 1440 (24 hrs) |
| Customer Statistics - Dynamics 365 Sales synchronization | Updates Dynamics 365 Sales accounts with the latest Business Central customer data. In Dynamics 365 Sales, this information appears in Business Central Account Statistics quick view form of accounts that are coupled to Business Central customers. This data can also be updated manually from each customer record. For more information, see Couple and Synchronize Records Manually. Note: This job queue entry is relevant only if the Business Central integration solution is installed in Dynamics 365 Sales. | Not applicable | Not applicable | 30 | Not applicable |
Connecting Business Central On-Premises Versions Earlier Than Version 16
The Microsoft Power Platform team has announced that it is deprecating the Office365 authentication type. If you are using Business Central on-premises that is earlier than version 16, you must use the OAuth authentication type to connect to Dynamics 365 Sales online. The steps in this section describe how to make the connection.
Prerequisites
Dynamics Business Central Certification
You must have a Microsoft Azure subscription. A trial account will work for application registration.
Dynamics 365 Sales is configured to use one of the following authentication types:
Office365 (legacy)
Important
Effective April 2022, Office365 (legacy) will no longer be supported. For more information, see Important changes (deprecations) coming in Power Apps, Power Automate and customer engagement apps.
OAuth
To connect a version of Business Central earlier than version 16
Import the Microsoft Dynamics 365 Business Central Integration Solution into your Dynamics 365 Sales environment. The integration solution is available in the CrmCustomization folder on your Business Central installation DVD. There are multiple versions of the solution, such as DynamicsNAVIntegrationSolution_v8 or DynamicsNAVIntegrationSolution_v9 or DynamicsNAVIntegrationSolution_v91. The solution you should import depends on the version of Dynamics 365 Sales you're connecting to. Dynamics 365 Sales online requires the DynamicsNAVIntegrationSolution_v91 integration solution.
Create a non-interactive integration user in your Dynamics 365 Sales environment, and assign the user the following security roles. For more information, see Create a non-interactive user account.
- Dynamics 365 Business Central Integration Administrator
- Dynamics 365 Business Central Integration User
Important
This user must not have the System Administrator security role. Also, you cannot use the system administrator account as the integration user.
In Azure portal, create an app registration for Business Central. For the steps, see Register an application in Azure Active Directory. The settings that are specific to connecting to Dynamics 365 Sales are the delegated permissions. The following table lists and describes the permissions.
| API / Permission Name | Type | Description |
|---|---|---|
| Financials.ReadWrite.All | Delegated | Required for Business Central. |
| user_impersonation | Delegated | Required for Dynamics 365 Sales. |
In Business Central, search for Microsoft Dynamics 365 Connection Setup, and then choose the related link.
On the Microsoft Dynamics 365 Connection Setup page, in the Authentication Type field, choose the option for OAuth.
Choose the CRM SDK version that matches solution version you imported in step 1.
In the Server Address field, enter the URL of your Dynamics 365 Sales environment, and then enter the user name and password for the integration user.
In the Connection String field, specify the ID of the app registration. This field has two tokens in which the ID of your application should be specified.
Token Description AppId Set to the application ID. RedirectUri Set to the application ID, but add the app:// prefix. ExampleThe following example shows a connection string.
Enable the connection.
Note
If you want to configure a connection to a Dynamics 365 Sales instance with a specific authentication type, fill in the fields on the Authentication Type Details FastTab. For more information, see Authentication with Microsoft Dataverse web services. This step is not required when connecting an online version of Business Central.
Business Central Dynamics 365 Integration
See Also
Setting Up User Accounts for Integrating with Dynamics 365 Sales
Set Up a Connection to Dynamics 365 Sales
Synchronizing Business Central and Dynamics 365 Sales
Preparing Dynamics 365 Sales for Integration on-premises
Note
Can you tell us about your documentation language preferences? Take a short survey.
The survey will take about seven minutes. No personal data is collected (privacy statement).