Dynamics Community Forum Thread Details

The record is not open error when importing some quotes from Dynamics 365 Sales CRM into BC

Since a recent BC update, I think v26.5, we've been getting an issue when importing certain quotes from Dynamics 365 Sales CRM into Business Central.

This might happen for one quote, but then work for the next for the same user. The products on the quote and the customer record are coupled and sync of those coupled records works without an error. The customer in question in BC is set to Blocked=Blank (not set).

In this case, the original quote in CRM was imported into BC without an issue, but changes were needed so it had to be deleted. When the quote was revised in CRM, the subsequent BC import failed with the following: "The record is not open".

Error message:
The record is not open.

<SNIP>

AL call stack:
"CRM Quote to Sales Quote"(CodeUnit 5348).GetSalesHeaderByRecordId line 4 - Base Application by Microsoft version 26.5.38752.41642
"CRM Quote to Sales Quote"(CodeUnit 5348).ProcessActiveQuote line 20 - Base Application by Microsoft version 26.5.38752.41642
"CRM Quote to Sales Quote"(CodeUnit 5348).ProcessInNAV line 10 - Base Application by Microsoft version 26.5.38752.41642
"CRM Sales Quote List"(Page 5351)."ProcesseInNAV - OnAction"(Trigger) line 13 - Base Application by Microsoft version 26.5.38752.41642

Is anyone else encountering this and knows of a sensible workaround? The quote is Active.

I'm assume there is some underlying data issue or maybe it's a bug introduced into BC in the recent update, but I am struggling to spot what it might be.

Categories:

Dynamics 365 Sales

Quick Links