Announcements
No record found.
Once a vendor has been inactivated, what does that affect? Will we still have the ability to reactivate or look at the vendor history?
*This post is locked for comments
Have a look on the below information from GP help file.
Inactive Vendors:
An inactive vendor is a person or company you don't do business with anymore; typically these are vendors whose records you can't delete because historical information is kept for them.
Making a vendor inactive isn't the same thing as placing a vendor on hold. You might find it helpful to think of inactivating a vendor record as a permanent change that reflects you no longer do business together, while placing a vendor on hold usually is a temporary change to the vendor's status. If you inactivate a vendor record, you can’t enter transactions of any kind for the vendor. If you place the vendor on hold, you can’t make payments to the vendor but you still can apply vouchers and post transactions for the vendor.
Hope this helps!!!
so just to confirm, once a vendor has been inactivated they cannot be reactivated correct?
No, You can inactive a vendor and just get it back active. Although, as long as it is inactive, no transactions can be entered.
I do consider the difference is a bit from a business perspective, either vendors that I don't want to work with anymore, or another vendor that I am still suspect about.
You can re-activate a vendor who is inactive. You can view the transaction history of an inactive vendor.
There are two differences between inactivating a vendor and placing one on hold:
First, invoices and credit memos can still be entered while a vendor is on hold. Checks or payments cannot be made to a vendor on hold. You cannot enter any transaction while the vendor is inactive.
Second, A vendor can be placed on hold that has a balance in payables. A vendor cannot be inactivated if they have a balance or any transactions to be posted.
Yes. I agree with above suggestions.
Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.
Is their anyway to inactivate a large number of vendors with whom there has been no activity for many years?
No. First you need to find out the those vendors whom has been no activity for many years and inactivate those vendors from backup(if you have more vendors). Otherwise you need to create a macro to inactivate those vendors.
I would say it is difficult and not recommended but it is possible to inactivate vendors using SQL. I have had to do it twice. I looped through the vendor list counting the activity in the tables PM30200, PM30300, PM30600, PM80200, PM80300, PM80500 and PM80600 to determine which vendors to tag as inactive.
Keith McConnell
Keith, I agree it is very difficult, but I might suggest that you could use the SQL side to generate your list of vendors to 'evaluate' for setting them to inactive.
Once you have this done, you might consider a macro to run over a large number of vendors.
It is one button push only, but, at least then you are not sitting there typing names, and clicking button and moving on.
If it were early in the summer I might have suggested a good posting for a TEMP student, allow them some 'real world, accounting, technology, IT Support work' - not really kidding - but it sounds funny to say it that way.
Hope this helps, or helps you make a decision.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Shravan Attelli 1
