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:
Step 1:
Installation of the Connector Service at a server on your local area network
Step 2:
Opening of the firewall for the Dynamicweb solution to communicate with the Connector Service.
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 |
|
X |
X |
|
|
X |
||
|
X |
X |
|
|
X |
X |
|
|
X |
X |
|
|
X |
X |
|
|
X |
X |
|
|
X |
X |
|
|
X |
||
|
Import prices |
X |
X |
|
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 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.
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 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.
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 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.
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 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.
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 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.
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 |
|
|
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 |
|
|
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) |
|
|
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 |
|
|
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.
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 |
|
|
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 |
|
|
The “Email” field of the Alternative Address |
|
Mobile Phone No. |
The “Mobile Phone No.” field of the Alternative Address |
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.
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 (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.
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 |
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.
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 (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.
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.