435
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
It is already handled in a user-friendly way. You have to set up security with your technical team correctly, so people who are not supposed to delete orders would not have access. The ones who should be able to remove them would have to be correctly educated via user training to not to remove it by accident. This way such problems could be avoided.
Thanks Vilmos,
The point that you highlighted was one because of which I was reluctant to apply this approach and I thought to get opinion.
I think there is a need to handle such situation from within application in a user friendly way because likelihood of such situation is always there.
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.
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:
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.
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.
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,
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (