LightspeedPos Microsoft Dynamics 365 Business Central Integration

lightspeedpos LightspeedPos Microsoft Dynamics 365 Business Central Integration microsoft dynamics 365 business central

Work faster
and more efficient

Link your applications yourself
in the APIcenter dashboard

Insight from you
data in dashboard

Always orders, customers,
products Up to date

Automatically sync
your data between

LightspeedPos
Microsoft Dynamics 365 Business Central
Set up your integration

Details
LightspeedPos + Microsoft Dynamics 365 Business Central Integration

General
Orders
Products
Stock
Customers

For setting up a successful integration between LightspeedPos and Microsoft Dynamics 365 Business Central you need to install a package in your 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 LightspeedPos to Microsoft Dynamics 365 Business Central or from Microsoft Dynamics 365 Business Central to LightspeedPos.

Process

We retrieve the order based upon last modified date. You can determine in APIcenter if you want to have additional filtering on this. For example if you only want to retrieve orders with the status processing. 

Once we retrieved the order data we process it through APIcenter, add missing data(for example mandatory data for business central like Business Posting Group) and start the send process towards LightspeedPos. First we check if the order already exists, if it exists we throw an error and skip the order. If it does not exists we check if the customer exists and depending on the outcome create or update the customer. We check if all products exist and then we commit the order.

We differentiate in creating the customer based upon the source data we receive. if we receive from the source a company name we will create a company debtor with the underlying contact. If we receive no company name we will receive a person debtor.

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

Ordertypes

You can determine what type of order you want to send towards LightspeedPos.

Our Business Central integrations supports Orders or Invoices.

Settings

Within APIcenter you can set specific settings that are mandatory for Microsoft 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 Microsoft Dynamics 365 Business Central to the LightspeedPos.

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

Datamapper

Per default we supply a mapping that makes sure you can send an order towards LightspeedPos. You can also make adjustments to this yourself. If you make a mistake you can always go back to default.

Default values 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

Products are synced from LightspeedPos to Microsoft Dynamics 365 Business Central. Within this sync we can send different types of product. We gather our data from LightspeedPos based upon the last modified date, then we run it through our APIcenter to have the correct settings, values and formats before we send it to the Microsoft Dynamics 365 Business Central. Once we start the send side we first check if the products exists, if it does not exist we create it otherwise we update the article. The linkin pin is the article number, sku.

You can differentiate within APIcenter the behaviour between creating and updating products. For example when we create a product we send in the long description from the LightspeedPos, but if you enriched the data after this in Microsoft Dynamics 365 Business Central you don't want to have it overwritten with an update for this you can use

the settings that are related to the product update.

Product Types

Basically we support simple, virtual, variant/configurable products.

Publish Products

You can determine via a setting in APIcenter if newly created products should be published immediately or if they are created in a draft status so you can enrich them first in the Microsoft Dynamics 365 Business Central before publishing.

Attributes/Features

Besides the generic and custom added fields from LightspeedPos we also support Item Attributes from LightspeedPos. These needs to be manually mapped in APIcenter via the Attributes or the Features mapping tables. 

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 are supported 

Images

Images are supported from LightspeedPos to Microsoft Dynamics 365 Business Central. Please be aware that LightspeedPos only supports 1 image. When you add multiple images in your store you are advised to turn of the image functionality on update.

Datamapper

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

SKU

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

Process

Stock is synced from Business Central to Microsoft Dynamics 365 Business Central. For this we use the last modified date on the stock. This flow only updates products in the Microsoft Dynamics 365 Business Central. If a product does not exists it throws a warning where it mentions that the article does not exist.

Please be aware that an actual stock mutation is needed to trigger the flow. So a sales order, purchase order is needed. A correction does not create a trigger for this.

Settings

We support different types of stock calculations by default we send the available stock - sales reservations. You can adjust this if needed.

You can also set the value towards target system if you want to have the stock managed or not. In this way we overwrite the default.

Process

The customer flow is different then the customers that are created via an order. For this the actual trigger is the creation or update of a customer that triggers this flow. We always check first if the customer exists before creating or updating the customer. Addresses are checked and updated if needed.

We differentiate in creating the customer based upon the source data we receive. if we receive from the source a company name we will create a company debtor with the underlying contact. If we receive no company name we will receive a person debtor.

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

Settings

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

Data mapping

Per default the flow is mapped so it can work. if you want to make adjustments or additional fields you can do this in the datamapper.

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

What can you integrate between
LightspeedPos and Microsoft Dynamics 365 Business Central?

