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

Community site session details

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

Creating BC drop down fields for synching to Dataverse (Dynamics Sales)

(0) ShareShare
ReportReport
Posted on by 3,209

Hi All

When creating new fields in BC we select ENUM as type since OPTION will be deprecated in the future. However, when I look at CRM sync tables in BC, they use OPTION. So the question is should we use Enum or Option when creating new fields that need to be synched to Dynamics Sales

For example, code from Lead CRM sync table field in standard BC:

        field(10133; LeadSourceCode; Option)
        {
            ExternalName = 'leadsourcecode';
            ExternalType = 'Picklist';
            Description = 'Select the primary marketing source that prompted the lead to contact you.';
            Caption = 'Lead Source';
            InitValue = " ";
            OptionMembers = " ",Advertisement,EmployeeReferral,ExternalReferral,Partner,PublicRelations,Seminar,TradeShow,Web,WordOfMouth,Other;
            OptionOrdinalValues = -1, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;
        }
I have the same question (0)
  • Suggested answer
    Francisco Bedolla Profile Picture
    1,119 on at
    RE: Creating BC drop down fields for synching to Dataverse (Dynamics Sales)

    please check

    docs.microsoft.com/.../admin-cds-missing-option-values

    HTH

  • Suggested answer
    Nitin Verma Profile Picture
    21,698 Moderator on at
    RE: Creating BC drop down fields for synching to Dataverse (Dynamics Sales)

    You can use ENUM fields when trying to Sync from CE to BC.

  • Samantha73 Profile Picture
    3,209 on at
    RE: Creating BC drop down fields for synching to Dataverse (Dynamics Sales)

    For a custom field new function Dataverse Option Mapping front end page is not available (only for 3 std entities payment terms, shipment method, shipping agent)

    So you still have to manually create ENUM that match dataverse if you create custom fields. Is there a way to automatically create option field values  in Dataverse if we add a new value in BC? For example for the option colour I have RED,GREEN. Now in BC I add BLUE and I want the BLUE to be added as value in Dataverse

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,791

#2
YUN ZHU Profile Picture

YUN ZHU 2,091 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 2,090

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans