Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / BC INTEGRATION WITH DY...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

BC INTEGRATION WITH DYNAMICS 365 SALES

(2) ShareShare
ReportReport
Posted on by Nicolas Payan 8

Hello, everybody,

I am trying to integrate BC and Dynamics 365 sales, I use the standard integration plus a OOB field that is not mapped between Customer Table in BC and accounts in D365 Sales, here's the field (bill-to customer).

pastedimage1674760926942v2.png

pastedimage1674760824939v1.png

After doing all the configurations to add the field in the integration table mapping -> Integration Field Mapping, I start to run the integration but I get all values as null Guid, other fields as lisDQB works fine, but this is not.

pastedimage1674761259326v6.png

The code I use is this

MicrosoftTeams_2D00_image-_2800_47_2900_.png

Regards,

Nicolas Payan

  • CU29041409-0 Profile Picture
    CU29041409-0 35 on at
    BC INTEGRATION WITH DYNAMICS 365 SALES

    The issue likely occurs because the bill-to customer field isn’t properly linked to a unique identifier in Dynamics 365 Sales. Verify the following:

    1. Ensure the bill-to customer field exists and is populated in the Customer Table in BC.
    2. Confirm the field is properly mapped in the Integration Field Mapping table and matches the corresponding schema in D365 Sales.
    3. Check if the field uses a valid GUID or unique value in both systems; otherwise, data synchronization will fail.
    4. Test the integration by running a preview to ensure the mapping logic aligns and there are no null GUID values.

    For a seamless integration, Cloudify specialize in integrating Microsoft Business Central with Dynamics 365 Sales. As a leading expert, we’ll ensure your systems work flawlessly together.

  • Nicolas Payan Profile Picture
    Nicolas Payan 8 on at
    RE: BC INTEGRATION WITH DYNAMICS 365 SALES

    yzhums

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans