Microsoft Dynamics 365 Business Central SAP S/4HANA Integration

For detailed documentation, click here.

Process

Products are synced from Microsoft Dynamics 365 Business Central to SAP S/4HANA. Within this sync different types of products are supported. APIcenter gathers the data from Microsoft Dynamics 365 Business Central, then it is run through the APIcenter to have the correct settings, values and formats before it is send to SAP S/4HANA. Products are created or updated based on the SKU.

You can differentiate within APIcenter the behaviour between creating and updating products. For example when APIcenter creates a product and sends in the long description from the Microsoft Dynamics 365 Business Central, but if you enrich the data after this in SAP S/4HANA, you don't want to have it overwritten with an update. For this you can set a checkbox to update the product info.

Product types

Supported product types: Simple, virtual, variant/configurable products.

Attributes/Features

Besides the generic and custom added fields from Microsoft Dynamics 365 Business Central also Item Attributes from Microsoft Dynamics 365 Business Central are supported. These needs to be manually mapped in APIcenter.

Attributes are used for creating configurable products, like size/color/options. Features are used as extra information fields, think about country of origin, type, delivery time etc.

Categories

Categories can be created or updated from Microsoft Dynamics 365 Business Central to SAP S/4HANA.

Images

Images are supported from Microsoft Dynamics 365 Business Central to SAP S/4HANA. Please be aware that Microsoft Dynamics 365 Business Central only supports 1 image.

Datamapper

You can map extra fields that are available in the API. For a default working integrations we already mapped the basic fields that are needed; for example

Fields

• Name/Title
• SKU
• Long Description
• Short Description
• Price excl. tax or incl. tax
• Quantity
• EAN/GTIN
• Currency

Process

The customer flow is different then the customers that are created via the order flow. In this flow customers are always updated on a change. And in the order flow the customers are only updated on an order.

We check if the customer exists per default by email address.

Settings

You can set the mandatory fields for Microsoft Dynamics 365 Business Central in settings tab, for example the business posting group.

Data mapping

Per default the flow is already mapped. You can also make adjustments to this yourself.

Default fields that are mapped are for example:

• Customer Name
• Billing address
• street
• Number
• Postalcode
• City
• Country
• Shipping address
• street
• Number
• Postalcode
• City
• Country

For setting up a successful integration between Microsoft Dynamics 365 Business Central and SAP S/4HANA you need to install an app in your Microsoft Dynamics 365 Business Central environment. You can find the app here .

This app extends your articles table with some setting fields and a long description for the article. It also creates additional API endpoints where we can retrieve additional data from Microsoft Business Central.

We support Business Central cloud and local from version 14 and higher.

Orders can be synced from Microsoft Dynamics 365 Business Central to SAP S/4HANA or from SAP S/4HANA to Microsoft Dynamics 365 Business Central.

Process

You can set the status on which orders are send from SAP S/4HANA, like only the paid orders.

Once APIcenter retrieves the order data it is processed, add missing data(for example mandatory data for business central like Business Posting Group) and start the send process towards Microsoft Dynamics 365 Business Central. First APIcenter checks if the order already exists, if it exists we skip the order. If it does not exists APIcenter checks if the customer exists and depending on the outcome create or update the customer. APIcenter checks if all products exist and then the order is committed.

APIcenter differentiates in creating the customer based upon the source data received. If APIcenter receives from the source a company name then a company debtor is created with the underlying contact. If there is no company then a person debtor is created.

The check on customer exists is done per default by email address.

Ordertypes

You can determine what type of order you want to send towards Microsoft Dynamics 365 Business Central.

Our Microsoft Dynamics 365 Business Central integrations support Orders or Invoices.

Settings

Within APIcenter you can set specific settings that are mandatory for Microsoft Dynamics 365 Business Central, like Customer Posting Group, General Business Posting Group etc. For a complete overview please check the documentation.

Standard we offer functionality to make specific mappings like payment terms and methods from the SAP S/4HANA to the Microsoft Dynamics 365 Business Central.

Do you want to make use of a default debtor? This is also per default available in APIcenter.

Datamapper

Per default APIcenter supplies a mapping that makes sure you can send an order towards Microsoft Dynamics 365 Business Central. You can also make adjustments to this yourself.

Default fields that are mapped are for example:

• Customer Name
• Billing address street
• Number
• Postalcode
• City
• Country
• Shipping address street
• Number
• Postalcode
• City
• Country
• SKU
• Quantity
• Price