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

Answered

CDS integration, I cannot figure it out

(0) Share

Report

Posted on by Hedi Daneels

487

Greetings Everyone,

I have hit a brick wall and need your help please.

Context:

- using the CDS integration, I create contacts in BC coming from the CDS

- BC refuses to create contacts if they do not have a parentcustomerid in the cds (you can find it here: CRMIntTableSubscriber.Codeunit.al, line 499

- a big chunk of our contacts dont have, and wont have a parentcustomerid in the cds

I am trying to intercept the record in an event so that I can fill in a general parentcustomerid to make the system happy, but I cannot seem to catch it to do that, it is driving me nuts for hours.

I have tried :

- OnFindUnCoupledDestinationRecord

- OnBeforeTransferRecordFields

With something like:

   if (SourceRecordRef.Number() = Database::"CRM Contact") then begin
            SourceRecordRef.SetTable(cdsrec);
            cdsrec.ParentCustomerId := 'MY-GUID';
        end;

But it is simply ignored, and returns the eternally taunting:

The contact cannot be created because the company does not exist.

Please, any advice on how to get around this silly block?

Cheers

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Andy Sather on at

Like (0)

Report

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No
Verified answer

Hedi Daneels 487 on at

Like (0)

Report

For the archives, and maybe to help someone one day

- I did not found a solution for this, so I took a different approach. I made a new integration and new mapping, from CRM contacts to BC customers, and used a bit of "onafterinsert" code to make some modifications.

Cheers Everyone

Was this reply helpful? Yes No
Suggested answer

pooya 25 on at

Like (0)

Report
it caused by wrong code in a procedure in codeunit CRMSyncHelper(maybe CDSSyncHelper in newer versions)

local procedure FindCustomersContactByAccountId(var Contact: Record Contact; AccountId: Guid): Boolean var ContactBusinessRelation: Record "Contact Business Relation"; CRMIntegrationRecord: Record "CRM Integration Record"; Customer: Record Customer; CustomerRecordID: RecordID; OutOfMapFilter: Boolean; begin if IsNullGuid(AccountId) then exit(false); //IT SHOULD BE CHANGES TO TRUE

as you can see it returns false when parent account is null, but you can simply change it to true.

as you may know you can not edit base application codes by default but it is possible as you can see in bellow link

Publishing a Code-Customized Base Application - Business Central | Microsoft Docs

Was this reply helpful? Yes No

Join the conversation

Community site session details

CDS integration, I cannot figure it out

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

CDS integration, I cannot figure it out

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates