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

OTBI Report for Current Invoice Approver

edited Jul 25, 2023 5:29PM in Payables, Payments & Cash Management 4 comments

Summary:

I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been able to accomplish this by using three filters.

  1. Approval Status is equal to / is in  Initiated
  2. Approval Action is equal to / is in  Assigned to; Delegated to; Escalated to; Information requested from; Reassigned to
  3. ( MAX("Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action Date" By "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID") = "Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Action Date")
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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