I'm working on BIP reporting of employee expenses. We got a user requirement as follows:
I need to be able to run this report based off the date when the auditor approved [this expense] (when required) or the supervisor approved (if audit was not required).
I'm aware that there is a workflow under the expenses, and that it fires off approval requests to the supervisor and auditor as needed, and updates the expense according to the action they take. That logic is not exposed anywhere as far as I can tell. But to meet this requirement I would need to know which expenses require auditor approval and which do not. I would need to be able to read that workflow logic and know where a given expense stands in that workflow.
I had the user create a few expenses for me according to their knowledge of what would require auditor approval, to see if the EXM_EXP_REP_PROCESSING rows created thereby would show a usable pattern. I was checking to see if the rows got created in advance of the approval being given, or only afterward, to see if this would tell me if a given expense still required further approval not yet supplied. This did not yield anything useful.
Is there any way to satisfy this requirement?