--- title: "Business Central SPS Commerce Integration | APIWORX" url: https://apiworx.com/product/microsoft-business-central-sps-commerce-integration description: "Automate SPS Commerce retailer documents around Dynamics 365 Business Central orders, shipments and invoices. Managed EDI operations by APIWORX." lang: en --- Commerce operations automation · Connect · Automate · Orchestrate · Flat-fee pricing Retailer EDI · Supply chain Microsoft Business Central: https://apiworx.com/connectors/microsoft-business-central SPS Commerce: https://apiworx.com/connectors/sps-commerce # Connect Microsoft Business Central + SPS Commerce Automate purchase order (850), po acknowledgement (855), ship notice (856), invoice (810), inventory advice (846) between Microsoft Business Central and SPS Commerce — with monitoring and managed support from APIWORX. See How It Works APIWORX connects the systems your business already uses and takes responsibility for the agreed integration workflows after go-live. The exact objects, direction and cadence are fixed in writing during scoping. ERP + eCommerce Specialists Managed & Monitored Integrations Expert Integration Team APIWORX Provides the Service ## Yes. APIWORX connects Microsoft Business Central and SPS Commerce. But connecting the applications is only the beginning. The work that costs you time sits in the process running between them. APIWORX automates that process end to end — the objects moving between Microsoft Business Central and SPS Commerce, the ownership rules that decide which system wins, the exceptions when a record will not post, and the monitoring that tells someone before your team finds out from a customer. Order-to-cash automation: https://apiworx.com/solutions/order-to-cash EDI & B2B commerce: https://apiworx.com/solutions/edi-b2b-commerce Inventory synchronization: https://apiworx.com/solutions/inventory-synchronization How it works ## From requirements to a managed integration 1 ### Tell Us What You’re Connecting Provide the systems, workflow and business requirements. 2 ### We Design the Integration APIWORX recommends the integration architecture, mappings and implementation approach. 3 ### We Build, Monitor & Support It APIWORX implements the integration and provides ongoing monitoring and support as applicable. ## Who this is for This page is for supply-chain and customer-service teams trading with retailers through SPS Commerce while Dynamics 365 Business Central runs orders, inventory and invoicing. ### What needs to be in place - An active SPS Commerce relationship with the retailers and document types you trade already identified. - Business Central (cloud, or on-premises with a supported connection path agreed in scoping) and a service account permitted to create sales documents. - Item and customer mappings — retailer item numbers, UPC/GTIN, ship-to locations — available or ready to be built. - A warehouse or 3PL able to act on released orders and return the detail a ship notice requires. ### When you may not need this One retailer with a few orders a week can be keyed in the SPS web portal. A managed integration earns its place once retailer count, document volume or chargeback exposure makes portal work a standing cost. ### What is out of scope - The exact transaction set and format are confirmed per trading partner during scoping — requirements differ by buyer and we do not claim a fixed set here. - APIWORX does not negotiate partner terms, allowances, discounts or compliance programmes on your behalf. - Label and packaging compliance remains a warehouse responsibility; the integration supplies the data it needs. ## What actually moves, and who owns it A representative scope using commonly-traded retailer documents. Which documents apply to each of your retailers is confirmed before build. Microsoft Business Central APIWORX (mapping, retries, exception queue) SPS Commerce | Object | From | To | System of record | Trigger | If it fails | Owner | | --- | --- | --- | --- | --- | --- | --- | | Purchase order (850) | SPS Commerce | Business Central | Retailer | PO received | Held in exception queue with the validation error | APIWORX | | PO acknowledgement (855) | Business Central | SPS Commerce | Business Central | Order confirmed or amended | Retried, then queued for review | APIWORX | | Ship notice (856) | Business Central / warehouse | SPS Commerce | Warehouse | Shipment posted | Held with the missing carton or tracking detail flagged | APIWORX with your warehouse | | Invoice (810) | Business Central | SPS Commerce | Business Central | Posted sales invoice | Queued; retailer rejections reported back | APIWORX | | Inventory advice (846) | Business Central | SPS Commerce | Business Central | Agreed publishing cadence | Last good file retained; failure raised | APIWORX | ## Three decisions that make or break this integration ### A retailer order arrives with an item you do not recognise Inbound purchase orders are validated against your item and customer mappings before anything is written to Business Central, so an unmapped retailer item number does not create a half-built sales order. - The document is held with the offending line identified rather than partially imported. - APIWORX adds or corrects the mapping and reprocesses the original document. - Recurring gaps are raised as a mapping change, not repeated one-off fixes. ### A shipment goes out before the warehouse returns carton detail Ship notices depend on data your warehouse produces. When detail is missing, the notice is held rather than sent incomplete and rejected. - Missing carton, weight or tracking values are named in the exception. - Once the warehouse supplies the detail, the notice is sent against the original shipment. - Repeat gaps are escalated to your named warehouse contact. ### Invoices and availability run on defined rules Invoices are generated from posted Business Central sales invoices with purchase-order and shipment references attached; availability files are published on an agreed cadence where the retailer expects them. - Invoice content derives from the posted Business Central document. - PO and ship-notice references carried through for traceability. - Cadence is agreed in scoping; no real-time claim is made here. ## Reliability and ownership The operating rules that apply to this workflow after go-live. - Every document is logged with its control reference and the trading partner it belongs to, so a transaction can be traced end to end. - Failed documents are retried on a defined schedule; anything still failing is held in an exception queue rather than partially processed. - Duplicate prevention keys on the partner's own purchase order or document identifier. - Exceptions are worked by the APIWORX team and escalated to your named contacts when a business decision is needed. - New partners, new document types and changed requirements are handled as mapping work inside the ongoing engagement. - Support windows and response commitments live in your agreement; this page does not state an SLA. ## How a document is traced Illustrative — not customer data An illustrative reference trace across the retailer document cycle and Business Central. | Retailer purchase order number | Business Central sales order number | | --- | --- | | Retailer ship-to location | Business Central location and address | | Business Central posted shipment | Outbound ship-notice reference | | Business Central posted invoice | Invoice submission reference | ## Scope and questions Which documents do you support? Confirmed per retailer in scoping. Commonly traded transactions include the purchase order, acknowledgement, ship notice, invoice and inventory advice. Do we replace SPS Commerce? No. SPS stays as your trading network. APIWORX handles the mapping into Business Central and the daily exception work. Does this work with on-premises Business Central? A supported connection path is confirmed in scoping. Cloud environments use the standard APIs; on-premises requires an agreed access route. Who owns exceptions? APIWORX works the queue and escalates to your named contacts when a business decision is required. Your integration plan ## Get My Integration Plan Tell us what systems you need connected. We’ll recommend the architecture, implementation approach, timeline and estimated price range. ## Related integrations Sage Intacct + SPS Commerce The same retailer flow with Sage Intacct. https://apiworx.com/product/sage-intacct-sps-commerce-integration Acumatica + SPS Commerce The same retailer flow with Acumatica. https://apiworx.com/product/acumatica-sps-commerce-integration Business Central integrations All Business Central workflows. https://apiworx.com/integrations/microsoft-business-central ## Ready to map your integration? Next step ## Scope your SPS Commerce + Business Central integration Tell us your systems and documents. A specialist confirms scope by email. Scope this integration (https://apiworx.com/free-assessment?from=scope&pair=SPS+Commerce+%2B+Business+Central&landing_page_url=https%3A%2F%2Fapiworx.com%2Fproduct%2Fmicrosoft-business-central-sps-commerce-integration) ## Structured data ```json [ { "@context": "https://schema.org", "@graph": [ { "@type": "Organization", "@id": "https://apiworx.com/#organization", "name": "APIWORX", "alternateName": [ "APIWorks", "Apiworx" ], "url": "https://apiworx.com/", "logo": { "@type": "ImageObject", "@id": "https://apiworx.com/#logo", "url": "https://apiworx.com/og-image.png", "caption": "APIWORX" }, "image": { "@id": "https://apiworx.com/#logo" }, "description": "APIWORX is a commerce operations automation platform that connects ERP, ecommerce, marketplaces, EDI, fulfillment, suppliers, and financial systems and automates the workflows running between them.", "foundingDate": "2018", "sameAs": [ "https://www.linkedin.com/company/apiworx", "https://x.com/apiworx", "https://www.facebook.com/apiworx", "https://www.instagram.com/apiworx" ], "address": [ { "@type": "PostalAddress", "streetAddress": "1401 Lavaca Street Suite 241", "addressLocality": "Austin", "addressRegion": "TX", "postalCode": "78701", "addressCountry": "US" }, { "@type": "PostalAddress", "addressLocality": "Chennai", "addressCountry": "IN" }, { "@type": "PostalAddress", "addressLocality": "Manila", "addressCountry": "PH" }, { "@type": "PostalAddress", "addressLocality": "Buenos Aires", "addressCountry": "AR" } ] }, { "@type": "WebSite", "@id": "https://apiworx.com/#website", "name": "APIWORX", "alternateName": [ "APIWorks", "Apiworx" ], "url": "https://apiworx.com/", "inLanguage": "en-US", "description": "APIWORX is a commerce operations automation platform: it connects ERP, ecommerce, marketplaces, EDI, fulfillment, suppliers, and finance, and automates the business processes running between them.", "publisher": { "@id": "https://apiworx.com/#organization" }, "potentialAction": { "@type": "SearchAction", "target": { "@type": "EntryPoint", "urlTemplate": "https://apiworx.com/connectors?q={search_term_string}" }, "query-input": "required name=search_term_string" } }, { "@type": "SoftwareApplication", "@id": "https://apiworx.com/#software", "name": "APIWORX", "operatingSystem": "Web", "applicationCategory": "BusinessApplication", "description": "Commerce operations automation platform — prebuilt connectivity across ERP, ecommerce, marketplaces, EDI, and fulfillment, with proven commerce workflows operated by an expert team. Flat-fee pricing.", "url": "https://apiworx.com/", "offers": { "@type": "Offer", "price": "0", "priceCurrency": "USD" }, "publisher": { "@id": "https://apiworx.com/#organization" } } ] }, { "@context": "https://schema.org", "@graph": [ { "@type": "WebPage", "name": "Business Central SPS Commerce Integration — Retailer EDI Automation | APIWORX", "description": "Automate SPS Commerce retailer documents around Dynamics 365 Business Central orders, shipments and invoices. Managed EDI operations by APIWORX.", "url": "https://apiworx.com/product/microsoft-business-central-sps-commerce-integration", "isPartOf": { "@id": "https://apiworx.com/#website" }, "breadcrumb": { "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://apiworx.com/" }, { "@type": "ListItem", "position": 2, "name": "Integrations", "item": "https://apiworx.com/integrations" }, { "@type": "ListItem", "position": 3, "name": "Business Central + SPS Commerce" } ] } }, { "@type": "Service", "name": "Business Central + SPS Commerce Integration", "serviceType": "Managed integration", "description": "Automate SPS Commerce retailer documents around Dynamics 365 Business Central orders, shipments and invoices. Managed EDI operations by APIWORX.", "url": "https://apiworx.com/product/microsoft-business-central-sps-commerce-integration", "provider": { "@id": "https://apiworx.com/#organization" }, "areaServed": "Worldwide" }, { "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "Which documents do you support?", "acceptedAnswer": { "@type": "Answer", "text": "Confirmed per retailer in scoping. Commonly traded transactions include the purchase order, acknowledgement, ship notice, invoice and inventory advice." } }, { "@type": "Question", "name": "Do we replace SPS Commerce?", "acceptedAnswer": { "@type": "Answer", "text": "No. SPS stays as your trading network. APIWORX handles the mapping into Business Central and the daily exception work." } }, { "@type": "Question", "name": "Does this work with on-premises Business Central?", "acceptedAnswer": { "@type": "Answer", "text": "A supported connection path is confirmed in scoping. Cloud environments use the standard APIs; on-premises requires an agreed access route." } }, { "@type": "Question", "name": "Who owns exceptions?", "acceptedAnswer": { "@type": "Answer", "text": "APIWORX works the queue and escalates to your named contacts when a business decision is required." } } ] } ] }, { "@context": "https://schema.org/", "@type": "SoftwareApplication", "applicationCategory": "BusinessApplication", "name": "APIWORX", "image": "https://sourceforge.net/s/apiworx/icon", "description": "SourceForge Software Rating", "aggregateRating": { "@type": "AggregateRating", "ratingValue": "5", "bestRating": "5", "ratingCount": "1" } } ] ```