Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Categorized Customer Account Numbers?
Can anyone help with this?
I'm trying to create stratified customer account numbers based off of: customer category, a customer 'brand' list (where applicable), and sequence. Anyone have any recommendations on the best way to do this? I’ve never written a script, but have messed around some in SQL. We want to use six digit account numbers in the following format.
# ### ##
Category Brand Sequence
Example:
Category #
Corporate 7
Government 3
Consumer 5
Brand ###
Taco Bell 142
Nike 593
Walmart 110
So for our 15th Taco Bell store, we would want:
714215
(7 for corporate, 142 for Taco Bell, 15 for sequence)
Even with what little I know of SQL, I can get everything except the sequence value, since I need to find that customer’s sequence within the same category and brand (where applicable). Also, if this can be done through scripting, could I have it create an external ID?