ERP
Microsoft Dynamics 365 Business Central
Business Central is connected online as well as in your own data centre, through Microsoft's standard API. Items come out as Commerce Bundle products, with description, GTIN, unit, price and inventory — and go into every shop with the same mapping.
In the other direction, orders are created as sales orders; posted shipments come back with the lines delivered.
If Business Central rejects a line, no half order is left behind.
- Microsoft Dynamics 365 Business CentralERP
- ConFlowIOintegration platformRun active
- Shopware 6
- Shopify
- WooCommerce
- 7ready-made building blocks
- 21data models in the Commerce Bundle, one mapping for every target
Building blocks
Seven building blocks for Business Central
- Read itemsRead
Reads items as Commerce Bundle products, in full or only those changed since the last run, with description, GTIN, unit, price and inventory.
- Read inventoryRead
For the stock sync, reads only the item number and inventory of stock items.
- Hand over ordersWrite
Creates orders as sales orders — with delivery address, with the prices paid net or gross and with shipping costs if needed. Known orders are skipped; if Business Central rejects a line, no half order is left behind.
- Read sales ordersRead
Reads sales orders back with their state, posted shipments with the lines delivered — the basis for the shipment report to the shop.
- Cancel sales ordersWrite
Deletes the sales order when the order was cancelled in the shop — as long as nothing of it has been shipped or invoiced.
- Read master data and documentsRead
Reads, with Business Central's field names, customers, vendors, contacts, invoices, credit memos, shipments, item data and value lists.
- Free request
For everything there is no ready-made building block for: a request to the API, with the stored credentials.
In practice
Two workflows with Business Central
Items and inventory into the shop
Business Central holds items and inventory; the shop should show the same state.
- Triggerschedule
- Readitems from Business Central, only those changed since the last run
- Inventoryitem number and inventory of stock items
- WriteShopware 6, Shopify or WooCommerce
One mapping onto the Commerce Bundle, and the last building block decides which shop is written.
Orders as sales orders
Orders from the shop and marketplaces should end up as sales orders in Business Central without manual work.
- Triggerthe shop's webhook or a schedule for the marketplaces
- Customera fixed collective customer, an existing customer with the order's e-mail address or an explicitly assigned customer number
- Hand overas a sales order, prices net or gross, with shipping costs
- Read backposted shipments with the lines delivered
No order is re-entered by hand, none is created twice, and no half order is left behind when Business Central rejects a line.
Good to know
What to know about Business Central
- PrerequisitesWhat has to be set up on your side.
- An application registered in Microsoft Entra and enabled in Business Central
- In your own data centre, alternatively a user with a web service access key
- A system reachable over HTTPS
- Not coveredWhat ConFlowIO does not write, and what Microsoft's standard API does not carry.
- Items, prices and customers are read but not written to Business Central
- The same goes for inventory — it comes out of Business Central, not in
- The standard API carries no tracking numbers and no inventory per location
- Dynamics 365 Finance & Supply Chain is a different product and not covered
- DurabilityApplies to this integration as to every workflow in ConFlowIO.
- Failed steps retry themselves
- Large reads are processed page by page, each page a step of its own
- A failed run is continued rather than started over
- Live logs per step, with credentials removed
Works well with
What works with Business Central
Frequent partners
Items and inventory out, orders in.
Contact
See Business Central on your own data
We are glad to show ConFlowIO on your own data. Bring a real slice of your items or orders.
The difference shows at real volumes — not at five sample records.
Would you like to read our whitepaper? Just say so in your enquiry and we will send it to you.
Rather write directly?info@conflowio.com