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 to Write SQL Report Based on Account Coding Workflow Details (Date Initiated)

Received Response
69
Views
2
Comments
edited Feb 19, 2020 12:38AM in Payables, Payments & Cash Management 2 comments

Summary

We are trying to report on AP clerk performance and need to be able to capture when they initiated an invoice for account coding

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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