Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

S3 Vendor Supply Spend report

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Z
New Member
Posts: 2
New Member
6/28/2010 1:28 PM
    Hi,

    Do you know the report name to generate my Supply spend by vendor?
    We do not track Freight spend.

    Thanks in advance,
    Tags: vendor, Reports, supply spend
    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
    6/28/2010 7:42 PM
      We created our own report since there is no report in Lawson that resolves this. The tables we used were Purchorder, poline and mmdist and other tables that store description.
      Tags: vendor, Reports, supply spend
      Z
      New Member
      Posts: 2
      New Member
      6/30/2010 10:19 AM
        Thank you for your response Ruma,

        I am new working with this system, Do you have by any chance the name of the other tables that store description ?

        Thanks in advance,
        Tags: vendor, Reports, supply spend
        Nick
        Veteran Member
        Posts: 50
        Veteran Member
        6/30/2010 8:15 PM
          The one I would make sure to include would be APVENMAST which is the Vender Master table so you can pull in the Vendor name and such. When I ran reports like supply spend, I would also sometimes include the POVAGRMTHD and POVAGRMTLN tables for PO Agreements, and the ITEMMAST table for Lawson defined Item information. The POITEMVEN table might be helpful if you need any of the PO Venodr Item information.

          Nick
          Tags: vendor, Reports, supply spend