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

CDS Integration Mapping CDS "Billing Account" and BC "Bill-to Customer No." On the Customer-Account mapping

(0) Share

Report

Posted on by Community Member

Hi everybody!

I've been going crazy over the following problem.

I am trying to map the "Billing Account" on the CDS "Account" table, to the "Bill-to Customer No." on the BC "Customer" table. So when you change either the Billing account in D365 Sales or the Bill-to Customer No. in BC, the other one changes too.

I am able to het the CRM ID in the "CRM Account" table in BC (which is the mapping table the integration uses). As followed:

But i don't know how to go further from here on, how can i get the corresponding Customer record to this CRM ID or how do i map this properly?

Does anybody have any idea? Would love to hear them.

Thanks in advance.

Frits Thissen

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Mohana Yadav 61,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

we have to couple the records in Customer List/Customer Card.

Once coupling is done, we need to run full synchronization from Integration Table mapping page.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Mohana,

The coupling and synchronization is already working. But the field "Bill-to Customer" is not synchronised in the default mapping. So i am customizing the mapping so these fields are mapped. But i don't know how to do this properly. Because both field are lookups.

Can you help with this?

- Frits

Was this reply helpful? Yes No
Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

docs.microsoft.com/.../administration-custom-cds-integration

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Marco,

Yes i have done this and i am able to map two text fields or two boolean field. But my problem is that these are two lookup fields in both systems, which isn't explained anywhere. Have any idea for this? Or am i looking over something?

Thanks

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Understand what you are saying. It is probably best to redirect this question to the yammer group where our developers or PM's may answer the question.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

Thanks.

Was this reply helpful? Yes No