I am trying to figure out how to get the system to show only active vendor accounts when searching for a vendor. Is it possible set some type of filter or something so that if I am searching for a vendor, then only active vendor accounts show up and no inactive?
As example I am using Payables >> Transactions >> Transaction Entry
Click on Vendor ID Lookup, then click on VIEW -
upper left side of the vendor list, click Exclude Inactive Vendors and click on Set as Default.
I believe you have to do this for each user and will have to do so in each window that has a look up for the Vendor ID.
It is the only way I have found to do this so far.
You can bring up the vendor search pop-up window anywhere that you are asked to enter a vendor number, by clicking the button to the right of the vendor number field. There are over a dozen different search screens you can use from this pop-up. The preferred search screen is Vendor Search using General Custom Fields.myACPNY Portal
Two things might help you with this.
There is an add-on product that's free from EthoTech called SmartSort. It lets you filter the lookups on an organization-level (or user, user class, etc).
This will override the default functionality of the lookups and not require the users to always change it.
If you'd want to do a Google- or Bing-style search in ALL of the lookups in GP, Rockton Software makes a product called SmartFill. You can create custom searches for all of the lookup fields and also search on more than just ID or description -- any field can be a search field.
They are both really awesome.
I hope this helps.
Joe
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,100
André Arnaud de Cal... 890 Super User 2025 Season 2
Sohaib Cheema 633 User Group Leader
