You can restore table records in the menu /Administration/Search/Database log, filter on your tableId (345 for Purchtable) then filter on type of modification, delete in your case, search the record you want to restore, go to to the history tab, select it and click on the reinsert button.It will regenerate your purchase order. This works in AX 2009.
Hope it helps, please verify solution if it solves your problem.
Yes the path is correct,if you have ne records, it’s because you have no logged table, to check if it’s enabled on your table: go to \Administration\Setup\Database log and create a record for your table with the type of modification(insert, delete or update) you want to trace.
you won’t be able to restore anything before logging activation, so in your case, you won’t be able to restore your purchtable record, database logging is a preventive process
Hi, Please let me know if it takes lots of space when we set up the database log set up? Also how about the performance? Will the performance gets reduced for the users due to enabling the database log set up?
Ya i already worked on with this class. But i was bit scared to proceed further because of the LPO which has delivery note and sales invoice.Thanks deepak for the response.
Hi, Please let me know if it takes lots of space when we set up the database log set up? Also how about the performance? Will the performance gets reduced for the users due to enabling the database log set up?
I made the set up.I just tried in test server. It restored the purchase order header but it didnt restore the purchase lines. Please let me know if i need to set up something else for purchase line.