How can I associate a Workflow Approval to its Invoice in AP?
Greetings,
I am deriving metrics for our Payables group and one of there metrics is the time it takes to approval an invoice. Within the WF_Activities table, I can find the approval activities (APINVAPR) those that are approved (result_type = WFSTD_APPROVAL) and compute the duration(Begin - End).
My questions is; how can I associate/link this approval to its corresponding invoice?
My thanks and deepest appreciation for any suggestions you may provide.
Tom
I am deriving metrics for our Payables group and one of there metrics is the time it takes to approval an invoice. Within the WF_Activities table, I can find the approval activities (APINVAPR) those that are approved (result_type = WFSTD_APPROVAL) and compute the duration(Begin - End).
My questions is; how can I associate/link this approval to its corresponding invoice?
My thanks and deepest appreciation for any suggestions you may provide.
Tom
Tagged:
0