Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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?