MyRapidi
MyRapidi
Menu

Search our Wiki

MS Dynamics BC Person Contact -> D365 Sales Contact Add/Update

This transfer will transfer new and updated MS Dynamics Business Central contacts into D365 Sales Contacts. All mappings are either 1:1 or additional lookups have been created. However, there are specific mappings where you have more than 1 option to map the indicated fields: :

  1. Country_Region_Code -> address1_country
    2. MS Dynamics Business Central Field D365 Sales Field
    ##BLANKVALUE(LSLOOKUP('COUNTRIES',"Country_Region_Code"),SKIPFIELD()) address1_country
    Country_Region_Code address1_country

    Note:In Business Central, the field Country_Region_Code is a predefined picklist that will provide you with all country codes and country names. In D365 Sales, the field address1_country is a free text field and there are no restrictions around it.

    • 1:1 mapping where Country_Region_Code = address1_country if both fields contain the same information;
    • Formula ##BLANKVALUE(LSLOOKUP('COUNTRIES',"Country_Region_Code"),SKIPFIELD()) that retrieves the country code from a pre-existing static lookup table called COUNTRIES and ,if the formula evaluates to NULL, this field will be skipped during the data transferring process.