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
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
    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
      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
        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
          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'

            )