Generating report for PO's with no uploaded documents

[aansari]

Hi All,

I am trying to create a report for purchase orders with missing document upload.

I've tried different methods from existing values available at the time of report creation.

Kindly guide how I can create a report for purchase order's whose document(license properties) has not been uploaded.

Thank you in advance.

Regards,

Aftab Ansari

[ChrisG · Accepted solution]

I can't think of any direct way to get information about documents attached to purchases in the classic reports area in the FlexNet Manager Suite interface - the purchase/document relationship is not exposed in this reporting data model.

If you are using FlexNet Manager Suite On-premises and in a position to be able to directly query the compliance database for data, you could start with a query like the following to get information about purchases with no attached documents:

SELECT *
FROM dbo.PurchaseOrderDetail pod
WHERE
    NOT EXISTS(
        SELECT *
        FROM dbo.Document d
        WHERE d.PurchaseOrderDetailID = pod.PurchaseOrderDetailID
    )

You've also mentioned licenses associated with purchases. If you wanted to report purchases that are not linked to a license, you could configure a report that includes the "Purchase" object and associated "Licenses", and filter by "License Name is empty":

[aansari]

Hi Chris, thank you for the quick response.

Regards,

Aftab Ansari