All Collections
Business System Integrations
Dynamics 365 Business Central
Errors
Dynamics 365 Business Central - [ERROR] The field Ship-to Code of table Sales Header contains a value (xxxx) that cannot be found in the related table (Ship-to Address)
Dynamics 365 Business Central - [ERROR] The field Ship-to Code of table Sales Header contains a value (xxxx) that cannot be found in the related table (Ship-to Address)
Micah A. Parker avatar
Written by Micah A. Parker
Updated over a week ago

Product: Dynamics 365 Business Central

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


Issue: When exporting an inbound Purchase Order (850) from a Trading Partner you receive the error 'The field Ship-to Code of table Sales Header contains a value (xxxx) that cannot be found in the related table (Ship-to Address)'

Reason: The provided Ship To code is missing from your Customer Card within Dynamics Business Central

The Quick Fix


You'll need to add a translation for the Ship To code provided by your Trading Partner with a code that exists within Dynamics 365 Business Central. Be sure to add the code into Dynamics 365 Business Central if it does not exist already, otherwise you can use the Address List to convert your partner's code into a code that's within Dynamics 365 Business Central

Navigate (TM): Trading Partners β†’ (Partner) β†’ Translations β†’ Address List

Add: EDI Code (with your Trading Partner number) & Bus Sys Code with your Business Central code

Additional Resources


rev 9/22/22

Did this answer your question?