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
Using the Vendor Activity report to find inactive vendors
Set up a report name - Inactive Vendors
Running a filtered Check Register and exporting to Excel should work.
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.
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.
YESSSSS! This would be incredibly helpful!
You won't be notified about changes to this idea.