Need to Write SQL Report Based on Account Coding Workflow Details (Date Initiated)
SummaryWe are trying to report on AP clerk performance and need to be able to capture when they initiated an invoice for account coding
Ultimately, we are trying to report the number of invoices each AP clerk 'processed' in a given date range. We added a dff on the invoice header for the processor to select their name.
For invoices that can be matched to POs or coded directly, we are capturing the creation date of the corresponding record in xla_events for the AP_INVOICES entity code and can perform counts on the invoices using this logic because it's upon initial validation of an invoice that it inserts a record in xla.