MyRapidi
MyRapidi
Menu

Search our Wiki

MS Dynamics BC Item -> D365 Sales Product Add/Update

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
    2. 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
    3. 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.