How to restore unintentionally deleted Purchase order which is already sent to vendor.

(0) Share

Report

Posted on by SadiqQ

437

In Ax 2012 R3 , there is a Purchase order which is already sent to the party. But unintentionally it was deleted. Now it is to be recovered to process further.

Please advise.

*This post is locked for comments

I have the same question (1)

All responses (13)

Answers (1)

Verified answer

Nagendra Varma K on at

Like (0)

Report

HI SadiqQ,

If you have enabled the DB log, Than please check here under System Administrator->Inquires->DB Log->Select the PO and click on the re-insert option. Try if this works for you.

Thanks

Nagendra Varma K

Was this reply helpful? Yes No
SadiqQ 437 on at

Like (0)

Report

DB log is not enabled.

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report

Hello,

Do you make periodic backup for your DB? If no, you should consider this fast.

How did you prepare the PO, dont you have the initial papers with you? You can contact the supplier to forward the PO again.

Was this reply helpful? Yes No
SadiqQ 437 on at

Like (1)

Report

Yes daily full backup is configured. Backup is available but restoring from backup will restore database back to last backup. it will cause loss of work done after backup. This I don't want to do.

Creating new PO will cause new PO number assignment to this PO. I am looking into way

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report

I see, I have not seen a way to restore a record in AX if it is deleted, hope other pioneers will come in a better answer.

What you can do is to make the PO number field editable while creating this PO, this way you change the PO number and then set the field un-editable again.

Regards,

Was this reply helpful? Yes No
Suggested answer

Ben H. 175 on at

Like (1)

Report

I would suggest to have a look into the following views: PurchTableAllVersions, PurchTableArchivedVersions, PurchLineAllVersions, PurchLineArchivedVersions. You may find an archived version of your purchtable / purchline records there. If the order was deleted via GUI, this should set the isDeleted flag on the line records and not delete them from the DB.

Was this reply helpful? Yes No
SadiqQ 437 on at

Like (0)

Report
Deleted Purchase order is not found in following views:

PurchTableAllVersions,

PurchTableArchivedVersions,

PurchLineAllVersions,

PurchLineArchivedVersions.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

As a last resort you may attempt to restore the SQL Backup to another database, then use some means of selectively transferring over the removed data from PurchTable and any other tables related via Relations and Delete Actions into your Production database (but first attempting this against a Test DB). It will require some skills with SQL Server and understanding of AX metadata.

Here are some related articles on what could be attempted:

www.mssqltips.com/.../recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns

solutioncenter.apexsql.com/how-to-recover-a-single-table-from-a-sql-server-database-backup

Please note that this is not for inexperienced and faint-hearted people, because you may end up with broken record references.

Was this reply helpful? Yes No
SadiqQ 437 on at

Like (0)

Report

Because it is only one PO, is it advisable to set PO number sequence to the PO number which I lost. create the PO and then reset PO sequence to the current one.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

That is not a good idea. Postings which you have done might be referring back to the originals using RecId references (I have not actually validated this, but you could have a look), in which case the confirmed PO would be disjointed from the newly created PO. Be cautious about this, again, validate it first and experiment in a Test/Sandbox environment.

Was this reply helpful? Yes No