web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Dataverse Connection Sync "User" field error

(1) ShareShare
ReportReport
Posted on by 32
Hello, I am integrating data between dataverse and business central. I have a table named X includes /cr334_SystemUser/ lookup column (related systemuser table) in dataverse, also I have a table named X includes /User/ field with table relation to /User/ (system table). When I tried to sync these tables, it gives below error:
The data could not be updated because of the following error: Table User must be mapped to table CRM Systemuser to transfer value between fields User and cr334_SystemUser.
 
There is no sense mapping these tables because both are system tables and automatically includes data.
I added these tables to integration table mapping but I could not manage to couple records, so this time X table syncing gives another error like /This user record is not a coupled record in dataverse/.
 
Any ideas how to resolve this issue?
I have the same question (0)
  • Suggested answer
    Judy Profile Picture
    Microsoft Employee on at
    Hi, for the error messages, please go to the Integration Table Mappings form to map the fields user and cr334_SystemUser:
  • mertadsay Profile Picture
    32 on at
    thanks for your response but they are already mapped. Actually reason of the error is these fields are mapped. When I remove mapping sync works great, but I cant synchronize the user fields.
  • Judy Profile Picture
    Microsoft Employee on at
    Hi, thanks for your response.
    In the Resolve Deletion Conflicts and Resolve Update Conflicts columns, you can specify how Business Central will resolve conflicts that occur because records were deleted in tables in one or the other business application, or updated in both.
    The reference MS document:
    Hope it helps.
     
    Best Regards,
    Judy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,060 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,086 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 700 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans