Microsoft
Dynamics 365 Business Central
Commerce Layer
CommerceWeave
CommerceWeave + Dynamics 365 Business Central: Dynamics 365 Business Central connected to B2B commerce — customer pricing, inventory, and order management from BC data authority.
CommerceWeave's Dynamics 365 Business Central native integration connects SMB to mid-market businesses running BC to B2B commerce with real-time customer pricing, location-level inventory, and sales order creation through BC's standard web service APIs.
Data Connection Overview
ERP System
Dynamics 365 Business Central
Live Data Integration
Commerce Layer
CommerceWeave
Customers
Customer master, customer price group, credit limit, and payment terms from BC Customer table
Customer Pricing
Customer price group prices, customer-specific prices, and campaign prices from BC Sales Price tables
Location Inventory
Item ledger and availability by BC location from Item Availability views
Items
Item master, item categories, base unit of measure, and variants from BC Item table
Sales Orders
Sales order creation via BC OData API from CommerceWeave checkout
Shipments
Posted shipment and tracking data from BC posted sales shipment records
Invoices
Posted sales invoice data from BC for buyer portal access
What This Integration Enables
BC Customer Price Group and Campaign Pricing Resolution
Business Central's pricing model uses customer price groups to assign pricing tiers to customers, with customer-specific prices and time-bounded campaign prices as additional layers. CommerceWeave queries BC's price calculation for each buyer request — passing the customer number, item number, quantity, and date — to receive the effective price that BC would apply to an internally-entered order. This includes BC's standard price priority resolution: customer-specific price wins over price group price, which wins over general item price. Campaign prices that overlap the order date are applied according to BC's campaign priority rules.
BC Location Inventory for Multi-Warehouse Deployments
Business Central manages inventory at the location level, and CommerceWeave's inventory integration queries location-specific availability from BC's item availability APIs. Each buyer account is mapped to one or more BC locations, and the storefront displays inventory from the relevant locations rather than the total company quantity. Buyers in a multi-location BC deployment see availability from the locations assigned to their customer, reflecting the inventory accessible for their order rather than an aggregate that may include inventory at distant or restricted locations.
BC Sales Order Creation via Standard API
CommerceWeave creates sales orders in Business Central through BC's standard OData v4 Sales Order API, ensuring that orders are created in BC's standard document format with all required header and line fields. The BC sales order number is returned to CommerceWeave and displayed in the portal. Order status progression — released, shipped, invoiced — is tracked from BC's posted document status and reflected in the buyer portal in real time.
Common Edge Cases & Special Handling
AI Copilot for Microsoft Integration
The AI copilot maps BC's item category hierarchy, customer price group structure, and location configuration to CommerceWeave entities. It generates pricing test scenarios across all customer price groups and validates campaign pricing activation and expiration behavior.
Mapping Generation
AI Copilot reads your ERP schema and auto-generates field mapping configurations, reducing manual mapping time by up to 80%.
Test Data
Generates realistic synthetic test datasets that mirror your ERP data structure so you can validate the integration before go-live.
Validation
Runs automated validation passes against your field mappings and flags edge cases — null values, data type mismatches, and format inconsistencies.
Monitoring
Post-launch monitoring surface that surfaces sync errors, latency anomalies, and field-level data quality issues in real time.
Integration Setup Overview
Prerequisites
- Microsoft Dynamics 365 Business Central (any cloud or on-premises version with API v2.0)
- Azure AD app registration for CommerceWeave API access
- BC API permission sets for Sales, Inventory, and Customer access
Setup Steps
Configure BC API access via Azure AD app registration and assign BC permissions
Configure CommerceWeave BC connector with tenant ID, environment, and API credentials
Run AI copilot schema analysis on BC customer, item, pricing, and inventory data
Configure location-to-buyer assignment and price group mapping
Execute pricing and inventory validation test suite
Promote to production after sign-off
AI Copilot accelerates this setup
With AI Copilot enabled, steps 1–3 above are handled automatically using your Dynamics 365 Business Central schema. Most teams complete the full setup in under 2–4 weeks for standard BC implementation without writing any configuration code.
Ready to connect Dynamics 365 Business Central to CommerceWeave?
Get a personalized assessment that maps your ERP data model to CommerceWeave's commerce layer — before you commit to anything.
Related ERP Integrations
Dynamics 365 Finance & Operations
Dynamics 365 F&O connected to enterprise B2B commerce — trade agreements, site inventory, and AX order management from D365 authority.
SAP Business One
SAP Business One connected to B2B commerce — ERP-accurate pricing, inventory, and order management for SAP SMB customers.
NetSuite
Oracle NetSuite connected to B2B commerce — customer pricing, multi-location inventory, and sales order management from NetSuite authority.
Frequently Asked Questions — Dynamics 365 Business Central Integration
Get your Dynamics 365 Business Central integration plan.
Our Commerce Blueprint call includes a live integration demo and delivers a written implementation roadmap for your specific ERP version and data model.