14 Days Trial

We have grouped the data that can be integrated, and divided among categories of what we call flows. You can add one flow in your link or combine several.

Sales Orders

from LightspeedPos are created directly in Microsoft Dynamics 365 Business Central.

More info...
LightspeedPos
Microsoft Dynamics 365 Business Central
2498 / MO
Stocks

from LightspeedPos are created directly in Microsoft Dynamics 365 Business Central.

More info...
LightspeedPos
Microsoft Dynamics 365 Business Central
1998 / MO
Customers

from LightspeedPos are created directly in Microsoft Dynamics 365 Business Central.

More info...
LightspeedPos
Microsoft Dynamics 365 Business Central
1998 / MO
Products

from LightspeedPos are created directly in Microsoft Dynamics 365 Business Central.

More info...
LightspeedPos
Microsoft Dynamics 365 Business Central
2998 / MO

Set up the integration
yourself ? Set up in 5 steps!

Create a free account and start the wizard. Select the applications you want to integrate and select which data you want to sync. Then some questions are asked about the basic configuration. In the advanced settings you can adjust a lot of settings. You can turn on the integration and try it for free for 14 days. Can’t quite figure it out? Then we will help you in a short, free online meeting.

Do it yourself
0,-
  • Acces APIcenter
  • Set up manuals
  • Set up video’s
  • Authorize of the applications
  • Select which data you want to sync
  • Short meeting to get started
  • 14 days trial
More information
Set up your integration

No time to set up
your integration yourself?

The integration is set up by an APIcenter specialist. After consultation with a consultant, we will create the account for you and set the API data for both systems. The desired flows are then set up and fully configured. Advanced settings are also set and consideration is given to the optimal use of the integration. After a thorough test phase, the integration will go live.

Worry-free package
1995
  • Consultancy
  • Basic set up
  • Set up Flows
  • Test integration
  • Extensive online meetings
  • Live guidance
  • Max 16 uur
More information
Order

How APIcenter
works

APIcenter is a platform where you can set up an integration yourself. But how does this work? By registering you will enter the dashboard. Here you can “connect” your different systems together. You add your systems/applications first. Then you generally indicate what you want to link, for example products or orders. In the next step you will be asked what your specific wishes are. When that is filled in, you are done and you can test whether everything works as you wish! It can be that simple.

Always up to date

Always up to date

While it would take you hours to copy data between LightspeedPos and Microsoft Dynamics 365 Business Central, APIcenter can do it in seconds. APIcenter is more efficient not only in cost and time, but most importantly: accuracy & security. A constant flow of data from one end to another has never been easier.

Access to API Center

Configurable

With APIcenter you have complete control over all your data flows from LightspeedPos to Microsoft Dynamics 365 Business Central and the other way around. You can map the data exactly how you want it, and even invoke extra functions to transform the data when needed.

Exact Partner

Full transparancy

You will get access to your own personal dashboard in which you can see extensive activity logs for your integrations. See exactly which data was from LightspeedPos, and which data was pushed to Microsoft Dynamics 365 Business Central and the other way around. Add flows per your wish.

More about the LightspeedPos and Microsoft Dynamics 365 Business Central integration.

image

The LightspeedPos and Microsoft Dynamics 365 Business Central integration is very easy to setup with the APIcenter wizard. Simply create a free account and start the wizard. You will be asked which integrations you'd like to add. Simply select LightspeedPos and Microsoft Dynamics 365 Business Central .

  • Add the API credentials for both applications. We will walk you trough it.
  • Add the flows you'd like to add, like orders, products and stock.
  • Then add some settings per your needs and answer some questions to setup the integration properly.
  • Finally pay 1 euro for the trial period. When you are happy with the integration you can decide to go for a paid subscription.
Monitoring

Monitoring

APIcenter constantly monitors your integrations, so if any integration fails for whatever reason, we will instantly notify you exactly with what the problem is. This way you can have your LightspeedPos integration with Microsoft Dynamics 365 Business Central fixed in minutes.

Scalability

Scalability

Nobody wants to be "punished" for their success by causing unwanted delays when the data flow grows bigger. Your data is business critical, you cannot afford any delays. By utilizing a redundant serverless architecture, APIcenter is able to handle any amount of data for your integration, without ever slowing down.

GDPR Proof

GDPR Proof

Our platform is GDPR proof. Transferring data is handled on the fly over an end-to-end encrypted connection without ever being saved on any of our servers. We only store logs to show to you. They are deleted on a frequently basis.