Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
NetSuite ERP for Administrators
NetSuite ERP for Administrators

NetSuite ERP for Administrators: Learn how to install, maintain, and secure a NetSuite implementation, using the best tools and techniques

eBook
€19.99 €28.99
Paperback
€35.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
Table of content icon View table of contents Preview book icon Preview Book

NetSuite ERP for Administrators

The Value Proposition – Doing More with Less

Modern business is complex. There are many suppliers and even more customers transacting with our employees every day. It's difficult to collate all that information because it involves sales, fulfillment, billing, and collections, as well as ordering products to sell in quantities that keep stock at their optimal levels. In addition, an accountant requires that copies of all transactions be kept to create income statement and balance sheet.

You may ask how ERP and NetSuite, in particular, can help in running a business. In this chapter, we will focus on the value of ERP as well as the NetSuite value proposition, namely that the whole is greater than the sum of its parts.

Value of ERP 

Enterprise Resource Planning (ERP). The objectives of ERP are to make operations more efficient while simultaneously building financial statements, ordering from suppliers at the right time to optimize the quantity kept in the inventory, selling and fulfilling the products, processing payments efficiently, and initiating the next step in a process, without the need for human intervention. It also enables employees to communicate without having to speak to each other, thereby optimizing customer communications and reducing internal effort by allowing customer self-service while simultaneously capturing the journal entries necessary to accurately reflect the state of the business from an accounting perspective, and to create actionable business intelligence.

Yogi Berra once quipped, "if you don't know where you are going, you'll end up someplace else", which is why we start by exploring the benefits of ERP in this chapter. ERP crosses different departments in the company, requiring the administrator to take a holistic view because a process in one department has knock-on effects on processes in other departments. This also illustrates the impact a good administrator can have on the health of the company.

But that sounds more of an MBA book full of, "low hanging fruitwith soup to nuts, where the rubber meets the road" and not a book on software, so let's illustrate the value of ERP using a use case of a mobile phone reseller.

The analysis will use this paradigm—each step in the buying and selling process will be categorized as either a transaction,  a list of reusable information, a customization, and/or as having a financial impact. Doing so will not only teach us about ERP but also about the steps we as administrators will need to take to keep the process running smoothly.

The process starts by ordering five iPhones from Apple. The phones are ordered from a supplier using a purchase order that records the quantity and cost of the items being ordered:

Purchase order

This will be the first of many iPhones that will be ordered, so we should probably set the iPhone up as a reusable list with the name, the cost, and all the characteristics of the product. It will also be the first of many orders sent to Apple, so Apple should also be set up in our reusable list of vendors with their details, such as phone numbers, email address, and physical address:

Vendor Record

The transaction is entered into our system for historical purposes, as well as to alert the warehouse to expect to receive the iPhones; a copy of the transaction also needs to be sent to the vendor. Apple will not accept a screenshot of our system and requires a professional looking purchase order form before they will recognize this as a valid order. We will, therefore, need to customize the internal purchase order form as well as the external purchase order form:

Purchase order to be sent to the vendor

The categories from this one transaction will look like this:

Category

Activity

Transactions

Purchase order

Lists

Item: iPhone

Vendor: Apple

Customization

Purchase order internal form; Purchase order external form

Accounting impact

 

When UPS delivers that inventory, the warehouse manager enters the receipt of the iPhones. To summarize, the Transactions category is updated with the Item Receipt and the Accounting Impact is that our inventory increases by $5,000:

Category

Activity

Transactions

Purchase order

Receipt

Lists

Item: iPhone

Vendor: Apple

Customization

Purchase order internal form; Purchase order external form

Accounting impact

Inventory: +$5,000

 

The vendor attaches an invoice to the shipment and the accountant needs to enter this transaction to reflect the indebtedness. The accountant bills the purchase order (PO), which creates the Accounting Impacts of adding the $5,000 to accounts payable (AP):

Category

Activity

Transactions

Purchase order

Receipt

Bill PO

Lists

Item: iPhone

Vendor: Apple

Customization

Purchase order internal form; Purchase order external form

Accounting impact

Inventory: +$5,000

AP: +$5,000

 

Once Apple is paid using a Pay Bills Transaction, the debt is extinguished. In other words, the accounts payable entry is reversed and the bank account is decreased by $5,000:

Category

Activity

Transactions

Purchase order

Receipt

Bill PO

Pay Bill

Lists

Item: iPhone

Vendor: Apple

Customization

Purchase order internal form; Purchase order external form

Accounting impact

Inventory: +$5,000

AP: +$5,000 - $5,000 = $0

Bank: -$5,000

At the end of the process,  the company is left an additional $5,000 in inventory and the bank account has decreased by $5,000.

