Book Image

NetSuite for Consultants - Second Edition

By : Peter Ries
Book Image

NetSuite for Consultants - Second Edition

By: Peter Ries

Overview of this book

ERP and CRM consultants can effectively implement NetSuite for a client organization with the aid of NetSuite for Consultants, revised with the latest features and best practices for NetSuite 2023. After reading this book, you’ll have a thorough understanding of how to configure the NetSuite ecosystem for any business. You’ll learn how to apply new features such as the Manufacturing Mobile application, NetSuite budgeting features, and tools for handling rebates and trade promotions. This edition also includes expanded coverage of technical topics such as SuiteQL and the SuiteTalk REST API. Understanding what a business requires is a crucial first step toward completing any software product deployment, and this NetSuite guide will teach you how to ask meaningful questions that ascertain which features, basic and new, you will need to configure for your client. Most importantly, you’ll not only learn how to perform a NetSuite implementation; you'll also learn how to prepare clients to use the software confidently, which is the true test of a great consultant.
Table of Contents (28 chapters)
1
Section I: The NetSuite Ecosystem, including the Main Modules, Platform, and Related Features
5
Section II: Understanding the Client’s Organization
11
Section III: Implementing an Organization in NetSuite
21
Section IV: Managing Gaps and Integrations
25
Other Books You May Enjoy
26
Index
Appendix: My Answers to Self-Assessments

Performing imports for data migration testing and other reasons

Once you start to collect a set of files from another system, you want to bring them in, in a limited fashion, to test the waters for the migration. The first step in this process is typically helping the client know what NetSuite is looking for, with each of the lists and record types they want to import. The NetSuite services team typically provides templates, in a set of Excel files, to show the client which columns are to be included with each import, which of those are required or optional, and what the data type for each field should be.

The following table shows what they usually look like, including extra rows explaining how the data should be formatted, and so on:

Figure 20.1 – An example of a CSV template for an entity record

Figure 20.1 – Template for an entity record

Sending a client a set of templates and guiding them in their use is typically enough to get them started. They will determine which columns in the data files from their legacy system...