EDI & Trading Partners TrueCommerce Transaction Manager (inbound 850) → BC Sales Header Ship-to Code TrueCommerce Help Center article 6582275

EDI 850 Import Fails: Ship-to Code Cannot Be Found in the Related Table (Ship-to Address)

Raw System Error String
The field Ship-to Code of table Sales Header contains a value (xxxx) that cannot be found in the related table (Ship-to Address).

What It Means

A trading partner sends a purchase order (EDI 850) for a store or distribution center. Business Central cannot create the sales order, because the ship-to location code on the order does not exist for that customer. The PO stays in error in Transaction Manager. This is common when a retailer opens a new store or DC.

Root Cause

Sales Header "Ship-to Code" must match a Ship-to Address record on the customer card. The trading partner sends its own location code. If no Ship-to Address has that code, and no translation maps it to one that exists, Business Central rejects the value with a table-relation error.

Step-by-Step Fix

  1. Note the value in brackets in the error. This is the ship-to code that the trading partner sent.
  2. In Business Central, open the customer card for the trading partner and choose Ship-to Addresses. Check whether that location exists.
  3. If the location does not exist, create a Ship-to Address with the address from the 850 (TrueCommerce's 'Configuring Ship To Codes' article covers the setup).
  4. If the location exists under a different code, leave Business Central as it is. In Transaction Manager go to Trading Partners, select the partner, open Translations → Address List, and add a record: EDI Code = the partner's ship-to code (including the trading partner number), Bus Sys Code = the Business Central Ship-to Code.
  5. Reprocess the 850.

Verification Steps

How to verify: The 850 creates a sales order in Business Central with the correct Ship-to Code and ship-to address.

Sources & References

Early Access · 30-Day Sandbox Pilot

Stop Order Sync Failures Before Customers Notice

The Order Flow Doctor monitors Microsoft Dynamics 365 Business Central order flows across Shopify, EDI (TrueCommerce, SPS), 3PLs, and carriers. Get automated root-cause diagnosis and one-click fixes.

We respect your privacy. No spam. You will only be contacted when pilot slots open for your stack.