Small and medium business | Business Central, N...

"The record is not open" HTTP response error

(7) Share

Report

Posted on by swebb111

Hello,

I'm having an issue when syncing records from D365 CRM to Business Central. This is for our entities in the Netherlands and Belgium. When the VAT registration number is on a record our Netherlands environment returns the message, "The record is not open" and fails to sync the data. Belgium has some other issues with the VAT format, but really just more concerned about how to go about troubleshooting the other error message. I've looked at the VAT/VIES formatting in our Netherlands environment and can't seem to figure out what might be going wrong here. Any help would be greatly appreciated. Thanks in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

Hi, Sorry, I have not encountered this problem. If there is no problem with your settings, I suggest you post your question to the BC Yammer Group below. Microsoft technicians should be able to give you better suggestions.

Viva Engage : Dynamics 365 Business Central Partner Community (Formerly: Development) : Dynamics 365 Apps Integration : New Conversations

aka.ms/BCYammer: Dynamics 365 Business Central Partner Community (Formerly: Development)
More details: About Business Central partner community on Viva Engage (formerly Yammer)

Thanks.

ZHU

Was this reply helpful? Yes No
KP - Solution Archi... 658 on at

Like (1)

Report

Hi,

This error usually occurs when you try to modify a record directly without using GET or FINDFIRST/FINDSET while using the Web services API.

Also check if the extension which you are using has this boolean enabled

Let me know if this helped you.

Was this reply helpful? Yes No
stianjensen 5 on at

Like (1)

Report

We're seeing a very similar issue in Sweden and Denmark, since April 13th.

Via the API, we try to register new customers, and if we provide the field 'taxRegistrationNumber', they fail to be created. We have not seen issues with getting "The record is not open" previously.

Was this reply helpful? Yes No
CU22051319-0 4 on at

Like (1)

Report

We are also seeing the same issue in Sweden, using a standard endpoint, not an extension. And according to the telemetry, the error originates at StackTrace: Customer(Table 18).VATRegistrationValidation line 28 - Base Application by Microsoft Customer(Table 18)."VAT Registration No. - OnValidate"(Trigger) line 11 - Base Application by Microsoft "APIV2 - Customers"(Page 30009)."taxRegistrationNumber - OnValidate"(Trigger) line 14 - _Exclude_APIV2_ by Microsoft

So it seems to me like Microsoft has rolled out a slightly broken update?

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,443 Super User 2025 Season 2 on at

Like (1)

Report

If this helps: https://community.dynamics.com/forums/thread/details/?threadid=52491ec0-459b-46d6-8085-da6dab2ad940

https://community.dynamics.com/forums/thread/details/?threadid=a2bb1362-2531-481f-a91c-f6781560c02a

Was this reply helpful? Yes No