Skip to main content

Advanced D365 Integration Features

Coupling with SystemId

To match and couple selected records between Business Central and Dataverse, you use the Match-Based Coupling action. With Advanced D365 Integration, user can couple records based on the SystemId field. Here is an example.


The table mapping is pointing from Dataverse purchase order to Business Central purchase order.


On line "System ID - Purchase Order", tick the "Match on this field" checkbox.


When user creates a purchase order from CRM, the SystemId field in Business Central is automatically filled with the CRM record id.


Validate field after integration

In Microsoft Base Application, the boolean field "Validate Field" is not performing any validation. Hence, in this advanced app we added additional boolean field called "Validate Field After Integration" to trigger the validation process. Users could find this in the field mapping page.




Use more than one Table Config Template Code

Users have the ability to create and apply multiple Table Config Template Codes.


To access this function, click on the Related button, select Others, and then choose Default Template to open the Dataverse Integration Table Templates page.


Users can easily configure the application direction.


And specify where the filter should be applied to.


If multiple template codes are set up for the entry in the Dataverse Integration Table Templates page, and a template code is assigned to the standard BC as shown in the following screenshot, the former will be given precedence.


Dimension Mapping for integration mappings

By utilizing the Dimension Mapping feature, users can associate Dataverse Field Name with specific Dimension Code in Business Central, effectively serving the purpose of future reporting and analysis needs.



Enhanced Field Mapping for Customers - Accounts

Users can utilize the Dataverse GUID as the System ID when mapping the BC Customer table to the Dataverse Account table.






Same feature is also applied to Vendors (BC) - Accounts (CRM).

Enhanced Field Mapping for Items - Products

Several field mappings are added to the Items-Products table mapping.

Items (BC)Products (CRM)
TypeField Service Product Type
Vendor No.Vendor ID
Unit CostCurrent Cost
Last Direct CostCurrent Cost



Save and apply Default Mappings

By following to the steps below, users can preserve their current mappings (tables and fields) on the Integration Table Mapping Defaults page. Subsequently, they can apply these stored mappings to Integration Table Mappings page, superseding the previous mappings.





Allow deletion of coupled records with sync

In addition to the initial two standard choices, an extra selection named "Delete records" has been introduced within the "Resolve Deletion Conflicts" field. This option serves to eliminate the associated record from both BC and CRM.


Leverage Dataverse Plug-in for historical and updated data integration

On the Integration Table Mappings page, the "transaction - transaction" table mapping facilitates the synchronization of generic transactions with a schema-less XML message. This message is generated through a Dataverse plug-in that possesses the capability to track historical as well as updated data for a record. This unique capability enables the plug-in to consolidate both sets of information into a unified message.


Here presents one of the scenarios to demonstrate this advanced feature.

ProcedurePurchase Order (CRM)Purchase Order (BC)
Input Purchase Quantity for Item AI007Qty: 10Qty: 10
Input Receipt Quantity for Item AI007Qty: 5Qty: 5
Modify Receipt QuantityQty: 7Remain Unchanged

This functionality captures the quantity changes from CRM and feed the information back to BC.

ProcedurePurchase Order (CRM)
Purchase Order No.PO007
Item No.AI007
Old Value5
New Value7

BC will then update the Purchase Order with the new value accordingly.

ProcedurePurchase Order (CRM)Purchase Order (BC)
Input Purchase Quantity for Item AI007Qty: 10Qty: 10
Input Receipt Quantity for Item AI007Qty: 5Qty: 5
Modify Receipt QuantityQty: 7Qty: 7

This functionality is not limited solely to goods receipts against purchase orders; it is also applicable to various other similar scenarios.

Table Mappings display Failed Records, Skipped Records, Failed Custom Processes and Unprocessed Records

On the Integration Table Mappings page, the additional four fields will will enhance the capability for further investigation on the failed records.


When users analyze the data in more detail, the error page will present the relevant messages. Furthermore, users will have the capability to take extra actions in order to rectify any errors.