Add Custom field on Customer Table to Dataverse connector

(6) Share

Report

Posted on by Hein Kruger

629

Hi,
I added a new Custom field "Region Code" on the Customer Table in BC.
I can see it on the Customer Card and the Customer list.

I'm trying to add "Region Code" to the Integration Table Mapping, however I can only see the Previous fields I added awhile ago.
How can I force the Integration Table Mapping to "Capture" the new field.
My extension is installed as a PTE.

Thank you in Advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following helps.

Business Central 2024 wave 1 (BC24): Add table and field mappings to existing integration tables (Dataverse)

https://yzhums.com/49260/

Dynamics 365 Business Central: Customizing an Integration with Microsoft Dataverse (Integrate custom tables)

https://yzhums.com/17065/

PS:

Dynamics 365 Business Central Blog Series: Integrate with Microsoft Dataverse

https://yzhums.com/63916/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

I hope the following links can give you a better idea:

https://video2.skills-academy.com/en-us/dynamics365/release-plan/2024wave1/smb/dynamics365-business-central/add-table-field-mappings-existing-integration-tables

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-how-to-modify-table-mappings-for-synchronization

https://learn.microsoft.com/en-us/dynamics365/business-central/admin-synchronizing-business-central-and-sales#standard-table-mapping-for-synchronization

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

BC24: Manual integration mapping with Dataverse and Business Central - Discover Microsoft Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

Hein Kruger 629 on at

Like (3)

Report

Solved it by using the following link:
https://community.dynamics.com/forums/thread/details/?threadid=b65deede-08f9-ef11-be20-6045bda94eab

Also,
You need to add the CRM field on the CRM Accounts Table.
I used the "AL Table Proxy Generator tool (altpgen)".
https://yzhums.com/17065/
When the field has a table relation you need to add the relation Table as one of the entities as well.

.\altpgen -project:"*****" -packagecachepath:"********" -serviceuri:"********" -entities:account,region -baseid:18 -tabletype:CRM -clientid:********* -redirecturi:"*******"

The Output was a table Extension on CRM Accounts with region as a new field of type GUID.

Was this reply helpful? Yes No