S3 Vendor Supply Spend report

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.

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,

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