Showing results for 
Show  only  | Search instead for 
Did you mean: 

Retrieve the deleted purchases from the database

Hi Folks, Is there any possibility retrieving the deleted purchase records from the database along with the user who deleted them?

(2) Replies
By Level 8 Champion
Level 8 Champion

Not the full answer to your question but maybe can give some ideas.
We had a similar topic where assets was deleted and we didn't want to restore the full DB. Then we basically restored an older version of the database into a new instance and from that we created a script to load the missing objects. 


one (complex) idea: maybe you can have a look in the ComplianceHistory table in the FNMSCompliance DB. You could create a sql query to retrieve the delete events of the POs. Then you can have a look for the create events of the POs and build a query to re-create the entries in the database.