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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

VBA Scripting - Next Vendor ID

(1) ShareShare
ReportReport
Posted on by 12

Ok, I know someone out there is way smarter than me and has likely already done this, but is there a way to look at the 'last' vendor ID and prompt the user with a "next vendor id"

I dont need a whole series of solutions - I just want to look at the Vendor Master, figure out the next number in the sequence and provide that to the user.

I am not a coder - never have been and really I know that there are a bunch of you out there that could do this in your sleep.

Let me know if this is a simple request - you have my Personal contacts below, connect with me off line if you like and we can discuss.

Categories:
I have the same question (0)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,069 Most Valuable Professional on at
    RE: VBA Scripting - Next Vendor ID

    Hi Bill

    I have a great sample showing how to default Vendor and Customer IDs using GP Power Tools.

    https://winthropdc.wordpress.com/2020/11/06/gppt-defaulting-customer-id-and-vendor-id-fields-for-new-records/

    VBA is end of life so alternatives should be considered

    https://winthropdc.wordpress.com/2019/08/12/gppt-replacing-vba-with-gp-power-tools-developer-tools/

    Regards

    David

  • Joseph Markovich Profile Picture
    3,976 on at
    RE: VBA Scripting - Next Vendor ID

    Hi Bill-

    Since VBA is old-school now, here is another alternative. I recommend it to everyone.

    EthoTech makes a great next numeric tool and it is for all of the major IDs in GP: customers, vendors, items, fixed assets, salespeople. Also batches too: sales, receivables, payables.

    It just adds a new button to each screen and takes the next number.

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,028

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 878 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 579 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans