Business Central

Warning

Work in progress! We are in the process of updating the information on this page. Subject to change.

Microsoft Dynamics 365 Business Central is an enterprise resource planning system from Microsoft. The product is part of the Microsoft Dynamics family.

Resco Cloud can connect to Business Central using one of the following methods:

• Via Power Automate + Resco Cloud connector: full-featured integration using a third-party Microsoft service
• Using Integrations (Preview): connect your Resco Cloud organization to Business Central directly from Woodford.

This article explains the second method in more detail.

Register Resco application in Business Central

Before you can start migrating data between Resco Cloud and Business Central, you must register the Resco application (clientId) in Business Central and grant Resco consent with accessing Business Central data.

1. Log in to your Business Central organization and go to the Azure Active Directory Applications.
   
2. Click New and fill out the registration form.
   
3. As Client ID, use 4abedb2f-19bc-402f-b0b5-b8d17e85aa04.
4. Add User Permission Sets (SUPER).
5. Grant the necesary consent.
   

Install Resco extension on Business Central

The extension is required for synchronizing between Resco Cloud and Business Central.

1. Download the extension from Resco web.
2. Log in to Business Central and search for "extensions".
   
3. On the Manage tab, click Upload Extension and upload the zip file.
   

Create integration

1. Start Woodford and select Integrations from the Administrator menu.
2. Click New and enter the following details:
   
   • Name - enter a name of your integration
   • Connector - select OData
   • URL - enter the URL of Business Central OData endpoint (e.g., https://api.businesscentral.dynamics.com/v2.0/b8cc0002-2542-46ed-8584-d4868701fbc4/Production/ODataV4/)
   • Username - BC account's email address
   • Password - BC account's password
   • CustomQueryParamaters - custom query, which should be added to the every request (e.g., &company=CRONUS%20USA%2C%20Inc.). It is important to include the correct &company parameter.
3. Click Save.

Configure integration

1. Double-click this integration to map external entities/fields to local entities/fields. For Business Central, some settings are configured by default:
   • Default mapping will be added. In the preview, only three entities are officially supported: account, contact, and work order.
   • Based on default mapping, External Primary Key fields will be added to the schema.
2. Verify that the three entities supported out-of-the-box are enabled.
3. Save all changes.

You can start migrating or synchronizing data:

• Set up sync filter
• Import/export data
• Synchronize data

See also

• Discover the URL for your Dynamics organization using the Web API