As administrators, we can see that the reusable lists of item and vendor can make entering purchase orders more efficient in the future because, once selected, all the information about the item and vendor is automatically sourced into the purchase order. We can also start compiling our task list, as it seems we will need to customize the internal purchase order form and the external form that was sent to the vendor. Now, to relate that to NetSuite specifically, you will see that NetSuite has Transactions, Lists, and Customization menus, where you will find each of these records under that category. Furthermore, there is a link to the GL Impact on each transaction, which displays the Accounting Impact of that transaction:

GL Impact

On the sales side, the starting point is a sales order that contains the item (iPhone) and the customer. The item was already created when we used it in the purchase order, so we can simply reuse it. The customer will, however, need to be created but can be reused in future transactions. It may require a customization of the sales order form, as well as the external form that needs to be given to the customer:

Category

Activity

Transactions

Sales order

List

Item: iPhone

Customer: Brad Pitt

Customization

Sales order internal form; Sales order external form

Accounting impact

 

The order is then sent to the warehouse for fulfillment. The iPhone is picked from the warehouse, packed into a box, and shipped to the customer, requiring a pick ticket, packing slip, and shipping label. Shipping the order results in one less iPhone available in the inventory, so it decreases the inventory by $1,000:

Category

Activity

Transactions

Sales order

Fulfillment

List

Item: iPhone

Customer: Brad Pitt

Customization

Sales order internal form; Sales order external form

Pick ticket, packing slip, shipping label

Accounting impact

Inventory: -$1,000

 

The accountant will invoice the customer as soon as the item ships, which requires an internal invoice form as well as an external professional looking invoice that is sent to the customer. It also results in an accounting impact on the accounts receivable (AR) in the amount of the sales price:

Category

Activity

Transactions

Sales order

Fulfillment

Invoice

List

Item: iPhone

Customer: Brad Pitt

Customization

Sales order internal form; Sales order external form

Pick ticket, packing slip, shipping label

Invoice internal form, invoice external form

Accounting impact

Inventory: -$1,000

AR: +$1,500

 

Once payment is received, the accountant will bank the check, which will extinguish the customer's indebtedness; in other words, it will reverse the amount in accounts receivable:

Category

Activity

Transactions

Sales order

Fulfillment

Invoice

Accept payment

List

Item: iPhone

Customer: Brad Pitt

Customization

Sales order internal form; Sales order external form

Pick ticket, packing slip, shipping label

Invoice internal form, invoice external form

Accounting impact

Inventory: -$1,000

AR: +$1,500

Bank +$1,500

 

The accounting impact category enables the CFO to run the financial reports without having to do any further work, which is a major benefit of ERP. The Lists and Customization categories are the administrator's responsibility, to ensure the process works efficiently without the need for re-entering information. The sales rep, warehouse manager, and accountant have unwittingly created the financial statement by merely recording their work in the ERP system.

The NetSuite value proposition – the whole is greater than the sum of its parts

NetSuite takes ERP a step further. It is an ERP with a built-in CRM, all available in the cloud.

Most of the products out there are specialist products for specific areas of the business; for instance, salesforce.com, ConstantContact, or ShipStation. While these are excellent products with deep functionality, they are designed to automate departments whereas NetSuite automates the entire business.

NetSuite's functionality spans accounting, the warehouse, the website, marketing, sales, and customer support. This doesn't just provide efficiencies because we are administering one system instead of many. All the data is in one place for reporting and can easily be leveraged by different departments; for instance, the pricing matrix on the item master serves the website as well as the sales reps. If there is a price increase, it only needs to be changed once instead of in multiple databases.

NetSuite also tracks all the transactions and interactions on aggregate—such as sales reports for the company as a whole—but also on a per customer level. The result is a complete 360° customer view showing each individual customer history on one page, capturing the historical sales and products sold with  records of the calls, meetings, and emails exchanged with anyone in the company, which enables us to serve the customer more effectively and efficiently.

An employee can see the details by merely looking at subtabs on the customer card or at a summary by accessing the customer dashboard. So, the accountant can see that the sales rep is close to closing a huge opportunity with the customer prior to calling to collect a small outstanding debt, which could place the opportunity in jeopardy. The converse is also true; the sales rep can view the customer's average days to pay invoices prior to extending that customer's credit. Most importantly, it enables sales and marketing departments to access a customer's purchase history to determine which products represent good upsell opportunities—would you like fries with that?:

Customer record

The cloud also has implications for the business as well as administrators. The system requires minimal IT support. All you need is an internet connection and there is no need for database management, such as backups.

