We have been unable to find a column when setting up a query on how to extract the date that an invoice had final approval. This seems like it should be something that is basic and fundamental, but is not available.
Can this info be extracted and added to one of the Columns please?
@Ctwiss are you using Cognos for setting up the query?
We do have Cognos Reporting, but not sure if it links to Queries?
I am more concerned about generating a Query within the Invoice processor area to be able to see when someone completed the final Approval
EG: one of these highlighted columns
@Ctwiss I don't believe that piece of information is an option from the Processor screen. You would need to actually open the Invoice and look at the audit trail to see when the final approval was done.
@Ctwiss in case you are using Cognos for setting up your query, the below screenshot shows you were to find the data item you are looking for in the data warehouse. I hope this helps.