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 RMS (Archived) / Supplier accidentally ...
Microsoft Dynamics RMS (Archived)

Supplier accidentally deleted

(0) ShareShare
ReportReport
Posted on by Cadman 26

Hello Everyone, I have a client who accidentally deleted a supplier from RMS 2.0 database. What is best way of restoring the supplier and confirming all items and other linkages are restored within the database?

Thanks for any suggestions offered.

*This post is locked for comments

I have the same question (0)
  • raelhefn Profile Picture
    raelhefn on at

    You must insert deleted supplier with it previous id to keep supplier history

    SET IDENTITY_INSERT Supplier ON

    INSERT Supplier(ID,.., ...,) VALUES (Deleted_id, ,.., ...,)

    SET IDENTITY_INSERT Supplier OFF

    You can get your deleted supplier.id from record deleted log Table

  • Cadman Profile Picture
    Cadman 26 on at

    Thank you Ramy. Just to clarify..... these are SQL Query command you've provided? Where exactly can the deleted log table be found.

    Cheers

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at

    You can get your deleted supplier.id from record deleted log Table

    For HQ --> HQRecordDeletedLog it will give you deleted Records from any table

    For Store --> RecordDeletedLog

    to insert deleted supplier

    SET IDENTITY_INSERT Supplier ON

    INSERT INTO Supplier

                            (ID, SupplierName, Code)

    VALUES        (Deleted_Supplier_ID,'SupplierName','SupplierCode')

    SET IDENTITY_INSERT Supplier OFF

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at

    "HQRecordDeletedLog" RMS Table contains all deleted records from HQ and "RecordDeletedLog" RMS Table contains all deleted records from Store

  • Cadman Profile Picture
    Cadman 26 on at

    Hi Ramy

    I cannot find a log file related to HQRecordDeletedLog or RecordDeletedLog. I searched the server drives and the local computer. Can you provide the path or confirm the log file names?

    Thanks for your help.

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans