<turbo-stream action="update" target="wiki_card"><template>
<h1>MS Dynamics BC Person Contact -&gt; D365 Sales Contact Add/Update</h1>
<p>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: :</p>
<ol>
<li>Country_Region_Code -&gt; address1_country </li>

<table>
<thead>
<tr>
<td><span><strong>MS Dynamics Business Central Field</strong></span></td>
<td><span><strong>D365 Sales Field</strong></span></td>
</tr>
</thead>

<tbody>
<tr>
<td>##BLANKVALUE(LSLOOKUP('COUNTRIES',"Country_Region_Code"),SKIPFIELD())</td>
<td>address1_country</td>
</tr>
<tr>
<td>Country_Region_Code</td>
<td>address1_country</td>
</tr>
</tbody>
</table>

<p><i>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. </i></p>
<ul>

<li>1:1 mapping where Country_Region_Code = address1_country if both fields contain the same information;</li>
<li>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.</li>
</ul></ol>
</template></turbo-stream>

<turbo-stream action="replace" target="meta_description"><template><meta content='MS Dynamics BC Person Contact -> D365 Sales Contact Add/Update' id='meta_description' name='description'></template></turbo-stream>
<turbo-stream action="replace" target="meta_keywords"><template><meta content='MS Dynamics BC Person Contact D365 Sales Contact ' id='meta_keywords' name='keywords'></template></turbo-stream>
<turbo-stream action="update" target="meta_title"><template>MS Dynamics BC Person Contact -> D365 Sales Contact Add/Update - MyRapidi Wiki</template></turbo-stream>
<turbo-stream action="prepend" target="flash"><template></template></turbo-stream>
