You’re offline. This is a read only version of the page.
5
We are setting up the standard synchronization between Business Central and Dataverse for the Customer table. Our goal is to map the standard Salesperson Code field in BC to the OwnerId (Owner) field of the Account in CRM.
We have noticed that it is not possible to configure this mapping through the standard UI on the "Integration Field Mapping" page. The system seems to prevent this for two reasons:
It does not allow us to select fields for mapping that have a TableRelation (like Salesperson Code).
It also does not appear to permit direct mapping to destination fields that are GUID types (like OwnerId).
However, we have confirmed that we CAN achieve our goal if we create the mapping via AL code in a codeunit, using the InsertIntegrationFieldMapping function.
Our query is to confirm if this is the expected behavior. Is the standard UI configuration designed to block these complex mappings, and is using AL code the only supported and correct way to synchronize a field with a TableRelation from BC to a GUID field in CRM?
Thank you in advance for your clarification.
Best regards,
Share
Report
All responses (
Answers (
