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 report that shows all approval assignees who have NOT approved invoice

Accepted answer
227
Views
15
Comments
edited Oct 17, 2017 6:15PM in Reporting and Analytics for ERP 15 comments

Summary

We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)

Content

We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet).  Unfortunately the report we built shows all past and present “assignees” rather than just providing the “open/incomplete” approvals.  I’ve attached some screenshots as well as an archive of the analysis we built.

I am no OBTI/SQL expert but is there a quick a simple way to return only the “most recent” assigned value in the data set for a particular invoice?  Interestingly enough if we go to BPM, look up the invoice and sort by “Assigned” it correctly returns only the INCOMPLETE (unapproved) pending approvals which is out desired result.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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