Skip to main content

Notifications

Announcements

No record found.

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

D365 Sales / Business Central - Order integration failures

(1) ShareShare
ReportReport
Posted on by 13
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".
 
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 5,371 on at
  • gdrenteria Profile Picture
    gdrenteria 12,750 Most Valuable Professional on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,458 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,543 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans