Free SQL Lookup Search for Customers, Vendors and Items

  • Free SQL Lookup Search for Customers, Vendors and Items

    Posted by David Musgrave MVP, GPUG All Star, Community Legend on August 17, 2020 at 1:58 am
    • David Musgrave

      Member

      August 17, 2020 at 1:58 AM

      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

      #GPPT #SQL ??

      ——————————
      David Musgrave MVP, GPUG All-Star

      Managing Director
      Winthrop Development Consultants

      Perth, Western Australia

      http://www.winthropdc.com
      ——————————

    • Samantha Higdon

      Member

      August 17, 2020 at 11:31 AM

      Hi ,

      This looks so great!  My team and I are testing it out in our local installs now.  Your post on your site ?mentions providing feedback if we have thoughts, etc.  

      Do you just want that to the support email or is there somewhere specific you’d like to route feedback on this to?

      Thanks so much,

      Samantha

      ——————————
      Samantha Higdon ,CPA,CGMA
      Consultant
      Lagom, LLC
      Carmel IN
      ——————————
      ——————————————-

    • David Musgrave

      Member

      August 17, 2020 at 11:37 AM

      If you need support, you can use the support email or form on the http://WinthropDC.com website.

      I would be happy for you to provide feedback on this thread. There are already a number of the beta test sites  this code, so I know it works well.

      Regards

      David

      ——————————
      David Musgrave MVP, GPUG All-Star

      Managing Director
      Winthrop Development Consultants

      Perth, Western Australia

      http://www.winthropdc.com
      ——————————
      ——————————————-

  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Free SQL Lookup Search for Customers, Vendors and Items’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!