Table connection for table type CRM must be registered using RegisterTableConnection

(4) Share

Report

Posted on by Gaetan Hamel

I am getting error when trying to use CRM Table from sales 365 to Business Central and modify or update in Sales 365 (CRM) using Custom Business Central API.

Exemple :

Error: "Table connection for table type CRM must be registered using RegisterTableConnection or cmdlet New-NAVTableConnection before it can be used"

procedure LookupCRMProduct(var CRMName: Text[250]): guid
var
   CRMProduct: Record "CRM Product";
begin
   CRMProduct.SetRange("Name", CRMName);
   if CRMProduct.FindFirst() then
       exit(CRMProduct.SystemId);
   exit('');
end;

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

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

Like (2)

Report

I also encountered this strange problem, but then I solved it after adding the following line of code.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Imran K 29 on at

Like (1)

Report

As YuN ZHU has suggested for some reason this is usually resolved by checking the connection :

CRMIntegrationManagement.IsCDSIntegrationEnabled()

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,169 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Troubleshooting Synchronization Errors - Business Central | Microsoft Learn

Error Message When Trying to Access Integration Tables

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 on at

Like (1)

Report

If you want to access a CRM table directly from your code, rather than using the Business Central's Dataverse connector, you need to add some boilerplate code. In particular, any virtual CRM table that you want to use in BC, must be initialized by calling RegisterTableConnection.

Look at the codeunit 5340 "CRM Integration Table Synch." to find an example of this initialization. OnRun trigger in this codeunit invokes the function InitConnection to set up the connection. This call ends in the table 5330 "CRM Connection Setup". You can follow the same logic and use one of the functions RegisterConnection or RegisterConnectionWithName from this table, or call Database.RegisterTableConnection directly.

Was this reply helpful? Yes No
Gaetan Hamel 36 on at

Like (1)

Report

Thank you everyone. :)

Yun Zhu answer dit the trick.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Adding for more details: https://learn.microsoft.com/en-us/dynamics365/business-central/admin-troubleshoot-sales-synchronization

https://www.dynamicsuser.net/t/table-connection-for-table-type-crm-must-be-registered/68068

Was this reply helpful? Yes No