Dynamics 365 Business Central is a business management application designed for medium-sized businesses. From one application, businesses can monitor and manage their accounting processes, financial performance, supply chain, sales and marketing processes, and project delivery.
Before you can access data from customers using Dynamics 365 Business Central for their accounting, you need to set up a Dynamics 365 Business Central integration in the Codat Portal. You'll need to:
- Register and configure your Dynamics 365 Business Central application, and retrieve your secure keys.
- Add your secure keys to the Codat Portal.
- Enable your Dynamics 365 Business Central integration in the Codat Portal.
We also recommend that you test your integration using a trial Dynamics 365 Business Central account.
Register your Dynamics 365 application on the Azure portal.
- Go to the Azure portal and sign in.
Dynamics 365 Business Central and Azure account details
If you already have a Dynamics 365 Business Central account, use these account details. If you don't, create an account before continuing.
To gain access to any Azure configuration that your company has already set up, for example, user authentication, enter your company email address when you sign up. If your organisation is using Azure Active Directory (Azure AD) to control access to Dynamics 365 Business Central, ask your Azure AD administrator to add your account to the correct group.
If you're unable to sign up for a new account, contact your Dynamics 365 Business Central administrator. They may have disabled this feature.
- When you've signed in successfully, from the left or in-page menu, select Azure Active Directory. If you can't see this entry on the landing page, under Azure services, select More services and then select Azure Active Directory.
Details of the tenant to which your account is connected are displayed.
- You might have been granted access to more than one tenant, so check the details are correct. If they're incorrect, select Switch tenant and choose the right one.
- From the left, or in page menu, select App registrations, and then select + New registration.
- Add the following details:
- In the Name box, enter a short name for your application. Your customers see this when they authorise your connection to their accounting system.
- Under Supported account types, select Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g. Skype, Xbox), which allows Codat to access data in Dynamics 365 Business Central.
- Under Redirect URI, select Web and then enter
- Select Register.
Azure registers your application details and generates your client ID. You'll need this later, so either copy the details or keep this page open in a separate browser tab. The client ID will not be displayed after you leave this page.
Next, generate and retrieve your client secret.
- Still in the Azure portal, in the left menu, select Certificates & secrets.
- Under Client secrets, select + New client secret.
- In the Add a client secret dialog box, update the following:
- In the Description box, enter a short description for your client secret to make it easier to find.
- Under Expires, select the most appropriate option that complies with your company's security policy.
- Select Add.
Your client secret is generated and displayed at the bottom of the page. The Secret Value won't be displayed again in full so copy the value down.
Now, update the access permissions for your application, which control the data that your app can access in Dynamics 365 Business Central.
- In the left menu, select API permissions.
- Under Configured permissions, select + Add a permission.
- In the Request API permissions pane, scroll down and select Dynamics 365 Business Central.
- Select Delegated permissions along with the first two listed permissions:
- Select Add permissions.
- Now, above the listed permissions, select Grant admin consent for Default Directory, and select Yes to confirm your change. This option may not be available for all subscription types.
- Your Dynamics 365 Business Central application set up is complete.
To add your secure keys.
- Go to the correct Codat environment and log in.
- Go to Integrations > Accounting.
- Scroll down the list until you find Dynamics 365 Business Central, and select the Manage button next to it.
- Copy and paste the Client ID and Client Secret values from registration.
- Select Save to complete your integration set up.
- In the Codat Portal, go to Integrations > Accounting.
- Scroll down the page until you find Dynamics 365 Business Central and select the toggle to set it to Enabled.
Your Dynamics 365 Business Central integration is now set up.
We recommend that you test your integration before sending Link URLs to customers.
Dynamics 365 Business Central extension
We recommend that you mention this to your customers before you begin to link their accounts.
During the linking process, Codat installs a Dynamics 365 Business Central extension:
- Description/Publisher: Codat
- Name: App Link.
If the latest version of this extension is uninstalled or unpublished, Codat is unable to retrieve all the required data from the accounting platform.
Under certain circumstances, the extension may take a few minutes to install, and while it completes, fetch errors may temporarily occur.
- Sign in to the Dynamics 365 Business Central account you added earlier or create a new one.
- Create some data within the application, for example, some invoices.
- In the Codat portal where you've enabled your integration, create a test company.
- Search for your test company, and next to the company name, select View Link URL.
- Use the Link URL to connect your Microsoft Dynamics 365 account.
- When Link opens, select Microsoft Dynamics 365 Business Central, and then select Continue to Dynamics 365 Business Central.
- Log in to your Dynamics 365 account.
- Authorise access to your account details and select your test company.
Depending on the end user's AD settings for Dynamics 365 they may need the connection to your app to be approved by an admin of their AD. If this is the case the user will be guided to request access and the admins will be notified (if the user making the connection is an admin they will not need to request access). Once approved the user can run through the link flow process again to complete the connection to your app.
Multiple environment selection (Sandbox and Production)
During linking, when you select a company that is available in a sandbox or production environment, the environment name is also displayed. This feature allows:
- You to organise your Dynamics 365 Business Central data into multiple production environments.
- You and your customers to make sure that the correct environment is used when linking companies.
According to your access level, a company called Cronus may also be available for selection. This is a Microsoft test company populated with sample data.
- Make sure that any data for your test company is displayed in Codat Portal.
To learn more about how Dynamics 365 Business Central handles certain data types, and how this affects the data available in Codat, see Data handling in Dynamics 365 Business Central.
Updated 27 days ago