MyRapidi
MyRapidi

Search our Wiki

MS Dynamics BC PostedSales Invoice Lines -> D365 Sales Invoice Detail Add/Update

This transfer will transfer new and updated MS Dynamics Business Central Posted Sales Invoice lines into D365 Invoice Detail. 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 ->uomid
  2. Business Central Field D365 Sales Field
    ##LSLOOKUP('UOM'+'#REVERSE',"Sales_Unit_of_Measure") uomid
    ##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid') uomid

    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.

    • 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.
    • Formula ##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid') where one lookup is made on the destination system in order to retrieve the uomid.