It also allows us to centralize administration. Do you need to implement and support a feature for the subsidiary in China? There is no need to fly there; you can simply do it all right from your office. (In my view, this shouldn't apply to subsidiaries in Hawaii, which require an onsite visit, especially if the deployment is scheduled for the winter!)

The cloud also offers opportunities for easier customer self-service by merely opening a window into the core business system. A cloud system is simply a database permanently on the web, which allows people access based on specific permissions. We typically think of employees as those users but there is no need to restrict this just to employees. We can simply allow outsiders into our system provided they have the right set of permissions, so NetSuite contains built-in customer, vendor, and partner portals, which can be made available to specific customers, vendors, and partners at no additional cost.

Summary

There is an old joke that goes: how do you know when your SAP implementation is finished? It's when you run out of money!

Companies used to have to spend millions of dollars on ERP in order to achieve the benefits of running the business in one system. The benefits of buying, selling, planning, and reporting within a single platform had to be weighed against the substantial cost of implementing and running the ERP.  It required teams of consultants to gather requirements, consolidate processes between departments, and be physically present to configure the processes in the ERP system.

The internet democratized knowledge, technology, and ERP. There is no need to pay millions when you can rent a robust ERP like NetSuite for an affordable price per user per month. There is also no need to employ a team of consultants when a strong administrator can control a worldwide deployment from a home office; we will be exploring how an administrator can do so in the remaining chapters.

NetSuite has thousands of customers and has built features and processes to solve business problems you don't even know you have. Leveraging these tools is an effective way for an administrator to demonstrate value to the business, so we will start by examining them in Chapter 2, Exploring NetSuite Tools.

Left arrow icon Right arrow icon

Key benefits

  • Understand the business considerations and implementation of the NetSuite ERP
  • Gain a deep knowledge of enterprise security, data management, process automation, and analytics
  • Learn techniques to sail through system maintenance while ensuring accuracy and to practically troubleshoot issues

Description

NetSuite ERP is a complete, scalable cloud ERP solution targeted at fast-growing, mid-sized businesses and large enterprises. It's the smartly executed combination of financial management operations and built-in business intelligence, which enables companies to make data-driven and well-informed decisions. This book will help administrators become expert enough to be seen as the NetSuite leader at their company and to be able to advise department heads on specific processes, and strategic decisions. We start with an overview of ERP and NetSuite ERP, before going on to explain the built-in features to show the breadth of NetSuite ERP's product and its ease of use. We then discuss business aspects, focusing on the most important processes in NetSuite. Then you'll understand the implementation aspects that are generic enough to cover all the features. The focus then shifts to specific skills that you will need to administer for any system, such as roles, permissions, customization, and data imports. Moving on, you'll learn how to centralize the creation of search templates and give users the tools to pivot the data and expose it to the user in useful ways, such as on the dashboard. The book ends with checklists providing actionable steps that you as an administrator can take to do your job and support the application through new releases and troubleshooting problems.

Who is this book for?

This book is for administrators, consultants, and Project Managers who would like to improve their skills in the areas of configuration and system management. Basic experience implementing NetSuite is assumed.

What you will learn

  • Explore how the framework streamlines the implementation of new and existing features
  • Leverage built-in tools to optimize your efficiency and effectiveness
  • Test configuration to check the implementation of role-specific permissions
  • Understand how to optimize the amount of data to be shared with users
  • Import data like new leads and employ current data like pricing updates
  • Perform on-going maintenance and troubleshoot issues

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jun 29, 2018
Length: 360 pages
Edition : 1st
Language : English
ISBN-13 : 9781788626163
Tools :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning

Product Details

Publication date : Jun 29, 2018
Length: 360 pages
Edition : 1st
Language : English
ISBN-13 : 9781788626163
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 111.97
NetSuite ERP for Administrators
€35.99
NetSuite for Consultants
€41.99
NetSuite for Consultants, 2e
€33.99
Total 111.97 Stars icon

Table of Contents

14 Chapters
The Value Proposition – Doing More with Less Chevron down icon Chevron up icon
Exploring NetSuite Tools Chevron down icon Chevron up icon
OneWorld Chevron down icon Chevron up icon
Implementing Chevron down icon Chevron up icon
Security and Permissions Chevron down icon Chevron up icon
Customization Chevron down icon Chevron up icon
Imports Chevron down icon Chevron up icon
Analytics – Searches, Reports, and the Dashboard Chevron down icon Chevron up icon
Workflows Chevron down icon Chevron up icon
Integration Chevron down icon Chevron up icon
New Releases Chevron down icon Chevron up icon
Troubleshooting Tips Chevron down icon Chevron up icon
An Ongoing Maintenance Checklist Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(2 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Ola Jan 31, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Excellent product. A great insight and guidance. I wish I had it a year ago.
Amazon Verified review Amazon
Tadashi Davis Aug 27, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I have done 20 NetSuite implementations. This book is still a great tool to keep on your tablet to ensure all bases are covered in the backend. It is very informative and if you are a NetSuite admin it is a must have.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.