We need a single report that shows only vendors that have not been paid after a certain date. This report would be helpful in the process of discontinuing vendors. Latoya Edwards firstname.lastname@example.org Case #SC0399714
YESSSSS! This would be incredibly helpful!
We could also use this to clean up our Vendor list, we're getting ready to implement Microix and between duplicates (for different branches of companies), and other people we've paid reimbursements to over the years the active list is much longer than it should be. It would be nice to find all the Vendors we haven't used in the past (year, two years, etc) so that we can set them to inactive.
I was able to accomplish this by creating a list of active vendors and a report for vendors we paid in the past two years to include payments (by check). I dumped both reports into Excel, sorted, did a pivot table and those active vendors without zero counted checks were deactivated in MIP. That's the short version.
Running a filtered Check Register and exporting to Excel should work.
Using the Vendor Activity report to find inactive vendors
Set up a report name - Inactive Vendors
You won't be notified about changes to this idea.