Open Forum

Expand all | Collapse all

Auto Generate Customer ID

  • 1.  Auto Generate Customer ID

    Posted Oct 02, 2019 07:24 PM
    When creating a new customer is there a way to have GP auto generate the Customer ID number?  We want the system to issue sequential numbers as new customers are added.

    Barbara Rodriguez
    Accounts Payable Specialist
    TSW Alloy Wheels
    Brea, CA

  • 2.  RE: Auto Generate Customer ID

    Posted Oct 03, 2019 01:03 AM
    Hi @Barbara Rodriguez

    This functionality requires some custom code.

    You should look at Willoware's solution: ​

    Also if you already have GP Power Tools - Developer Tools module registered, this functionality can be easily written with a single trigger script.



    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia


  • 3.  RE: Auto Generate Customer ID

    Posted Oct 03, 2019 09:16 AM
    Hi @Barbara Rodriguez - We have been using Ethotech's Next Numeric product for this for over two years. It's very easy to set up and use and you can use it to generate sequential numbers for customers, vendors, items, batches, etc. and each master record type can have it's own starting number. Here's a screenshot of the 'hotkey setup' window that shows all the different types it can be used with. We only use it for Customers, and we simply type CTRL+N in the customer maintenance window to generate the next sequential customer number.
    EthoSeries Hotkey Setp

    Hope this helps!

    Jeff Pfershy
    Sr Business Analyst
    BluJay Solutions Inc
    Holland MI


  • 4.  RE: Auto Generate Customer ID

    Posted Oct 03, 2019 12:57 PM
    Hi @Barbara Rodriguez

    Good suggestions thus far. NextID is another option that creates the customer number based on your predefined preference.

    Brandon Mayer
    Director of Sales & Marketing
    Implementation Specialists (IS)
    Hawley MN


If you've found this thread useful, dive deeper into User Group community content by role