How relationship work in CDS for custom entities using alternate keys

[Integartion]

How relation of standard entity like product in CRM will work in CDS.

Becuase the primary key in CRM is a Guid field and we are passing ItemId from AX which is a String feild and that works perfectly..

But when i create same relation and passing value from AX . An Error is occured of type mismatch.

How i can assign the alternate key for that perticular relation.

Can you please help ? 

[v-monli-msft]

Hi @Integartion ,

I didn't see any error shown in your screenshot, can you please share more related details about the error and the configuration?

Regards,

Mona

[Integartion]

Hi ,

Below are some details of the issue : 

1. In D365 FO we are passing ContributionId which is a string feild but in CRM it requires Guid feild for lookup. You can refer the attached error screen shot with highlighted value.

2. We need to implement this same as Product Id which we are sending as a string from FO side and they are converting it as a Guid and inserting the records in CRM.

Note : How we can implement the reference relationship in CDS where FO will send string and CRM will take that reference in Mastertable and pick primary key of it which is a Guid feild in CRM ?

Hope you understand my issue , if not then please share your email id , i can show you the issue.

my official id  : sksa@columbusglobal.com