MyRapidi
MyRapidi
Menu

Search our Wiki

MS Dynamics BC Sales Orders -> D365 Sales Orders Add/Update

This transfer will transfer new and updated MS Dynamics Business Central Sales Order Headers 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:

  1. Salesperson_Code ->Ownerid
    2. Business Central Field D365 Sales Field
    ##'/systemusers('+BLANKVALUE(LSLOOKUP('%%LSUSER%'+'#REVERSE',"Salesperson_Code"),'%%DEF_OWNER%')+')' ownerid
    ##CASE(DBLOOKUP('DESTDS','systemuser','new_salespersoncode',"Salesperson_Code",'systemuserid'),'',SKIPFIELD(),'/systemusers('+DBLOOKUP('DESTDS','systemuser','new_salespersoncode',"Salesperson_Code",'systemuserid')+')') ownerid

    Note: In Business Central, the field Salesperon_Code is a free-text field which is usually populated with the salesperson’s initials. In D365 Sales, there is no standard field that can hold this information in the same manner. Instead the owner ID is the equivalent of the Salesperson Code but it is stored as a GUID field.

    • Formula ##'/systemusers('+BLANKVALUE(LSLOOKUP('%%LSUSER%'+'#REVERSE',"Salesperson_Code"),'%%DEF_OWNER%')+')' that will retrieve the corresponding owner ID for the Business Central Salesperson Code. This data is fed into D365 Sales by a separate transfer and is available in the dynamic lookup table called LSUSER. If the formula evaluates to NULL, a default user will be assigned to the record that will be created in D365 Sales. The default owner ID is created as a TAG and the value will be the actual GUID.
    • ##CASE(DBLOOKUP('DESTDS','systemuser','new_salespersoncode',"Salesperson_Code",'systemuserid'),'',SKIPFIELD(),'/systemusers('+DBLOOKUP('DESTDS','systemuser','new_salespersoncode',"Salesperson_Code",'systemuserid')+')') which will perform a lookup on the destination (D365 Sales) but it will require setting up a new field new_salespersoncode to hold the salesperson code.