Dynamics Community Forum Thread Details

Integration sync error : while syncing Sales Orders from Dataverse

I am facing an issue while synchronizing Sales Orders between Dynamics 365 Business Central and Dataverse (CRM).

Error message:

"The data could not be updated because of the following error:
The field Document No. of table Sales Line contains a value (ORD-01058-D7K3W4) that cannot be found in the related table (Sales Header)."

This error occurs during the scheduled synchronization job (Codeunit 5340 / Integration Synch Job Runner).

Current setup:

Sales Header filter:
Document Type = Order
Status = Released
CRM Salesorder filter:
Status = Submitted

Observation:
The Sales Line sync is running, but the Sales Header is not created in Business Central, causing the Document No. validation error.

Questions:

Is there a recommended filter or sequence order for Integration Table Mapping for Sales Orders?
How should the Status mapping between CRM Salesorder and BC Sales Header be configured?

Any guidance on the correct configuration for Sales Order synchronization between BC and Dataverse would be appreciated.