S3 Vendor Supply Spend report

Sort:
You are not authorized to post a reply.
Author
Messages
Z
New Member
Posts: 2
New Member
    Hi,

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

    Thanks in advance,
    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
      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.
      Z
      New Member
      Posts: 2
      New Member
        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,
        Nick
        Veteran Member
        Posts: 50
        Veteran Member
          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
          You are not authorized to post a reply.