Dynamicweb to Microsoft Dynamics D365 Business Central Integration

Dynamicweb offers an Integration Framework that contains standard plug-in units for Microsoft Dynamics ERP. 

How does it work?


Dynamicweb connects directly to your D365 BC through a setup involving a so-called Connector Service, that must be placed inside your firewall on the network of your ERP System. 

This is a piece of software that does all the communication between your ERP and Dynamicweb. In turn, this software communicates with a special Dynamicweb Plugin / Code Unit inside your ERP system that specifies exactly what data is exchanged. 

Initially, in any Dynamicweb implementation that integrates with your ERP, three things must happen before the integration will run:

Connector Service

Step 1: 

Installation of the Connector Service at a server on your local area network

Firewall

Step 2:

Opening of the firewall for the Dynamicweb solution to communicate with the Connector Service.

ERP Code Unit

Step 3:

Installation of the ERP Code Unit / Plugin inside of your ERP System

This will, in most cases, involve your ERP Partner and responsible part for your IT Infrastructure.

The figure shows the schematics for a configured integration setup:

The integration in technical details

Features supplied with our standard integration for ERP System

 

Dynamics AX/D365 FO

Dynamics NAV/D365 BC

Import currencies

X

X

Import countries

 

X

Import languages

X

X

Import units

X

X

Import manufacturers

X

X

Import customers

X

X

Import product groups

X

X

Import products

X

X

Import related products

X

 

Import prices

X

X

Import product stock

X

X

Import orders

X

 

Export orders

X

 

Live prices & stock

X

X

Live order calculation

X

X

Live Customer Center functionality (Orders, Invoices, Credit notes)

 

X

Data transferred from Business Central to Dynamicweb

Currencies

Currencies that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. This data defines, in which currencies your prices can be stored.

Click here to read more → 

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Currency

Description

The “Description” field of the Currency

ISO Numeric Code

The “ISO Numeric Code” field of the Currency

Countries

Countries that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. This data defines the countries of the customers/contacts, and/or the countries of delivery.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Country

Name

The “Name” field of the Country

Languages

Languages that will be available in the Dynamicweb eCommerce solution will be imported from BC as a batch import based on a predetermined schedule. The languages define which language layers should be available.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Language

Name

The “Name” field of the language

Unit of Measures

Unit Of Measures that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. The Unit of Measures defines, which Unit of Measures will be available for the products.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Unit of Measure

Name
The “Name” field of the Unit of Measure
 

Description

The “Description” field of the Unit of Measure

Vendors

Vendors that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. The vendors (Manufacturers) define, which manufacturers is available in your product data. 

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

No.

The “Number” field of the Vendor

Name

The “Name” field of the Vendor

Address

The “Address” field of the Vendor

Post Code

The “Post Code” field of the Vendor

City

The “City” field of the Vendor

Country/Region Code

The “Country/Region code” field of the Vendor

Phone No.

The “Phone No.” field of the Vendor

Fax No.

The “Fax No.” field of the Vendor

Email

The “Email” field of the Vendor

Home Page

The “Home Page” field of the Vendor

Customers or Contacts + Salespersons

Customers or contacts that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule.

The Customers, contacts and salespersons are all defining users in Dynamicweb.

Customers and contacts can log in, see order history, make orders etc. Salespersons will be able to impersonate their customers, and make orders on behalf of the customers.

Click here to read more →
Click here to read about impersonation →

Customers or Contacts

The data imported from BC is records containing:

BC Data field

Description

Email

The “Email” field of the Contact. (“Email” field of Customer, if not using contact-import)

No.

The “No.” field of the Contact. (“No.” field of Customer, if not using contact-import)

Contact business number

The “No.” field for the Contact Business Relation (“No.” field of Customer, if not using contact-import)

Name

The “Name” field of the Contact (“Name” field of Customer, if not using contact-import)

Email

The “Email” field of the Contact (“Email” field of Customer, if not using contact-import)

Phone no.

The “Phone No.” field of the Customer

Fax no.

The “Fax No.” field of the Customer

Address

The “Address” field of the Customer

Address 2

The “Address 2” field of the Customer

Post Code

