Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Error : The Record alr...
Microsoft Dynamics NAV (Archived)

Error : The Record already exists

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All Experts,

i need your help,

i cant creat a new number in register check, and the error show "the record already exists"

i checked the table but the new number that i want to register is never exists.

im using debug but this error not shown

*This post is locked for comments

  • AnnyU Profile Picture
    AnnyU 10 on at
    RE: Error : The Record already exists

    Josh Antipas  I had this issue and your suggestion worked for me. thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Error : The Record already exists

    Hey Breketoek,

    I hope you found the solution. Recently I had the same issue and finally I found out that it turned out to be the 'primary key' of the table that was causing it! I modified the primary keys of the table and it worked then!

    It's all about giving some random tries!! ;)

  • Suggested answer
    keoma Profile Picture
    keoma 32,727 on at
    RE: Error : The Record already exists

    ok, was the page or the base table customized?

    it could be that at runtime a second record with the same no. is created before you register.

  • Community Member Profile Picture
    Community Member on at
    RE: Error : The Record already exists

    Hi Jon,

    i Already open the table and remove all the filter, and the result is same. the number that i want to entry is not exist

  • Community Member Profile Picture
    Community Member on at
    RE: Error : The Record already exists

    3414.error-1.png

    print screen

  • Community Member Profile Picture
    Community Member on at
    RE: Error : The Record already exists

  • Suggested answer
    keoma Profile Picture
    keoma 32,727 on at
    RE: Error : The Record already exists

    reopen the table, check if there are any filters set, remove all filters, then recheck, if the number exists.

  • mmv Profile Picture
    mmv 11,469 on at
    RE: Error : The Record already exists

    Hi,

    Could you share the screen print of the error?

    or post the exact error and give the exact table name or id.

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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans