web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Vendor Item No. from BC Item table is not Synced to Sales CRM

(0) ShareShare
ReportReport
Posted on by 40
I am integrating Business Central and Dynamics Sales CRM using the Dynamics 365 connection setup. When I am syncing the Item-Product table, the Vendor Item No. is not getting synced to the Dynamic Sales CRM. The value becomes blank in CRM. If the value is updated in CRM and synced to Vendor Item No. in BC it becomes 0. All the other fields are being synced properly while this is having an issue. 
Does anyone knows what could be the problem of Vendor Item No. not being synced?
Thanks and Regards.
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    is there customization in place that changes the logic?

    Thanks.

  • Suggested answer
    Greg Enns Profile Picture
    1,122 on at

    Did you look at the Field Mapping for the the Item-Product Table Mapping. The field mapping should show you if that field is being synced and in what direction.

  • MSD_BC_User Profile Picture
    40 on at

    Hi Maco Mels,

    Managed to find the cause and the solution for this problem.

    Yes. I am mapping the Vendor Item No. to a custom field in Sales CRM.  I used the altpgen to generate the Sales crm table extension.  The external type was somehow set as 'Text' for the field.

    There was not any error shown in VSC but just that the data was not synced.  After many hours of trial and error, I managed to find that the problem was with the ExternalType.  When I changed from Text to String then it started to sync.  The below code is for the field with correct ExternalType.

    field(10199;new_bcvendorcode;Text[100])

       {

         ExternalName = 'new_bcvendorcode';

         ExternalType = 'String';

         Description = '';

         Caption = 'BC Vendor Code';

       }

    Thanks and regards.

  • MSD_BC_User Profile Picture
    40 on at

    Hi Greg Enns, thanks for your response.  Managed to solve the problem. it was due to the incorrect ExternalType in the table extension for that Field.

    Thanks and Regards.

  • Verified answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Thank you for confirmation. Also a great suggestion  provided by Greg.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 755 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 413 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 387 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans