Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I get this error when importing a record in Account entity, "A record was not created or updated because a duplicate of the current record already exits." I need help to resolve this so I can import parent and child records for Account.
Background:Account Entity:Account entity has accountid (Display Name: Account), which is a primary key (default). Has name (Display Name: Account Preferred Name), which is a text (default). Then there is parentaccountid (Display Name: Parent Account), which is a lookup field (by default).
Under Account entity, I have created new field, new_cesclientid (Display Name: CES Client ID), which is a whole number and is unique too. I created this because accountid is a GUID and hard to use it by the user in an application.
After creating this field, I wanted to load the data into Dynamcis. I was able to import this record into Account successfully (Merit Health Care System, 1518). This is a parent record.
(Do Not Modify) Account
(Do Not Modify) Row Checksum
(Do Not Modify) Modified On
Account Preferred Name
CES Client ID
Merit Health Care System
Issue: I had imported 3 child records but Parent Account was blank before or it was not associated. Now, I had to update the 3 child records to their Parent Account. The record is listed below and having problem importing them. I get an error message when importing, “A record was not created or updated because a duplicate of the current record already exits.” I have checked and there is no other account by same new_cesclientid (CES Client ID).
Merit Urgent Care
Trivent Health Care
Attached is the error message.
I greatly appreciate any help that you can provide. I am a newbie and trying out different things and going over forums. Any help in detail would be greatly appreciated.
have you tried to check your duplicate detection rules on Account Entity?
I have duplicate detection rules on CES Client ID field in Account Entity. I do not have any duplication for Parent Account. See attachment.
So this should not prevent me from updating a account record, where I am associating a child record to it's parent. A parent can have multiple children, which is my above case and have problem updating my record.
Business Applications communities