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

Annual Spend by Requesting Location

 4 Replies
 1 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

Mike Bernhard
Veteran Member Send Private Message
Posts: 101
Veteran Member
5/29/2015 5:17 PM
If you are interested in a single department (account unit), you can try MM80. For multiple departments or the entire enterprise, try MM280. This is the report version which can be easily converted to csv using native Lawson functionality.

When you run this, keep in mind the you can select PO, IC and/or AP depending on which transaction types you are interested in. Most dept managers like to get everything.

If you don't like the formatting that is delivered, the underlying table is called MM280 and you can run queries against that table. There is also a table called APDISTRIB that might prove useful if you are not interested in the PO detail. 

Feel free to reach out if you want to discuss.

One last note is that if you are a Healthcare Provider organization and have MedAssets or Novation as your GPO they offer some pretty cool Invoice Transaction Files that link APDISTRIB, MMDIST data to PO and PO Receiving data and the output is worth its' weight in gold. You can probably ask your GPO rep to see if this info is being extracted and, if so, perhaps you can get a copy of this data each month.


LisaLisa
New Member Send Private Message
Posts: 0
New Member
5/29/2015 5:49 PM
I used the wrong terminology. I have a list of Requesting Locations and PAR's (from OptiFlex), and I need to calculate the annual spend for each supply location. I do not have the department (account unit) numbers.
LisaLisa
New Member Send Private Message
Posts: 0
New Member
5/29/2015 5:51 PM
So, should I look at the REQLINE table?
LisaLisa
New Member Send Private Message
Posts: 0
New Member
6/3/2015 1:06 PM
Thank you, Mike, for the help!