D365ConsultantDivision of Sataware
D365ConsultantDivision of Sataware
Retail and distribution trading

Business Central EDI integration for X12 orders, ship notices and invoices.

A Business Central EDI integration lets retailers, distributors and manufacturers trade purchase orders, acknowledgments, ship notices and invoices with you. It uses the X12 formats they require, so nobody keys orders from a portal. Standard Business Central does not read or write X12, so something must translate between EDI files and Business Central documents. Choosing that translator, and setting up each trading partner correctly, decides whether EDI saves labor or produces compliance chargebacks.

X12
the EDI standard most US retailers use
No native EDI
in standard Business Central
Per partner
each buyer has its own specification
Warehouse building with loading dock doors

The X12 documents trading partners usually require

Transaction set
Direction
What it becomes in Business Central
850 Purchase order
Partner to you
A sales order with the partner's PO number, ship-to location and requested dates
860 PO change
Partner to you
Changes to quantities, dates or lines on the existing sales order, reviewed before applying
855 PO acknowledgment
You to partner
Accepted, changed or rejected lines sent from the sales order
856 Advance ship notice
You to partner
Built from the posted shipment with cartons, SSCC label numbers, carrier and tracking
810 Invoice
You to partner
Generated from the posted sales invoice, matching the ship notice quantities
846 Inventory advice
You to partner
Available quantity per item, calculated from Business Central stock rules
997 Functional acknowledgment
Both ways
Confirms the partner received and parsed a file; a missing 997 needs follow-up

Where the translator sits between you and each buyer

EDI has three layers. Communication moves files between companies, through a value-added network (VAN), AS2 connections or SFTP. Translation turns X12 segments into readable data and back. Integration turns that data into Business Central sales orders, shipments and invoices. Some providers cover all three; others only translate and leave the Business Central side to you or your partner.

Ownership needs to be clear. Business Central owns customers, items, prices, stock and posted documents. The trading partner owns its purchase order and its specification. The EDI provider owns the envelopes, partner IDs and the archive of files sent and received. Your item references in Business Central store the partner's item numbers or UPCs, so an incoming 850 finds your item without guesswork.

Price disagreements deserve a rule too. Sometimes an 850 arrives at a price that differs from yours. Decide in advance whether the order holds for review or takes the buyer's price. The 810 must match what the buyer expects to pay.

EDI provider app, managed service or in-house translation

Common choice

EDI app inside Business Central

Several EDI providers publish apps on AppSource that create documents directly in Business Central.

  • โœ“Trading partner maps often maintained by the provider
  • โœ“Users work EDI exceptions from Business Central pages
  • โœ“Check which of your partners the provider already supports
Hands off

Fully managed EDI service

A provider runs translation and partner onboarding and exchanges flat files or API calls with Business Central.

  • โœ“Little EDI knowledge needed in house
  • โœ“The Business Central connection still needs designing and testing
  • โœ“Per-partner and per-document charges vary widely, so compare quotes
Large volume

Own translator with custom integration

You license translation software and build the Business Central side through APIs or AL.

  • โœ“Full control over maps and timing
  • โœ“Needs someone who reads X12 fluently
  • โœ“Makes sense with many partners and in-house technical staff

Onboarding a new trading partner

  1. 1

    Read the specification

    Collect the partner's implementation guide and routing guide, and note required segments, label formats, ship windows and allowed changes.

  2. 2

    Set up identifiers

    For each Business Central EDI integration partner, record the ISA and GS identifiers, ship-to codes and item cross-references in both places.

  3. 3

    Test file exchange

    Exchange test 850s and send back 855, 856 and 810 files until the partner's testing portal or analyst passes each one.

  4. 4

    Ship pilot orders

    Run the first live orders with extra checks on carton labels and ship notice timing before switching the partner to production.

  5. 5

    Monitor every day

    Watch for missing 997s, orders that failed to import and ship notices not sent within the partner's window.

Compliance mistakes that become retailer chargebacks

  • โœ“Ship notices sent after the truck arrives, or not at all
  • โœ“Carton labels whose SSCC numbers do not match the 856
  • โœ“Invoice quantities that differ from what the ship notice said
  • โœ“Unit of measure confusion between eaches, inner packs and cases
  • โœ“Shipping to a distribution center when the order named a store
  • โœ“Ignoring PO changes and shipping the original quantities

EDI questions from distributors and manufacturers

Does Business Central include EDI?

No, standard Business Central has no built-in X12 translation. It has the documents EDI needs, such as sales orders, shipments, invoices and item references, and an API that providers use. The translation and communication come from an EDI provider app, a managed service or your own software. That is normal for ERPs in this size range.

Do we need a VAN?

Only if a trading partner requires one or your provider uses one. Many large retailers accept AS2 connections, and many EDI providers include network access in their service. Some buyers still insist on a particular VAN or interconnect. Your partners' specifications answer this, which is why we read them first.

How do carton labels and ship notices come out of Business Central?

They come from the packed shipment. Someone, or a warehouse app, records which items went in which carton. The system assigns SSCC numbers and prints GS1-128 labels. Then it builds the 856 from the same data. Standard Business Central does not do carton-level packing on its own, so this usually comes from the EDI app or a warehouse add-on. Getting packing right is most of the effort in 856 compliance.

More Business Central EDI integration questions

Can EDI orders flow in without anyone checking them?

Clean orders can, and exceptions should stop. We set rules so an 850 with a known customer, known items, expected prices and a valid ship-to becomes a released sales order automatically. Anything else waits in a review list with the reason shown. Buyers accept that, as long as acknowledgments still go out on time.

We already use EDI with our old system. What changes when we move?

Your trading partners should see as little change as possible. Partner IDs and connections normally stay with your EDI provider. We rebuild the maps between EDI data and your ERP for Business Central. Every partner still needs retesting, because a small difference in the 856 or 810 can trigger chargebacks. We schedule that retesting as part of the migration plan.

Talk to us about your project.

Tell us what you run today and what has to change. A senior consultant replies with a written next step.

Get started

Start with a scoping conversation.

Thirty minutes with a senior consultant - not a sales call. We look at how you run today, tell you plainly whether Business Central is the right fit, and give you an honest sense of scope, cost and timeline before you commit to anything.

What happens next
1
We review your enquiry
A consultant reads it before the call - no discovery questionnaire to fill in.
2
30-minute scoping call
Your processes, your current systems, and the gaps that matter most.
3
Written summary & estimate
Indicative phases, licence counts and a cost range, in writing within three days.
Reply within one business day
NDA signed before discovery on request
No obligation, no cost for the scoping call
Microsoft-certified consultants only
Request your scoping call
Four fields. A consultant replies within one business day.
No cost
Your details stay with our consulting team - never shared, never added to a mailing list.