Semi new to IFS and I have been tasked to track Demand Requisitions from date created through authorization to PO. Looking to track how long it takes for folks to authorize requisitions basically. In the past they have been ‘sat on’ and never flowed through the system quickly enough.
Can anyone assist with a query that will show me created date, ALL who are required to authorize and the date this was done to PO?
Appreciate any help.
Best answer by Susith Setunga
View original
+14
Hi
Have you tried the below query from Purchase Requisition Line Authorization overview?
+11
Hi
Try below SQL,
SELECT PURCHASE_REQ_LINE_PART_API.Get_Date_Entered(pra.requisition_no, pra.line_no, pra.release_no) "PR_DATE",
pra.requisition_no, pra.line_no, pra.release_no, pra.sequence_no, pra.authorize_id, pra.authorize_group_id,
pra.signature_id "AUTH_BY",pra.date_approved,
(SELECT MIN(a.date_entered) FROM purchase_order_line_hist a, PURCHASE_REQ_LINE_PART b
WHERE a.order_no = b.ORDER_NO AND a.LINE_NO = b.ASSG_LINE_NO AND a.RELEASE_NO = b.ASSG_RELEASE_NO
AND b.REQUISITION_NO = pra.requisition_no AND b.LINE_NO = pra.line_no AND b.RELEASE_NO = pra.release_no) "PO_DATE"
FROM purch_req_line_approval pra
WHERE PURCHASE_REQ_LINE_PART_API.Get_Objstate(pra.requisition_no, pra.line_no, pra.release_no) = 'PO Created'
Hope this will help
Regards,
Akila
Hi
Have you tried the below query from Purchase Requisition Line Authorization overview?
Thank you! I am still learning what all these fields mean and how to use them. This has been a great help!
Another question: Would you know why there would be no name listed in the Authorization name field? However, I did find that the Signature line gives me what I assume would be that name.
+14
Hi
If there are no specific authorizers defined under the authorization routing template Authorizer ID and Name would be blank (as you stated) and also it means the PR line has not been authorized yet.
Authorizer ID/Name - Person to be authorized
Signature ID/Name - Person authorized (after authorization)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
