Microsoft Business Central On-Premise Asperion Integration

For the Microsoft Business Central On-Premise Application to correctly function with APIcenter functionality the following prerequisites need to be met.

• An account on app.apicenter.io. Registering for an account can be donehere.
• An Microsoft Business Central On-Premise inBalance or inTrade package.

Orders can be synced from Asperion to Microsoft Business Central On-Premise.

Process

You can set the status on which orders are send from Asperion, like only the paid orders.

Once APIcenter retrieves the order data it is processed, add missing data and start the send process towards Microsoft Business Central On-Premise. 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 Business Central On-Premise.

Our Microsoft Business Central On-Premise integrations support Orders or Invoices.

Settings

Within APIcenter you can set specific settings that are mandatory for Microsoft Business Central On-Premise. For a complete overview please check the documentation.

Standard we offer functionality to make specific mappings like payment terms and methods from the Asperion to the Microsoft Business Central On-Premise.

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 Business Central On-Premise. 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

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 Business Central On-Premise in settings tab.

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 detailed documentation, click here.

Process

Stock is synced from Microsoft Business Central On-Premise to Asperion.

Settings

Different types of stock calculations are supported. By default the available stock - sales reservations is send.

You can set the value towards target system if you want to have the stock managed or not.