Tables needed to find top suppliers

POLINE for the vendor PO activity PURCHORDER to limit results by PO date range MAINVDTL if you want what was paid vs. the cost that was entered on the PO line.  I use this formula for unit cost

IF {MAINVDTL.MATCH_UNIT_CST} = 0 THEN {POLINE.ENT_UNIT_CST} ELSE {MAINVDTL.MATCH_UNIT_CST}

APVENMAST to pull in the vendor name

Bev - Do you only want suppliers for which a PO was generated? We have some vendors with spend but PO's are not issued to them, & our managers sometimes want to see that spend, so we have reporting to accomodate both. We use APPAYMENT & APVENMAST to capture any Lawson vendor, & we exclude certain AP10 vendor classes to keep the results as true as possible. For our reporting where only vendors with PO's issued are included, we use PURCHORDER, POLINE, MAINVDTL, POVAGRMTHD, APINVOICE & APVENMAST. We use MAINVDTL.DISTRIB_DATE for our date ranges - this allows us to see both PO & Invoice data. Hope this helps!

APPAYMENT will work for all spend if you don't need to differentiate between capital, service and supply spend. But you could just run AP270 in summary for that. I also add MMDIST to filter out non-supply related expenses.

Jon - How do you link APPAYMENT to MMDIST?

If you're going to use APPAYMENT, that table doesn't have any PO related fields so I would link APDISTRIB to determine the account.

Thank you so much! Your help is greatly appreciated! Bev