• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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