Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

Cannot insert Duplicate Key while creating Case record in CRM 365 9.2

Posted on by 2,665

Hi All,

When i am creating case record in crm its saying cannot insert duplicate key & checked with for duplicate detection rule for case entity theres no rule activated on case.

In crm already ticketnumber has some number with the same number i am trying to create one more record data which will have the same ticketnumber how can we achive this ?

Thanks,

Jharana

  • Verified answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User 2024 Season 2 on at
    RE: Cannot insert Duplicate Key while creating Case record in CRM 365 9.2

    Hi,

    The ticketnumber is of autonumber type as shown below:

    pastedimage1633624919644v1.png

    and we can cannot create two cases with same ticket number because it will violet the Auto number concept. In CRM side autonumber stored as UNIQUE key

    And one suggestion to store the same ticketnumber, you can create new custom field on case entity of type Single Line of Text then either manually or with some custom approach like plugin, workflow you can populate the same field.

    Also, you can use the Parent-Child Case relationship.

    Thanks,
    Pradeep.

    Please mark this as VERIFIED it it helps.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans