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
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming 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