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, ...
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,151 Most Valuable Professional on at

    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
    4,007 on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

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

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans