• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Utilization report

 4 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
B.Art
Basic Member Send Private Message
Posts: 6
Basic Member
6/4/2015 9:09 AM
I'm looking for either an MOA or an undiscovered report within Lawson.  We are looking at cleaning up the charge master in our A/R system and I would like to match the charge utilzation to the item ulitization within Lawson.  I'm looking for a report that I can run that will show me utilization for all of my items in my item master that we would consider billable.   Does anyone have a MOA that are willing to share that will give me utilization or is there a report in Lawson that I can't seem to find that will give me utilzation for a more that a month.   I would like to see at least a year if not longer.  Thanks in advance for any help that you are willing to share.  
Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
6/9/2015 4:30 PM
Lawson's inability to produce usage reports is pretty much how several of the consulting partners stay in business. No, there is no such report in Lawson. Our items are ordered via online req, I run sql to find items that haven't appeared on reqline in over 18 months, then I turn that over to Finance so they can see if they bill for them.
klemmyjb
Basic Member Send Private Message
Posts: 14
Basic Member
2/22/2016 5:59 PM
Kat,

Which files do you put together in SQL that give you items that haven't appeared on reqline in over 18 months please

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
2/26/2016 3:59 PM
I would query REQLINE for all items where ITEM_TYPE = N and CREATION_DATE within 18 months. And query ITEMMAST where ACTIVE_STATUS = A. In Excel I would then run a VLOOKUP in the ITEMMAST output to see which items are also in the REQLINE output. Any cells that result in #N/A would be the items that haven't been ordered on a req in the last 18 months.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
3/1/2016 7:42 PM
What John said - in sql

select ITEM
from lawson.ITEMMAST
where ACTIVE_STATUS = 'A' and ITEM not in
(
select rql.ITEM
from lawson.REQLINE rql
inner join lawson.REQHEADER rqh
on rql.REQ_NUMBER = rqh.REQ_NUMBER
where to_char (rqh.CREATION_DATE, 'YYYYMMDD') >= '20140601'
)

 

and for Requesters who haven't created reqs - it's:

 

select REQUESTER,R_NAME
from lawson.REQUESTER
where ACTIVE_STATUS = 'A' and REQUESTER not in

(
select REQUESTER
from lawson.REQHEADER
where to_char(CREATION_DATE, 'YYYYMMDD') >= '20140601'

)