web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Dynamics 365 Sales - B...

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

Answered

Dynamics 365 Sales - BC Custom Lookup Field Integration

(2) Share

Report

Report

Posted on by Robby

71

Hi Everyone,

I try to add some new custom field on the CRM Sales Order table and sync to BC v24.5, however the new custom field which have lookup type on CRM, not showing up on the mapping list. I already try https://yzhums.com/17065/, https://yzhums.com/49260/, and https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/administration-custom-cds-integration but still cannot figure out why the custom lookup field not showing up in the mapping list only the custom option field (Term) is showing.

Here is my code for adding new custom field on mapping list:

Only this custom field (the option type) is showing on the mapping list when try to add the mapping manually.

Any insights you could share would be greatly appreciated.

Thank you in advance for your help!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Hagru 311 on at

Like (1)

Report

Dynamics 365 Sales - BC Custom Lookup Field Integration

I know this is an old post at this point, but I struggled with this myself, this past week, and came up with an answer myself eventually, so I thought I'd share it here as well.

When mapping two custom tables, or at least from a custom table in BC, the table mapping fields are filtered. You can remove this filter to see the other fields as well, see the screenshot below. However, you cannot select a FlowField, because you will get an error saying the field must not have a relationship to another table.

I found the solution to it, by modifying a way of coding the mapping in AL. I'll link it here:

https://community.dynamics.com/forums/thread/details/?threadid=b65deede-08f9-ef11-be20-6045bda94eab

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

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

#1

Nimsara Jayathilaka. 3,864

#2

Rishabh Kanaskar 3,185

#3

Sumit Singh 2,850

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans