Skip to main content

Notifications

Microsoft Dynamics RMS forum

recover sales history deleted accidently with batch number

Posted on by Microsoft Employee

Hi i'm Bobmaya, i use microsoft retail management , and i have deleted accidently the sales history while i used a wrong batch number. so i would like if there somehow i can recover those files please ?

regards,

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recover sales history deleted accidently with batch number

    Hello Bobmaya,

    Unless you are running Headquarters, there is no way to recover deleted information. If you are, you can re-export out the store database, and this should include all sale information.

    This is why it is part of our best practices to always make a backup of your database before making any changes to it.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recover sales history deleted accidently with batch number

    Sorry but you cant recover the sales data that has been deleted without a backup of the information prior to deletion.

    Always make a backup before running queries or manually editing RMS database.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recover sales history deleted accidently with batch number

    i don't have a recent backup, i would like to get the sales history from a specific date

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recover sales history deleted accidently with batch number

    restore the database from a backup copy.

    Always make a backup prior to running manual sql scripts.  

    There is a table called [recordDeletedLog] but this wont give you the full information.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans