How to Connect Business Central to CRMJetty Portal
The portal reads and writes Microsoft Dynamics 365 Business Central data through the Business Central APIs, using an app you register in Microsoft Entra ID (formerly Azure Active Directory). You set this up once after the portal is deployed, and again whenever you change the Business Central environment. The same connection is used for both Business Central Customer and Vendor portals.
Before you start
- You need admin access in Business Central and permission to register apps in the Azure portal.
- You need super admin access to the portal admin. Only the super admin receives the OTP that unlocks the authentication screen.
- You need a CRMJetty product license key. To get one, email
support@crmjetty.comwith your domain name. - Set up SMTP first, because the authentication screen sends the OTP by email. See How to Configure SMTP Email in CRMJetty Portal.
- Check the full list of requirements in CRM Connection Requirements for CRMJetty Portal.
Register an app in Microsoft Entra ID
- Sign in to the Azure portal at
https://portal.azure.com/. - Search for and open Microsoft Entra ID (formerly Azure Active Directory).
- Select App registrations, then New registration.
- Enter a name for the app and select Register.
- Copy the Application (client) ID and the Tenant ID. You need both later.
Add API permissions
- In the app, select API Permission, then Add Permission.
- Select Microsoft Graph and add
User.Read. - Select Add Permission again, select Dynamics 365 Business Central and add the permissions in the table below.
| API | Permissions |
|---|---|
| Microsoft Graph | User.Read |
| Dynamics 365 Business Central | AdminCenter.ReadWrite.All, API.ReadWrite.All, app_access, Automation.ReadWrite.All, Financials.ReadWrite.All, user_impersonation |
Grant admin consent
- On API permissions, select Grant admin consent for your organization.
- Confirm when prompted.
Allow public client flows
- In the left menu, select Authentication.
- Under advanced settings, set Allow public client flows to Yes.
- Select Save.
Create a client secret
- In the left menu, select Certificates & secrets.
- Select New client secret.
- Enter a description and select an expiry time.
- Select Add.
- Copy the secret Value right away.
Important: You can copy the client secret value only once. If you lose it, create a new secret.
Add the app in Business Central
- Sign in to Business Central.
- Search for Microsoft Entra Applications and open the page.
- Select New.
- Enter the Client ID of your Entra ID app, a Description, and the app name.
- Set State to Enabled.
- Add the user permissions the portal needs.
Connect the portal to Business Central
- Sign in to the portal admin.
- Go to Settings → Portal Settings → Business Central Authentication.
- Enter the OTP sent to the super admin’s registered email address.
- In Environment, select Live for your production Business Central or Sandbox for a test environment.
- In Client ID, enter the Application (client) ID of your Entra ID app.
- In Client Secret, enter the client secret value.
- In Tenant ID, enter your tenant ID.
- Select Save.
| Field | What to enter |
|---|---|
| Environment | Live: the production environment with real data and transactions. Sandbox: a test environment that does not affect live data. |
| Client ID | The Application (client) ID of the Entra ID app |
| Client Secret | The client secret value you copied |
| Tenant ID | The tenant ID of your Microsoft Entra directory |
Test the connection
- Select Test Connection.
- Check the connection status on the right side of the page.
- Connected: a success message appears. The portal can now use your Business Central data.
- Not connected: check that the Client ID, Client Secret and Tenant ID are correct. If the problem continues, contact the person who manages your Business Central.
Important: If Business Central is already connected and you change the connection, a warning may ask you to choose Preserve Data or Reset Data. Reset Data removes all pages, forms, lists, templates and site configuration. See How to Preserve or Reset Portal Data After Reconnecting.
Next, choose which Business Central tables the portal syncs. See How to Configure Business Central Table Sync.
Troubleshooting
You do not receive the OTP: only the super admin receives the OTP, at their registered email address. Sign in as the super admin and check that SMTP is configured.
The status shows Not connected: re-enter the Client ID, Client Secret and Tenant ID and test again. Check that the app is enabled on the Microsoft Entra Applications page in Business Central. See also How to Fix CRM Connection Errors in CRMJetty Portal.
You lost the client secret value: create a new client secret in Entra ID and enter the new value in the portal.
Related articles
- Getting Started with Business Central Customer Portal
- How to Configure Business Central Table Sync
- How to Switch the Portal Between Sandbox and Live CRM
- How to Fix CRM Connection Errors in CRMJetty Portal