Inactivating multiple vendors

Hi, our old IT person left us a while back and I don't know how she got older vendors inactivated for us.  I was under the assumption that there was some sort of utility that could be ran to inactivate any vendors not used in the past 5 years, set their status as Inactive and give an Inactive Reason.  It doesn't sound like there is such a thing, or maybe its not called anything specific so my current IT person isn't able to locate.  Does anyone out there know what I'm talking about - and know if there is an easy way to do this without going into every vendor (we have thousands) to review the history to inactivate manually?

  • 0

    Your old IT person may have used a Visual Integrator import job that would update the AP_Vendor table on the fields VendorStatus and InactiveReasonCode.

  • 0

    But how would they get the data to complete the import?  I understand that we can do an import but I'd have to compile the data for the file prior to sending to IT.  I'd be looking to figure out if there was anything in the system that would kick a report back stating either the last date used or who we haven't used in the last # of years, depending on our criteria.  

  • 0

    Have you considered reaching out to your Reseller of Record? If you are not aware of who that is, Sage Software can assist you and put you in touch with them.  What you are describing is not a "feature of the software", but certainly possible.  Write a crystal report to determine what vendors are over 5-years inactive and create a list of only those vendors.  Write a Visual Integrator Import to update the vendor master with the Inactive Setting and any reason code you associated in your crystal report (probably exported to excel for manipulation); then saved as a .csv file for importing the inactive flag. 

  • 0

    This is very helpful, thank you!  I don't personally but I bet IT does.  I'll share with them and move on from there.