<turbo-stream action="update" target="wiki_card"><template>
<h1>MS Dynamics BC Sales Lines -&gt; D365 Sales Lines Add/Update</h1>
<p>This transfer will transfer new and updated MS Dynamics Business Central Sales Order lines into D365 Sales Orders. 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>Sales_Unit_of_Measure -&gt;uomid</li>
<table>
<thead>
<tr>
<td><span><strong>Business Central Field</strong></span></td>
<td><span><strong>D365 Sales Field</strong></span></td>
</tr>
</thead>
<tbody>
<tr>
<td>##LSLOOKUP('UOM'+'#REVERSE',"Sales_Unit_of_Measure")</td>
<td>uomid</td>
</tr>
<tr>
<td>##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid')</td>
<td>uomid</td>
</tr>
</tbody>
</table>

<p><i>Note: In Business Central, the Sales_Unit_of_Measure is a pre-defined picklist which will allow you to use only the available options. In D365 Sales, uomid is a GUID field and a 1:1 mapping is not possible.</i></p>
<ul>

<li>Formula ##LSLOOKUP('UOM'+'#REVERSE',"Sales_Unit_of_Measure") where the uomid is retrieved from an existing lookup table called UOM. This data is provided by a separate transfer which updates the link storage/lookup table called UOM.</li>
<li>Formula ##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid') where one lookup is made on the destination system in order to retrieve the uomid.</li>
</ul>
</ol>
</template></turbo-stream>

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