AP Vendor Activity

I'm new to financials so I'm not sure what table to refer to, to complete this report. I've been asked to create a report that shows those vendors that haven't had activity in 3 years. Is there a standard report that would show this information? If not, what table(s) would I use to create it.

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Comments

unknown

There is a vendor list AP210

Infor HRCM - Product Lifecycle Policy Overview Webinar August 11 2.pdf

susan-kirkbride

I typically use AP270 and enter the date range in the Payment Dates. Then I match the results of that up to our full vendor master to filter out the ones that haven't had activity. We also compare to PO History if we're considering inactivating/removing a vendor. It's possible to have a PO out there for a vendor but the vendor was never paid through AP.

Jim Norbut

I've used APVENBAL for this before.....there's a field for LAST_PMT_DATE and LAST_PURCH_DATE.
always seemed to do the trick.....for what I needed at the time. Just my 2 cents.

unknown

The APVENTMAST table will contain all of your main vendor information and the APINVOICE with contain all the invoice info. You can even join these tables with say an Access query so you can pull in the necessary information you are looking for. APPAYMENT would provide the check or ACH information, void dates, etc. if that is ever needed.

Copyright © 2025 Infor. All rights reserved.