Table of Contents
Introduction
About This Book
Foolish Assumptions
How This Book Is Organized
Part I: NetSuite Basics
Part II: Tracking Money and Resources
Part III: Marketing and Driving Sales
Part IV: Taking Care of Your Partners and Customers
Part V: Selling Online
Part VI: Dashboards, Searches, and Analytics
Part VII: The Part of Tens
Bonus Chapters on the Companion Web Site
Icons Used in This Book
Where to Go from Here
Part I: NetSuite Basics
Chapter 1: Peeking Under the NetSuite Hood
Speaking NetSuite Lingo
Naming Your Most Important Data
Entity
Items
Transactions
Leading to Profits
Marketing
Sales
Web store/e-commerce
Fulfillment and project tracking
Leveraging Key Data to Make Excellent Decisions
Dashboards
Lists and saved searches
Reporting and analytics
Going Global with NetSuite OneWorld
OneWorld abilities
OneWorld features
Chapter 2: Tailoring NetSuite to Your Company
Starting with the Basics
Customizing from the Get Go: Setting Up NetSuite
Company Information
Enable Features
Rename Records and Transactions
Auto-Generated Numbers
General Preferences
Printing, Fax, and E-mail Preferences
Getting picky about Set Preferences
Customizing Fields, Records, Forms, and Lists
Fields
Records
Forms
Lists
Bringing in Data
Saving an Excel spreadsheet as a CSV file
Thinking about data import
Using the CSV Import Assistant
Custom Programming with SuiteScript
Chapter 3: Personalizing Your Suite
Getting into NetSuite
Mother, may I?
Logging in to NetSuite
Who am I?
Keeping Tabs and Checking Your Dashboard
Tabs
The Home dashboard and overviews
Show Me the Records
Creating new records
Accessing information in records
Locating records using lists
Saving Searches (and Time)
Going Global Search
Auto suggest
Using prefixes to search
Using a wildcard in numeric searches
Editing global search results
Clocking in on the Calendar
Setting up calendar preferences
Scheduling events
Attaching events to records
Chapter 4: Grabbing Hold of the Dashboard
Being Privy to Different Portlets
Adding, Subtracting, and Moving Portlets
Adding and removing portlets
Positioning portlets
Customizing Portlets
Comparing between dates
Flagging metrics that meet a threshold
Display custom RSS feeds
Create shortcuts
Part II: Tracking Money and Resources
Chapter 5: Bookkeeping Basics
Managing Your Chart of Accounts
Creating and editing accounts
Examining account registers
Assigning account numbers
Running a general ledger report
Debits, Credits, and Journal Entries
Seeing the debits and credits
Creating a new general journal entry
Using Accounting Periods
Banking on It
Making a deposit
Transferring money between accounts
Writing a check
Printing checks
Putting it on plastic: Credit cards
Exploring bank and credit card registers
Reconciling accounts
Chapter 6: Invoicing Customers and Paying the Bills
Getting What’s Coming to You: Accounts Receivable
Creating invoices and cash sales
Assessing finance charges
Recording a customer payment
Applying customer deposits
Applying customer credits
Knowing what they owe you
Sending a statement of account
Sending collections letters
Paying the Piper: Accounts Payable
Recording vendor bills
Paying your bills
Applying vendor credits
Keeping track of your obligations
Sending and receiving electronic payments
Setting up payment terms
Chapter 7: Managing Inventory
Understanding Item Types
Goods and services bought and sold
Creating subtypes
Grouping items
Utility drawer-type item types
Creating Item Records
Entering basic item information
Creating new items
Assigning item pricing
Creating and Managing Inventory Items
Staying on ledger accounts
Keeping stock information
Assigning costing methods
Setting default accounting
Setting and adjusting inventory levels
Creating a standard inventory adjustment
Creating an inventory adjustment worksheet
Making items available in the Web store
Managing multi-location inventory
Designating preferred vendors
Buying Inventory
Using purchase orders to receive inventory
Replenishing inventory and calculating demand
Selling Inventory
Enabling advanced shipping
Managing committed items and back orders with sales orders
Reporting on Your Inventory
Using Advanced Inventory Features
Part III: Marketing and Driving Sales
Chapter 8: Building a Campaign: Marketing Automation
Selling You on Marketing Campaigns
Setting up a campaign domain
Creating a new campaign
Putting your eye on the target
Creating campaign marketing templates
Planning events: Setting up e-mail, direct mail, ads, and more
Keyword Marketing
Tracking keywords
Creating keyword campaigns in bulk
Importing keywords from a CSV file
Viewing keyword reports
Tracking Marketing Results
Reviewing campaign responses
Measuring campaign ROI
Chapter 9 : Setting Up Sales Force Automation
Turning On Sales Force Automation
Stages and Statuses: Closing In
Creating Online Forms
Setting up form workflow
Setting up form looks
Linking up
Getting an example HTML template
Assigning Leads to Sales Reps
Creating sales rules and territories
Creating sales territory
Reassigning existing leads, prospects, or customers
Managing Quotas and Forecasts
Establishing quotas
Managing the forecast
Show Me the Money: Commissions
Enabling commissions
Creating commission schedules
Creating and assigning commission plans
Cutting the check
Chapter 10: Turning Leads into Customers
Capturing the Elusive Lead
Coming your way
Creating a lead record
Going On Record about Opportunities
Recording opportunities
Forecasting opportunities
Creating Quotes from Opportunities
Creating a quote from an opportunity
Managing multiple quotes
Entering a Sales Order
Lead Conversion for B2B
Enabling lead conversion
Rocking the Customer Record
Contacts, activities, notes, and e-mail on records
Opportunities and transactions on records
Customer dashboard
Part IV: Taking Care of Your Partners and Customers
Chapter 11: Delivering the Goods: Fulfillment and Shipping
Feeling Fulfilled: Orders
Getting started
Preferences you should know about
Advanced versus nonadvanced shipping
Your lucky ticket
Fulfilling orders
Picked, packed, and shipped
Flipping about Shipping Orders
Shipping basics
Other shipping stuff
Chapter 12: Managing Projects
Priming Yourself for Project Management: Time and Billing
Adding resources
Estimating time and costs
Managing Service-Oriented Tasks
Tracking basic tasks
Handling activities
Enabling Project Features
Setting Up Basic Projects
Working with Advanced Projects
Enabling advanced projects
Allocating resources (aka people)
Setting Up Advanced Projects
Creating a new project
Adding a task
Entering time
Chapter 13: Providing Excellent Customer Service
Setting Up Case Routing and Notification
Creating case rules and territories
Setting up notifications for support reps and customers
Allowing Customers to Submit Cases Online
Accepting cases through the Customer Center
Accepting cases through your Web site
Accepting cases by e-mail
Getting a Handle on Customer Inquiries
Creating a case
Managing the case queue
Escalating cases
Part V: Selling Online
Chapter 14: Planning Your Web Site
Surfing NetSuite Site Options
NetSuite sites
Hosted sites
Combination sites
External catalog sites with the WSDK
Spinning Multiple Web Sites
Setting Up Your Web Address
Mastering your domain
Setting up your domain name in NetSuite
Setting your primary site URL
Chapter 15: Adding Content to Your Site
Knowing a Site from a Store in the Ground
Attempting to Organize
Content Manager
Keeping tabs on things
Conquering with categories
Debuting Items
Store name and description
Pricing it right online
Associating related items
Featured or on-sale items
Being the Town Crier: Publishing Information
Getting Results with Site Search
Enabling Advanced Web Search
Creating a search form
Publishing a search form
Setting your search preferences
Publishing search results
Chapter 16: Making Your Site Look Great
Looking Good
Styling your site with themes
Showing your colors
Laying Out Your Space
Using Advanced Site Customization Options
Marching to the beat of your own theme
Applying a style sheet
Creating a custom site theme
Item/category templates
Apply yourself
Customizing text
Chapter 17: Let the Shopping Begin
Getting to Know Your Customers via Registration
New customer? Please register! Or not
Paying the Piper
Credit and debit card processing
Paying later by invoice
Shaping Up, Shipping Out
Creating shipping items
Setting the default shipping method
Default Web site shipping address options
Restricting countries you ship to
Adding shipping cost to the shopping cart portlet
Taking Orders
Crediting sales reps for Web orders
Requiring a minimum order
Legal jargon: Terms and conditions
Giving Customers Access
Chapter 18: Fine-Tuning Your Site
Optimizing for Search Engines
Letting NetSuite handle things
Taking some initiative
Creating your doctype
Feeding the hungry customer
Describing descriptive URLs
Redirecting: The 411 on 301s
Navigating sitemaps
Using Reports to Improve Your Site
Basic reports
Site analytics reports
Part VI: Dashboards, Searches, and Analytics
Chapter 19: Realizing the Power of Saved Searches
Revving Up for a Saved Search
Defining a Saved Search
Setting general search options
Limiting viewers
Developing search criteria
Choosing the results to display
Advancing Your Searches
Summarizing data
Using available search filters
Calculating formulas
Refining a search with And/Or expressions
Highlighting data in search results
Being Generous with Your Saved Searches
Making searches public
Defining an audience
Ways to use saved searches
Chapter 20: Exposing Metrics on Your Dashboard
Harnessing the Power of Key Performance Indicators
When to use a KPI
Adding the Key Performance Indicators portlet
Viewing your KPI data
Drilling down to the details
Measuring Performance Using KPI Meters
Special KPI Meters
Adding a KPI Meter portlet to your dashboard
Setting up your KPI Meter
Monitoring Activity Through Trend Graphs
Setting up pop-up trend graphs
Displaying a pop-up trend graph
Adding a Trend Graph portlet to your dashboard
Setting up a Trend Graph portlet
Taking a tour of a trend graph
Exporting data from a Trend Graph
Grading Your Business with KPI Scorecards
Enabling the KPI Scorecards feature
Adding a KPI Scorecard portlet to your dashboard
Creating a KPI Scorecard
Setting up a KPI Scorecard
Using formulas in a KPI Scorecard
Building Custom KPIs
Adding a Custom KPI to a KPI portlet
Displaying a Custom KPI in a Trend Graph portlet
Showing a Custom KPI in a KPI Scorecard
Seeing Your Business Through Report Snapshots
Adding a Report Snapshot portlet to the dashboard
Setting up a Report Snapshot portlet
Chapter 21: Reporting and Analytics
Getting Started with Reports
Setting preferences for reports
Report types
Finding and Accessing Reports
Running Reports
Summary and detail reports
Expanding or collapsing data
Navigating through a report
Footer filters
Finding records
Setting results options
Selecting output options
Starting a New Report
Customizing an Existing Report
Editing columns
Adding a formula column to a report
Filtering data
Sorting records
Setting additional options
Using the Financial Report Builder
Accessing the Financial Report Builder
Editing a financial report
Part VII: The Part of Tens
Chapter 22: Ten-Plus Key Differentiators
Full-Circle Order Processing
Your Web Site and Your Back Office: Together at Last
Make NetSuite Suit You
Data and Analytics, Delivered
Bring Me Your Tired, Your Weary, Your Data
Rolling Up Is Just as Fast as Rolling Down
Hey, What’s That?
Get Me Where I Need to Go — Now
In the Cloud, but Locked Down
Roles and Permissions
Don’t Just Sell Products — Sell Projects!
Work-Life Balance
Chapter 23: Ten Tips for a Successful Implementation
Consider Investing in Hired Help
Know Your Requirements
Be Open Minded
Heed Advice
Get What You Pay For
Remember That Time Is on Your Side
Know the Possibilities
Keep Your Training Wheels On
Keep It Simple
Take Baby Steps
Chapter 24: Ten Frequently Asked Questions
How do I log in?
How can I add something to my shortcuts?
How can I e-mail an invoice to someone who isn’t the main contact?
How can I add something to my dashboard?
Why don’t I see that field/screen/option?
How can I send marketing e-mail that isn’t marked as spam?
Why are there repeated lines in my search results?
How can I open a new window while keeping the same session?
How can I get an audit trail?
How can I control which fields and columns print on a form?
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books.
This book could not have been written without the team effort of a number of wonderful people. We would like to thank Graham Walker for knocking on Wiley’s door; Brian Taylor, who provided his expertise on customization; Chris Blum, for his superior knowledge of NetSuite security; and Sean Kennedy, for lending his understanding of projects and services. John Browne and Elham Ghassemzadeh offered their insight and input on SuiteFlex. Jason Flanagan, Cynthia Sloan, Kate Rodrigues, Tracy Adkins, and Sabina Letang from the NetSuite Technical Publications team contributed content and reviewed material. Deb Cameron, Dan Woods, and their team at Evolved Media helped us finish up and round out the content when the going got tough. Valerie Steele pushed this project through to completion, and Evan Goldberg’s sponsorship and thorough review of this book was an invaluable asset. Finally, we would like to thank our NetSuite customers, who clamored for this book and provided the spark that made it happen.
—J.K.
—L.B.
—M.H.
We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
Introduction
This book provides a friendly introduction to NetSuite. If you’ve picked up this book, chances are you already know something about the product, but here’s a quick summary: NetSuite is the number one, Web-based business software suite available as of early 2010. NetSuite offers an integrated application that wraps all the essential information technology needs — ERP, CRM, HR, customer service, ecommerce, warehouse and inventory management, and project management — into one tidy application.
Why should you consider NetSuite? Chances are you’re drawn to some of the benefits commonly enjoyed by NetSuite customers:
Reduced IT costs
End-to-end integration of information systems into one comprehensive platform
Ability to redeploy budgets and personnel to more strategic parts of the business
Flexibility to add new business partners and divisions anywhere in the world and allow employees to work remotely
Real-time operational intelligence, easily personalized to individual users who can customize their own pages and reports with minimal training and without IT staff
The expertise of a vendor who takes care of upgrades and maintenance and can provide iron-clad security to protect essential customer and business data
NetSuite is part of the larger trend of Software as a Service (SaaS). In the SaaS model, users no longer have to buy on-premise software like ERP packages. Nor do they have to host their own servers in those all-too-familiar air-conditioned, glassed-in computer rooms. Instead, they can simply purchase a subscription to a software service and access it online. They don’t have to maintain their own server rooms, pay huge up-front infrastructure costs, or worry about upgrades. A SaaS customer only needs some computers and an Internet connection. In short, the IT burden shifts from customer to vendor.The SaaS model is growing increasingly popular. One recent study by the research and intelligence firm IDC predicted that nearly 45 percent of U.S. firms will devote at least a quarter of their IT budgets to SaaS applications by 2010. This percentage has doubled in only two years and is projected to accelerate even more. Many companies are migrating to SaaS because this model allows them to pay as they go, buy only what they need, easily scale up or down based on current business needs, and outsource their computing needs to experts. Often, they can reap substantial savings, especially in infrastructure costs.NetSuite is flexible enough to meet the needs of many types of companies. Small businesses can use NetSuite to replace QuickBooks or Peachtree. Large multinational businesses can use NetSuite to replace on-premise ERP systems from vendors like Oracle or SAP and have one system that rolls up data from subsidiaries, automatically converts currency, and calculates local taxes.Throughout this book, you see how NetSuite can be customized to be:
Adaptable: You can adjust your account to fit your habits of doing business. You can customize your business records, forms, and fields — or create new ones from scratch. You also can fine-tune your business flows to harmonize with your company’s operations.
Easy to use: NetSuite emphasizes “click, not code” and drag-and-drop customization. Business employees can easily create their own reports and dashboards — no programmers or analysts required.
Personalized to individual users: NetSuite lets users customize their own dashboard, reminders, and pages.
Durable: All customizations are carried forward during upgrades. Unlike some on-premise enterprise packages, you don’t have to junk or overhaul all your existing customizations.
Verticalized: You can share your customizations with partners. You can reproduce templates and share them with business partners. NetSuite account cloning allows replication and instant access to your specific solution . . . and further customization by partners.
About This Book
This book provides both a comprehensive overview of NetSuite and, in some sections, detailed instructions on specific topics.
NetSuite offers extensive online help. But because the system is so comprehensive, the Help section is necessarily voluminous as well. This book seeks to provide a more succinct, and sometimes lighthearted, summary of NetSuite and share a few tricks and tips along the way. This book takes a layperson’s approach. We’ve tried to make this book accessible and provide examples, not just bore you with dry technical jargon and code. After reading this book, you should have a better handle on how the system works and its unique capabilities, and you will be able to reap more from the NetSuite user guides and help materials.
Custom forms can change your ability to follow the instructions given in this book. The good news is that the help is dynamic, so it tells you how to get to stuff.
This book is suitable for different types of people:
Maybe you’re just thinking about becoming a NetSuite customer. Perhaps your company currently has an on-premise ERP system, but you’ve grown tired of maintaining this system, paying for expensive upgrades, maintenance, and patches, and hosting your own servers. Maybe you’re enticed by the promise of cloud computing, which allows you to outsource your computing needs so you can focus your energies on the core products or services that actually distinguish your business. Or maybe you use other cloud-based software (we politely won’t mention any names) but are drawn to NetSuite because it lets you do everything in one comprehensive package instead of cobbling together solutions from multiple vendors.
Maybe you have a NetSuite test account. Even if you’ve started playing with a demo account, this book will give you more ideas and new tricks and help you make a more informed decision.
Maybe you’re an existing NetSuite customer who wants to extend your company’s use of the product. In this book, you find sections on the important facets of NetSuite, including those you may not fully understand or haven’t even tried. Even if you already use NetSuite, this book will help you wring greater value from your IT investment.We wrote this book to be accessible to many levels of people, from technophobes with English degrees to eggheads who dream in code. We hope this guide can be passed around and become the most dog-eared book in your business. Actually, we hope you buy a copy for everybody in your company.
Foolish Assumptions
When writing this book we made a few assumptions. If you fit these assumptions, this book is for you:
You either use NetSuite or you’re thinking about using it.
You have some background in common business terms like profit and loss and common accounting terms such as general ledger and purchase order. What you don’t need is the ability to speak fluent accounting (though we’re happy to point out the accounting implications in debit and credit speak at relevant points along the way).
How This Book Is Organized
This book is organized by topics. Everybody should read, or at least skim, Part I, which covers the basics of NetSuite. The rest of the book delves in to more specific topics that may or may not interest you.
You shouldn’t feel compelled to read this book in the exact order in which the chapters are numbered. For Dummies books are so chapters can stand alone. Skip around, read the chapters relevant to you, and skim or ignore the rest. For example, if you don’t ship physical product, you don’t need to waste time reading the shipping and fulfillment chapters. Similarly, if you’re certain you will never, ever — so help you God — try your hand at coding, you can probably skip the sections on scripting.
Part I: NetSuite Basics
You need a solid foundation in the fundamentals of NetSuite to understand how it can help your company. Part I covers basics such as setup, customization, forms and records, terminology, and personalizing your screens, portlets, and dashboards.
Part II: Tracking Money and Resources
We’re going out on a limb and assuming your company handles money. Part II shows you how NetSuite can help you track the moola. This section explores bookkeeping, accounting, invoicing, paying bills, and managing inventory.
Part III: Marketing and Driving Sales
This section explores how to attract potential customers. Read this part to know how NetSuite serves as an engine for marketing as well as helping you establish a disciplined and well-organized sales team. This section shows how you can use NetSuite for sales force automation and developing leads into satisfied customers.
Part IV: Taking Care of Your Partners and Customers
Sales comes to its logical conclusion with fulfillment and shipping (if you sell physical products) and project management (if you deliver services). Partners also often play a role with customers, so this section describes partners as well as how NetSuite can help you provide excellent customer care and help customers help themselves.
Part V: Selling Online
NetSuite can help you set up and host your virtual storefront. This section explains the basics of planning your Web site; creating content; making your pages look sharp; taking online orders; and fine-tuning.
Part VI: Dashboards, Searches, and Analytics
One of the most powerful aspects of NetSuite is its ability to produce real-time business intelligence, from simple at-a-glance dashboards to comprehensive reports that roll up whatever data you desire. This section introduces you to analytics features such as saved searches, key performance indicators for your dashboard, and reporting.
Part VII: The Part of Tens
No For Dummies book would be complete without The Part of Tens. In this section, we distill the wisdom of this book into lists of take-home essentials. You find lists of key differentiators, keys for successful implementation, and frequently asked questions.
Bonus Chapters on the Companion Web Site
Meeting the specific needs of your business requires that NetSuite be flexible, extensible, and secure. This book’s companion Web site, at www.dummies.com/go/netsuitefd, provides seven jam-packed chapters that address topics ranging from partner relationships (and how to manage them best) to SuiteScript (a JavaScript-based API that extends NetSuite with programming). Other bonus content includes field, tab, and table customization; checkout options; knowledge base setup; and security.
Icons Used in This Book
To help you get the most out of this book, we use icons that tell you, at a glance, if a paragraph has important information of a particular kind.
Look out! This is something tricky or unusual or risky to watch for.
This icon marks important NetSuite stuff you should file away in your brain, so don’t forget it.
There’s more to know about the topics associated with this icon. Check out the book’s companion Web site at www.dummies.com/go/netsuitefd.
When you see this icon, you know we’re offering advice or shortcuts to quickly improve your understanding of NetSuite and teach you the tricks of the trade.
This icon indicates information that’s more technical in nature, and not strictly necessary to read. If technical jargon gives you a headache, feel free to skip these.
Where to Go from Here
Start by reading Part I. Then ask yourself how you may use NetSuite and read the relevant sections.
If you’re completely new to NetSuite, head straight to Chapter 1, which will give you an overview of the platform.
If you’re a professional in a particular area — such as accounting, sales, marketing, or warehouse management — you can decide to visit chapters in no particular order. But (and we’re probably biased) we think the best way forward is by reading Part I. After that, feel free to jump straight to the chapters that call your (professional) name.
Please note that some special symbols used in this eBook may not display properly on all eReader devices. If you have trouble determining any symbol, please call Wiley Product Technical Support at 800-762-2974. Outside of the United States, please call 317-572-3993. You can also contact Wiley Product Technical Support at www.wiley.com/techsupport.