---
title: "MS Dynamics BC Item -> D365 Sales Product Add/Update"
description: "MS Dynamics BC Item -> D365 Sales Product Add/Update"
keywords: "MS Dynamics BC Item D365 Sales Product"
url: "https://myrapidi.com/wiki/ms_dynamics_bc_item_d365_sales_product_add_update"
locale: "en"
published: "2024-04-24T10:36:19Z"
modified: "2024-04-30T09:45:11Z"
---

This transfer will transfer new and updated MS Dynamics Business Central Items into D365 Sales products. 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. Sales\_Unit\_of\_Measure -\> defaultuomid

| **Business Central Field** | **D365 Sales Field** |
| --- | --- |
| ##LSLOOKUP('UOM'+'#REVERSE',"Sales\_Unit\_of\_Measure") | defaultuomid |
| ##BLANKVALUE(DBLOOKUP('DESTDS','uom','name',"Sales\_Unit\_of\_Measure",'uomid'),DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid')) | defaultuomid |

_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, defaultuomid is a GUID field and a 1:1 mapping is not possible._

  - Formula ##LSLOOKUP('UOM'+'#REVERSE',"Sales\_Unit\_of\_Measure") where the defaultuomid 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;
  - Formula ##BLANKVALUE(DBLOOKUP('DESTDS','uom','name',"Sales\_Unit\_of\_Measure",'uomid'),DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid')) where two different lookups are made on the destination system in order to retrieve the defaultuomid.

_Note: In D365 Sales, you have to create a Unit Group first and then the unit of measures that you are planning to use. It’s not recommended to create 1 Unit Group for each unit of measure as they will require additional lookups._

2. defaultuomscheduleid

| **Business Central Field** | **D365 Sales Field** |
| --- | --- |
| ##DBLOOKUP('DESTDS','uomschedule','name','Default Unit','uomscheduleid') | defaultuomscheduleid |
| ##'dab7c34d-ffea-4311-9e3b-23f06d7952bb' | defaultuomscheduleid |

_Note: The D365 Sales field defaultuomscheduleid is mandatory for any new and updated product but it does not exist in MS Dynamics Business Central. The field defaultuomscheduleid = Unit Group in D365 Sales . In order to populate this field with the GUID value, you have two options:_

  - Formula ##DBLOOKUP('DESTDS','uomschedule','name','Default Unit','uomscheduleid') where a lookup on the destination system is made to retrieve the value for defaultuomscheduleid.
  - ##'dab7c34d-ffea-4311-9e3b-23f06d7952bb - a hardcoded value of defaultuomscheduleid if there is only 1 Unit Group. If you have multiple Unit Groups, additional lookups are required.