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
Advanced Member
Posts: 31
Advanced 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
    Advanced Member
    Posts: 31
    Advanced 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
      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
        Advanced Member
        Posts: 31
        Advanced Member
        5/29/2015 5:30 PM
          Ok, sure. Thanks!
          Michelle Wetzel
          Veteran Member
          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.