The “Post Code” field of the Customer

City

The “City” field of the Customer

Country/Region Code

The “Country/Region Code” field the Customer

Company Name

The “Company Name” field of the Contact (“Name” field of Customer, if not using contact-import)

Currency Code

The “Currency Code” field of the Customer (If empty, “LCY Code” from General Ledger Setup)

Home Page

The “Home Page” field of the Company

Sales Person Code
The “Salesperson Code” field of the Contact (“Salesperson Code” of company, if not using contact-import)

Salespersons/Purchaser

BC Data field

Description

Email

The “Email” field of the Salesperson/Purchaser

Code

The “Code” field of the Salesperson/Purchaser

Name

The “Name” field of the Salesperson/Purchaser

Phone no.

The “Phone no.” field of the Salesperson/Purchaser

Addresses

Ship-to addresses (if importing customers) or alternative addresses (if importing contacts) will be imported from BC together with Customers/Contacts.

Click here to read more →

Ship-to addresses

BC Data field

Description

Code

The “Code” field of the Ship-to address

Phone No.

The “Phone No.” field of the Ship-to address

Name

The “Name” field of the Ship-to address

Address

The “Address” field of the Ship-to address

Address 2

The “Address 2” field of the Ship-to address

Post Code

The “Post Code” field of the Ship-to address

City

The “City” field of the Ship-to address

Country/Region Code

The “Country/Region code” field of the Ship-to address

Fax No.

The “Fax No.” field of the Ship-to address

E-Mail

The “Email” field of the Ship-to address

Contact Alternative Addresses

BC Data field

Description

Code

The “Code” field of the Alternative Address

Phone No.

The “Phone No.” field of the Alternative Address

Address

The “Address” field of the Alternative Address

Address 2

The “Address 2” field of the Alternative Address

Post Code

The “Post Code” field of the Alternative Address

City

The “City” field of the Alternative Address

Country/Region Code

The “Country/Region code” field of the Alternative Address

Fax No.

The “Fax No.” field of the Alternative Address

E-Mail

The “Email” field of the Alternative Address

Mobile Phone No.

The “Mobile Phone No.” field of the Alternative Address

Item Categories

Item Categories that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. The Item Categories (Product groups) will define the Ecommerce Product Groups. These groups can be used as navigation on the webshop.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Item Category

Description

The “Description” field of the Item Category

Parent Category

The “Parent Category” field of the Item Category

Presentation Order
The sorting order of the Item Categories

Items

Items (Products) that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule. The products can be imported to Dynamicweb Ecommerce or Dynamicweb PIM according to your setup.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

No.

The “No.” field of the item

Item Variant Code (If variant)

The “Code” field of the Item Variant

Description

The “Description” field of the item

Description2

The “Description 2” field of the item

Unit Price

The “Unit Price” field of the item

Inventory

The “Inventory” field of the item

Net Weight

The “Net Weight” field of the item

Unit Volume

The “Unit Volume” field of the item

Vendor No.

The “Vendor No.” field of the item

Blocked

The “Blocked” indicator for the item

Base Unit of Measure

The “Base Unit of Measure” field of the item

Item Identifier Code

The “Code” field of the Item Identifier

Item Attributes

The “Item Attribues” list of the item

Import Locations

Locations (Stock locations) that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Code

The “Code” field of the Location

Name

The “Name” field of the Location

Item Attributes

Item Attributes (Product Category fields) that will be available in the Dynamicweb ecommerce solution will be imported from BC as a batch import based on a predetermined schedule.

Click here to read more →

The data imported from BC is records containing:

BC Data field

Description

Name

The “Name” field of the Item Attribute

Item Attribute Values

The values field of the Item Attribute

Additional data and filtering

During a Dynamicweb implementation involving integration to your ERP, we may find that you have additional integration areas from where data should be retrieved, that the standard content of data fields is insufficient for your solution, or that Dynamicweb should filter data to only receive a subset of the data available in BC.

Our integration framework allows for extending the basic functionality, by adding additional data fields etc. This will require both some additional development in Dynamicweb and in the Code Units in your ERP system that exposes the data for Dynamicweb.

If you have questions, please contact us