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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Restore deleted record...
Microsoft Dynamics AX (Archived)

Restore deleted record from table??

(0) ShareShare
ReportReport
Posted on by Adrian1234 657

Hi, so i just deleted a record from vendorpackingsliptrans table because a user mistakenly input the wrong received qty, and now i've mistakenly deleted the record in vendorpackingsliptrans, now i was thinking the remaining qty should go back the way it was, but it was not.

is there a way to restore a record to the table?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi Adrian1234,
    The only way to restore it is to use database backup, if you have one. And never delete records from SQL or AOT, you should always fix data through AX UI and use functions like credit or return.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

    Hi Adrian,

    If database logging was enabled, it would be possible to re-insert a record, but as there might be more tables involved with all kind of references it is not best practice here.

    If you have a backup of the database, an SQL administrator would be able to re-insert the record and possibly related records. Note that you have to test it in a separate environment first.

    Or you can use the backup to do a full point in time restore. It all depends on when it happened and what was entered/posted in the meantime

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

    This is forbidden action.

    If you have backup as Experts said, try to restore this record in test environment first

    If not you must back to the last backup and re enter all data again.

  • Inogic Profile Picture
    Inogic 682 on at

    Hi Adrian,

    Yes, there is way to restore the deleted record. You can undo the changes and restore deleted records to its last known state with the help of our productivity app – Click2Undo.

    Thanks!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

    Click2Undo is not suitable for Dynamics AX 2012 as far as I know...

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans