Dynamics Community Forum Thread Details

D365 Business Central and CRM sync issue

Hi I am trying to Sync Business Central with CRM using standard assisted setup which is working fine. I have added a Status field in Item with options Open,Pending Approval,Approved which I want to sync with Product table in CRM. There are 2 fields Status and Status Reason for this which we can use.

Status -

Status Reason -

As you can see Status is not customizable so cannot use it to add options and modify captions. In Status Reason there are 4 different optionset and only 1 can be selected at a time. For example - Active is selected and I try to change it to Pending Approval it will not sync.

So I have 3 options which are:

Change option labels to Open,Pending Approval,Approved in Status Reason - Not working as mentioned above due to different optionset.
Extend Status Reason option set values - Not working as in Business Central CRM Product table has these 2 fields as option so cannot extend the option values for them.
Add a custom field in CRM similar to status reason and map it with that field - My last resort 😭

Is there any other way to tackle this or I need to go with option 3. I have tried adding a copy of Status reason in CRM product table and mapping it with Status field of item. But on doing so when I tried coupling records my Business Central crashed.