Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
Accounts Payable Workload Metric for Lawson?
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
274
Members:
0
Total:
274
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
Accounts Payable Workload Metric for Lawson?
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
NBayless
New Member
Posts: 3
12/17/2018 2:15 PM
Hello, I just joined the group today, so if this is in the wrong place I apologize.
I'm a new Lawson user, and just got an AP Manager job a few months ago. I'm having problems getting any kind of report that can help measure AP workload, specifically how many invoices in a certain amount of time that each processor processes. This is probably even the most important AP metric there is. Right now I have no idea how to measure workload. I've been told by our Accounting Manager that this doesn't exist, and our IT department is having trouble locating a report as well. Does anyone know if there is a report out there that I can use to measure workload? I don't mind scrubbing the report however, just need something that I can enter in the date range and it tells me who processed the invoices.
Thanks for any help!!
Neal
Tags:
AP Accounts Payable
John Henley
Senior Member
Posts: 3348
12/17/2018 2:17 PM
moving to S3 Financials forum
Tags:
AP Accounts Payable
NBayless
New Member
Posts: 3
12/17/2018 2:27 PM
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.
Tags:
AP Accounts Payable
John Henley
Senior Member
Posts: 3348
12/17/2018 2:35 PM
Start with AP295, and see if that's what you're looking for.
Tags:
AP Accounts Payable
O. Johnson
Basic Member
Posts: 8
12/17/2018 4:13 PM
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
Tags:
AP Accounts Payable
You are not authorized to post a reply.