Small and medium business | Business Central, N...

D365 Sales / Business Central - Order integration failures

(4) Share

Report

Posted on by CW-23050201-0

I've been going through initial implementations and preparing for go-live... all testing had been done in my DEV / UAT environments and in preparing for go-live, we refreshed PROD environments down to our DEV / UAT environments to initiate final testing. We discovered issue with our D365 Sales / Business Central sales order integration that did not previously exist (albeit, we obviously hadn't testing in PROD, only maintained its gold configuration state).

Orders fail to synchronize to Business Central with error "There are no field mapping rows for the Integration Table Mapping Name 052446F3A208465B8AE2 in the Integration Field Mapping table." - previously, I believe the error actually mentioned "CRM salesorderdetail" as the affected entity, but after trying to reinstall integration solutions and reconfigure its now throwing that random string in the error.

I've tried a complete reconfiguration of both the Dataverse Integration and the D365 Sales Integration within BC... more or less the steps identified here Upgrading an Integration with Dynamics 365 Sales - Business Central | Microsoft Learn.

I noticed that within my D365 Sales Integration configuration, both "Bidirectional Synch of Sales Orders" and "Enable Legacy Sales Order Integration" are enabled and cannot be disabled - i.e. described here Integrating with Dynamics 365 Sales - Business Central | Microsoft Learn this should not be the case. I've tried using the assisted setup wizard and enabling "Advanced" which gives you access to these options, but both are enabled and cannot be toggled (forced on). When I review the integration mappings, the sales order (header) is configured "ToIntegrationTable".

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (6)

Answers (0)

Gerardo Rentería Ga... 23,693 Most Valuable Professional on at

Like (4)

Report

D365 Sales / Business Central - Order integration failures

Hi, good day
I hope this can help you, and give you some hints.

Integrating with Dynamics 365 Sales - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,886 Super User 2025 Season 2 on at

Like (4)

Report

D365 Sales / Business Central - Order integration failures

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave1/smb/dynamics365-business-central/add-table-field-mappings-existing-integration-tables

https://community.dynamics.com/forums/thread/details/?threadid=4663c63b-7553-4e6b-8306-256495e61be3

https://www.youtube.com/watch?v=6NUiLi4pUR4

Was this reply helpful? Yes No
Cavarra 50 on at

Like (3)

Report

D365 Sales / Business Central - Order integration failures

I notice that the responders did not actually answer your question, they just provided setup information. Did you resolve this problem? I have the same problem, which had existed for several years, but now I need to address it as we now need to turn the legacy setting off.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 1,559 on at

Like (2)

Report

D365 Sales / Business Central - Order integration failures

Hello,

Your issue means the Sales Order mapping between Business Central and D365 Sales got corrupted after the refresh — the ID it’s looking for no longer exists.

Fix:

Open Integration Table Mappings.

Restore default mappings for Sales Order and Sales Order Line (Use Default Synchronization Setup).

Verify field mappings exist.

Then re-run Full Synchronization in the Sales Integration Setup.

That rebuilds the missing mapping and fixes the error.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 12,747 Super User 2025 Season 2 on at

Like (2)

Report

D365 Sales / Business Central - Order integration failures

Hello,

May this can help : https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/sync-sales-orders-both-ways-business-central-sales

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-prepare-dynamics-365-for-sales-for-integration

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,574 on at

Like (1)

Report
D365 Sales / Business Central - Order integration failures

Hi,

The error:

"There are no field mapping rows for the Integration Table Mapping Name 052446F3A208465B8AE2 in the Integration Field Mapping table"

suggests that the integration table mapping record exists, but its associated field mappings were lost or not reinitialized during your environment refresh or reconfiguration.

Here’s how to resolve it:

Go to the Integration Table Mappings page in Business Central. Locate the mapping with the ID 052446F3A208465B8AE2 (or the one linked to salesorderdetail if you can identify it by name).

Open the Integration Field Mapping page for that table. If it’s empty, you’ll need to recreate the field mappings manually or use the “Use Default Synchronization Setup” action to restore standard mappings.

If the mapping was custom or extended, you’ll need to reapply those custom field mappings using the “New Field Mapping” action. Make sure each Business Central field is correctly linked to its Dataverse counterpart.

The issue with “Bidirectional Synch of Sales Orders” and “Enable Legacy Sales Order Integration” being forced on is likely due to the assisted setup wizard applying default settings. These toggles are locked when the integration is initialized with legacy mode or when the connector version enforces compatibility.

To reset these toggles, you may need to:

Remove the integration setup completely

Clear related records in tables 5335 Integration Table Mapping and 5336 Integration Field Mapping

Re-run the assisted setup with Advanced mode, selecting only the modern integration options

Best practice after a PROD-to-DEV refresh:

Always reinitialize integration mappings using the Create new integration mappings wizard

Validate that all required Dataverse tables (e.g., salesorder, salesorderdetail) are present and mapped

Confirm that proxy tables are correctly generated and published in AL

Use telemetry or job queue logs to trace failed sync attempts and confirm mapping IDs

Helpful Reference
Mapping the tables and fields to synchronize – Microsoft Learn
Community thread: Integration table mapping missing fields
Customizing an Integration with Microsoft Dataverse – Dynamics 365 Lab

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No