Good day. I am trying to create a crosstab report in Discoverer to record the number of invoices entered by a Payables User on a given day. However, I am having problems with the invoice counts. It appears that my invoice counts (on a particular day and in the total) are either including the number of line items and/or are a running total of all invoices in the system.
I'm trying to get an overall listing of invoices entered on a particular date. For example, Payables User 1, 1/1/10 entered 10 invoices, 1/2/10 entered 30 invoices and imported 20 expense reports, Payables User 2, 1/1/10 entered 45 invoices, 1/2/10 entered 40 invoices.