Business Central Integration

The Microsoft Dynamics 365 Business Central (BC) integration connects WizCommerce with Business Central using the standard Business Central API. Items (products), customers, contacts, sales orders, and sales order line items sync between the two systems.

This article walks through how the connection works, what data syncs, where the BC API has documented gaps you should plan around, and what to do when something doesn't look right.

Table of Contents

Before You Begin

1. Confirm with WizCommerce team that Business Central integration is enabled for your account.
2. Have a Business Central administrator available. You will need them to provision API access and a dedicated integration user.
3. Decide which entities you want to sync (Items, Customers, Contacts, Sales Orders) and confirm the data direction for each with WizCommerce team.
4. Because the standard BC API does not expose every field WizCommerce needs (see Section D below), plan to upload the supplementary data (price lists, sales rep mapping) via Excel during onboarding.

A. How the Connection Works

Your BC administrator provisions API access in Business Central and shares credentials with WizCommerce team through a secure channel. The WizCommerce integrations team configures field mapping (sales rep mapping, catalog/pricelist mapping, etc.) and runs a first sync.

The integration pulls Items, Customers, Contacts, Sales Orders, and Sales Order Line Items from Business Central using BC's API. Note that BC keeps orders across two entities — salesOrder and salesInvoice. Once a sales order is confirmed and completed in BC, it's removed from the salesOrder table and pushed to salesInvoice. WizCommerce pulls both during sync to capture the full order lifecycle.

B. What Data Syncs Between Business Central and WizCommerce

The integration between Business Central and WizCommerce keeps your data in sync across both platforms. Below is a quick overview of the entities that sync, the direction of the data flow, and what each covers.

C. Known Gaps in the Business Central API

Business Central's standard API has a few documented limitations that are worth knowing upfront, so you can plan around them during onboarding.

» Items / Products

• Standard fields like price lists, product attributes, and product images are not part of the standard BC item API. These need to be handled inside WizCommerce or supplemented through the import service.
• Inventory data is basic, a single in-stock counter. There's no breakdown into reserved or available-to-promise quantities. Incoming inventory (on order) can be derived by integrating with the purchase order API.

» Customers

• Price lists are not in the standard API. They need to be uploaded via Excel.
• Custom attributes are not in the standard API.
• Shipping addresses are not in the standard API. The customer's primary address is what flows through.
• Sales rep mapping code is available in the standard BC API. However, for BMC specifically, the mapping needed to be done based on a different value, so we built custom salesRep field support for their account. Confirm with your CSM whether your account uses the standard mapping or requires a custom field setup.

These gaps are not bugs, they are current API limitations. The integration works around them by supporting Excel uploads during onboarding.

D. Sync Timing

The integration pulls from Business Central on a schedule. For on-demand sync, contact WizCommerce team or reach out to help@wizcommerce.com.

E. Troubleshooting and Common Issues

» A new product in Business Central isn't showing in WizCommerce

• Confirm the item is created in BC with a valid number and displayName.
• Confirm the item is not blocked = true in BC.
• Wait for the next scheduled product sync, or request a manual sync from WizCommerce team.

» Inventory in WizCommerce doesn't match Business Central

Inventory in BC is a single counter (inventory field). WizCommerce shows the value from the most recent sync. If you need reserved or available-to-promise breakdowns, those aren't surfaced by the standard BC API. For incoming inventory, the integration can be configured to pull purchase orders. Discuss with WizCommerce team if that fits your workflow.

» A customer's price list isn't applied correctly

BC's standard API does not expose price lists. Pricelist mappings are managed via an Excel upload during onboarding and updated as needed. If a customer's price doesn't look right, the mapping in WizCommerce needs to be updated. Contact WizCommerce team.

» A customer's shipping address looks wrong or is missing

The BC API surfaces the customer's primary address, not multiple shipping addresses. If your account requires multiple shipping addresses per customer, those need to be created and managed inside WizCommerce directly.

» Sales rep mapping isn't pulling through

Sales rep assignments are not in the standard BC API. They are uploaded via Excel during onboarding. If a rep mapping needs to be added or changed, contact WizCommerce team.

» A confirmed sales order disappeared from the salesOrder feed

This is expected. In Business Central, once a sales order is confirmed and completed, it's removed from the salesOrder table and moved to the salesInvoice table. WizCommerce pulls both, so the order continues to appear in WizCommerce — just sourced from the invoice side after completion. If an order is missing from WizCommerce entirely, check the BC sync history for errors.

» An order failed because of missing or invalid data

The integration validates records before processing. If a sales order is missing a customer ID, item ID, or other required field, the order is logged with an error and skipped. Open the Integration Sync History in WizCommerce to see the specific error, fix the underlying record in BC, and the next sync will pick it up.

FAQs

1. Does the Business Central integration sync product images?

A. No. Product images are not exposed by the standard BC API. They need to be uploaded into WizCommerce directly through the import service or Manage Products and Variants.

2. Can I push orders from WizCommerce to Business Central?

A. The standard BC API integration pulls from BC into WizCommerce. Confirm with WizCommerce team whether your account has any WizCommerce-to-BC push configured.

3. How do I handle sales rep assignments?

A. Sales rep mappings are uploaded via Excel during onboarding because the BC API does not expose this data. Contact WizCommerce team to update mappings.

4. Why does my inventory only show one quantity field?

A. Business Central's standard API exposes a single in-stock counter without reserved or available-to-promise breakdowns. Incoming inventory can be configured by integrating with the BC purchase order API.

5. Where do confirmed sales orders go in Business Central?

A. When a sales order is confirmed and completed in BC, BC moves it from the salesOrder table to the salesInvoice table. WizCommerce pulls from both, so you continue to see the order in WizCommerce.