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.
Intelligent Payment Automation, powered by BILL (aka Bill.com), lets you automate payments, manage vendor details, and bank account information within NetSuite.
The SuiteApp is available to organizations based in the U.S. with a valid U.S. address, or to global customers (except Canada, China, and Japan) with U.S. business subsidiaries. It only supports payments to vendors operating in the United States.
For more information, visit this thread.
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?