Dynamics Community Forum Thread Details

Best Practise on Dual Write Setup

Dear all,

I would like to ask you help in managing these two scenarios about the Dual Write configuration, seems that neither MS is finding out the correct answer:

1) When we start a new initial sincronization, Sales Quotation Headers are shared from D365 F&O to CRM. The issue is that, for Quote in status "Sent" or "Won", Sales Quotations Lines are not shared to CRM (seems that in CRM the header has status = "Active" and will not allow any updates, so no lines are updated).

The problem is that in D365 F&O, if a Quote "Sent" or "Won" or if a Sales Order linked to a Quote are updated, there is an error that state that dual write can't find Sales Quotation Lines in CRM.

Do you have any suggestion on how to make the initial sync for all Sales Quotation Lines? Also the one linked to Sales Quotation Header "Sent" or "Won"?

2) When we Go-Live a new company on Dynamics CRM (already live on D365 F&O), we have to stop all dual write interfaces in order to make the first data sincronization of the new company. This action is taking around 8-10 hours and, of course, during this time all existing company in CRM cannot make their business as all interfaces are in "STOP" status and record created\updated will never be recovered.

This is causing of course a business discomfort because interfaces are shut down for several hours. The workaround is to make the new activiation during night time.

Are we managing this in the wrong way or is this the only solution available?

Thanks in advance for your help and attention, hope my questions are clear enough.

Have a nice day,

Andrea