We at Dynamics Innovations has developed a product for Dynamics GP allows end users to control the generation of the ID for customers, vendors and items, the tool is free and available for use immediately, just drop me a mail and I will be sending the tool for you, once you get the DLL, please follow steps below to activate the product:
1. Copy sent DLL to GP\AddIns Folder.
2. Login first time with “sa” user to generate the needed database objects.
3. Open SQL and adjust the parameters to fit your needs:
a. You need to find a table called “DI_NextNumbers”, open the table.
b. Fill the prefix you need to use, length that includes the prefix, next number you wish to use.
Go to vendor card for testing and find the additional menu, same package works for customers and items if you wish to activate: