Is there a way to know how long it takes for an approver to authorize?
Is there a way to know how long it takes for an approver to authorize?
Hello
You can create a quick report from posting_proposal_auth view. I created a sample report for you
select
p.company as "COMPANY",
ifsapp.supplier_info_api.get_name(ifsapp.invoice_api.get_identity(p.company,p.invoice_id)) as "SUPPLIER ID",
ifsapp.invoice_api.get_identity(p.company,p.invoice_id) as "SUPPLIER NAME",
ifsapp.invoice_api.get_invoice_no(p.company,p.invoice_id) as "INVOICE NO",
p.authorizer_id as "AUTHORIZER",
p.user_id as "AUTHORIZED BY",
p.date_created as "CREATED",
p.change_date as"AUTHORIZED",
round(p.change_date-p.date_created, 0) as"DIFF DAYS"
from ifsapp.POSTING_PROPOSAL_AUTH p where p.company like '&COMPANY' and p.AUTHORIZER_ID like '&AUTHORIZER' and p.objstate = 'Authorized'
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.