Accounts Payable Workload Metric for Lawson?

moving to S3 Financials forum

Thanks John.

I would like to add that we use Perceptive/ImageNow to process invoices into Lawson, I don't think that would make a difference though. It just amazes me that this report might not exist, I'm think it does somewhere, it has to. It's just finding out where that is, haha.

Start with AP295, and see if that's what you're looking for.

We are a Perceptive client as well, but are pulling our productivity stats from Perceptive vs Lawson due to having only one Lawson authorization code setup for the import from Perceptive into Lawson. We are just counting the number of documents finished by work queue, so numbers may not be 100% but give our AP Manager a good picture of productivity.

If you have any additional questions like me know, do my best to answer them.

Below is the SQL we use to get the number for the prior month:

SELECT NAME.QUEUE_NAME,
USR.USR_NAME,
USR.USR_LAST_NAME,
USR.USR_FIRST_NAME,
datename(month,HIST.FINISH_TIME) AS WORK_MONTH,
COUNT(HIST.ITEM_ID) AS INV_COUNT
FROM [INOW].[inuser].[IN_WF_ITEM_QUEUE_HIST] HIST,
[INOW].[inuser].[IN_WF_QUEUE] NAME,
[INOW].[inuser].[IN_SC_USR] USR
WHERE
HIST.QUEUE_ID = NAME.QUEUE_ID
AND HIST.FINISH_USR_ID = USR.USR_ID
AND CAST(HIST.FINISH_TIME AS DATE) BETWEEN DATEADD(m,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()), 0)) AND DATEADD(month, DATEDIFF(month, 0, GETDATE()), -1)
AND USR_LAST_NAME <> ''
GROUP BY NAME.QUEUE_NAME, USR.USR_NAME, USR.USR_LAST_NAME, USR.USR_FIRST_NAME, datename(month,HIST.FINISH_TIME)
ORDER BY USR.USR_LAST_NAME, NAME.QUEUE_NAME