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

Annual Spend by Requesting Location

 4 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
LisaLisa
New Member Send Private Message
Posts: 0
New Member
5/29/2015 4:37 PM

I need to calculate the annual spend by location/department, and wanted to know if I can get the totals from one of the purchase order tables or from one of the requisition tables? Which table and field can I use to get the total spend by department?

Thanks

LisaLisa
New Member Send Private Message
Posts: 0
New Member
5/29/2015 4:44 PM
I will probably need a combination of tables in order to calculate the spend by department (including the MMDIST table).
Michelle Wetzel
Veteran Member Send Private Message
Posts: 183
Veteran Member
5/29/2015 5:23 PM
Take a look at the MM280 report. You'll be able to enter parameters for IC, PO and AP for a company, company group, just one cost center, specific periods, etc.
LisaLisa
New Member Send Private Message
Posts: 0
New Member
5/29/2015 5:30 PM
Ok, sure. Thanks!
Michelle Wetzel
Veteran Member Send Private Message
Posts: 183
Veteran Member
5/29/2015 7:36 PM
On the tab under Selection, you can choose up to 8 requesting locations to add to your parameters.