Do anyone know the PQL formula to find PR which is not converted to PO within 2 days
+3@pruthvin.v11 , To find Purchase Requisitions (PR) that have yet to be converted to Purchase Orders (PO) within two days, you can use the following PQL formula. This formula assumes you have a table for purchase requisitions and a related table for purchase orders, and there is a date field indicating when the PR was created and when the PO was created for that PR. Adjust the table and column names according to your data model.
Formula:
FILTER NOT EXISTS (
SELECT 1
FROM "PurchaseOrdersTable" PO
WHERE PO."PR_ID" = "PurchaseRequisitionsTable"."PR_ID"
AND DAYS_BETWEEN("PurchaseRequisitionsTable"."PR_CreationDate", PO."PO_CreationDate") <= 2
);
Please share your feedback with me if this works. If the problem persists or is not solved, open a ticket with support, and we will gladly help you.
Have a good day!
Thank you for your response @henry.david.cueva
This formula wont work in studio side as we are adding it as Custom KPI to build analysis
+3@pruthvin.v11 , in that case, I will suggest you open a ticket with CS. We will investigate further.
Sure , Thank you
Hi
I assume you have a P2P process and there are activities like Create PO and Create PR.
You can add all the PR in an OLAP table and then apply below filter,
FILTER
(PROCESS EQUALS '’Create PR" AND NOT EQUALS "Create PO”)
OR
DATEDIFF(DD, PU_FIRST(case_table, activity_table.eventtime, activity_table.activity='Create PR’),
PU_FIRST(case_table, activity_table.eventtime, activity_table.activity='Create PO’))>2;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.