Retrieval of Deleted Sales Order Record

(1) Share

Report

Posted on by Saurabh777

Hi All ,

Our customer is having a record of deleted Sales order, They are looking for a way to retrieve it , back to Sales order form ( Sales Table) , I told them currently there is no way to do the same , I also told them they can view in Voided Sales Order form report . but they need details related to Sales Order header , and want it back in Sales Order form

please let me know and revert on this query , if you have any suggestions , TIA

Regards
Saurabh Khatri

I have the same question (0)

All responses (11)

Answers (5)

Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

If you had setup the database log, you will be able to retrieve. You may setup now and will be able to retrieve for future deleted records.

Was this reply helpful? Yes No
Saurabh777 84 on at

Like (0)

Report

Hi BillurSamdancioglu

how to retrive , if data base log is enabled ?

Regards
Saurabh

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

On database log form, there is a button to retrieve data for the type of delete.

Was this reply helpful? Yes No
Verified answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

You can refer to this blog: dynamics-tips.com, in this article I will show you how to set up database logging and then give you a click by click walkthrough and demonstrate the functionality. We will also look at how you maintain this feature.

Best regards. You can focus on the "Type of change" field in the form.

Kevin

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

You can use the re insert button

Was this reply helpful? Yes No
Verified answer

Navneeth Nagrajan 2,430 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

If you have database logging enabled by default, then you should be able to see it under the System Administration section -> Setup -> Database log. If its hard to retrieve this data then you can alternatively raise a request in LCS and request Microsoft to retrieve the record details. The list for Database logging is a bit cluttered and it will be hard to find out the entire details of the sales order so recommend that you raise a request with MS and get a copy of that data for reference purposes and restore the same data into a lower environment and create the sales order manually/through integration (based on the scenario).

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

Has your problem been solved? If so, you can mark the thread as verified so that other users of the forum can view the post.

Best regards,

Kevin

Was this reply helpful? Yes No
Saurabh777 84 on at

Like (0)

Report

Hi all

thankyou for your responses , currently data base log for sales table is not enabled in our business environments . so i we will be raising a MS ticket once i get approval and will keep you posted once we close the issue after discussing with MS support ,Thanks

Regards
Saurabh Khatri

Was this reply helpful? Yes No
Saurabh777 84 on at

Like (0)

Report

hi Kevin Xia

Thankyou for suggestions next step is to raise MS ticket as data base log is not enabled in d365fo

Regards
Saurabh Khatri

Was this reply helpful? Yes No
Saurabh777 84 on at

Like (0)

Report

Hi all ,

i checked the data base logging , how to setup and get data , but my requirement from customer is the sales order record should get back to sales order from in data base logging we can just see who deleted, updated and changed the record but there is no button where we can get invoiced sales order back to Sales table.

Regards
Saurabh Khatri

Was this reply helpful? Yes No