• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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