Need Logic/sql query to create below KPI's for Purchase Requisitions/Order
SummaryNeed Logic/sql query to create below KPI's for Purchase Requisitions/Order
We have been trying to create few KPI's for Purchase Requisition work area and got struck on how to proceed further for below KPI's.
1) Fulfilled Requisition Lines
2) Fulfilled Requisition Amount
3) Requisition Approval to PO Processing Time
4) Requisition Approval to PO Approval Time
5) Requisition Submission to Requisition Approval Time
6) PO submission to PO Approval Time
7) Requisition Unprocessed days
Can someone please share the business logic or sql query condition how we can implement above mentioned KPI's.
If anyone has already worked on the KPI's creation. Can you please share the list of KPI's implemented and more details on them.