Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Need items for a specific department

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
12/3/2014 10:06 PM

    I have been asked to run a report to pull all items that fall under a specific budget for 2 different departments.

    Does anyone know what tables I would use to get this information?

     

    Bev

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
    12/4/2014 1:04 PM
      Are you looking for order history for a department and account? I would go with REQLINE and link to MMDIST.

      Link:
      REQLINE.COMPANY===MMDIST.COMPANY
      REQLINE.REQ_NUMBER===MMDIST.DOC_NBR_NUM
      REQLINE.LINE_NBR===MMDIST.LINE_NBR
      REQLINE.REQ_LOCATION===MMDIST.REQ_LOCATION
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Michelle Wetzel
      Veteran Member
      Posts: 183
      Veteran Member
      12/4/2014 3:10 PM
        Bev,

        I like the MM280 report - you can select PO, IC and AP to pull into it.

        Michelle