You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Logic/Query to create below KPI's for Purchase Requisitions/Orders

edited Sep 23, 2020 2:13PM in Reporting and Analytics for ERP 2 comments

Summary

Need Logic/Query to create below KPI's for Purchase Requisitions/Orders

Content

Need Logic to create below KPI's for Purchase Requisitions

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 sample list of KPI's implemented and more details on them.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!