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

Recover Deleted PO

Someone from our team has deleted one Purchase Order. Is there anyway to recover that PO and also want to know who has deleted it?

(2) Replies

Short answer: NO.

There is no trigger or audit trail on a delete event. For recovering the PO, you would have to restore a backup.

ChrisG
By Community Manager Community Manager
Community Manager

If you are using FlexNet Manager Suite On-Premises then you may be able to find some information about the deleted PO record by querying the the CompilanceHistory view in the compliance database. This view contains one row for each tracked property value change. You may find rows recorded showing a non-NULL OldValue and a NULL NewValue that correspond to the deletion operation.

You will have to dig in to the data and work to identify a query with appropriate filtering to find exactly what you're looking for, but start with a query like the following and work from there based on what it shows:

SELECT TOP 1000 *
FROM dbo.ComplianceHistory
WHERE PurchaseOrderID IS NOT NULL
    AND OldValue IS NOT NULL
    AND NewValue IS NULL
ORDER BY ComplianceHistoryDate DESC

 

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)