web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Active Discussion

Free SQL Lookup Search for Customers, Vendors and Items

(0) ShareShare
ReportReport
Posted on by 14,127 Most Valuable Professional

If you have ever wanted to be able to search customers, vendor and items just by entering any data you know and pressing tab and getting a list of all records containing that data (case insensitive), then here is a treat for you.

I have created a free sample that adds this functionality to the main cards, inquiry and transaction windows for customers, vendors and items.

Just download and install it into your GP Power Tools - Developer Tools module install. Don't have GPPT yet, then install it and activate the free 30 day trial. It does need build 28, so if you are running on an old build, please update all your workstations.

Here is the sample: https://winthropdc.wordpress.com/2020/08/17/gppt-free-sql-search-across-multiple-fields-lookup-example/

Here is build 28 release notes: https://winthropdc.wordpress.com/2020/08/11/gppt-gp-power-tools-build-28-released/ 

Available for GP2013 or later.

Let me know if you have questions.

Enjoy

David

Categories:
  • Isaac Olson Profile Picture
    Microsoft Employee on at

    Thanks for using the discussions page to share this information.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 527 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 473

#3
Adis Profile Picture

Adis 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans