About the NetSuite ERP Consultant Exam
This is the second exam required for NetSuite ERP Consultant Certification, to be taken after the SuiteFoundation Exam has been passed.
Passing both the NetSuite ERP Consultant Exam and the SuiteFoundation Exam certifies that you have the knowledge and skills necessary to be a NetSuite Certified ERP Consultant. See Description of a Qualified Candidate below.
• This will be a proctored examination.
• No written or online reference materials may be used during the exam.
• Complete all questions in the allotted time..
Description of a Qualified Candidate
The candidate has the equivalent experience of performing 5-10 medium scale, or 2-3 enterprise NetSuite ERP implementations, which is roughly equivalent to at least 2 years’ worth of NetSuite implementations in a consultant-related role. They can match NetSuite ERP solutions to business requirements. This person can advise on how to change standard ERP workflows, when to use scripting tools to meet the business needs, and when to extend use through integrations. This consultant can explain the implications and benefits of NetSuite configuration options.
Maintaining Your Certification
For details about retake policy and ongoing requirements to maintain your certification or examination status see the NS Certification Policy available on the NS Certification webpage.
Recommended Skill Level:
Equivalent to at least 2 years’ worth of NetSuite implementations in a consultant-related role
Subject Areas and Objectives Covered by the Test
The broad subject areas covered in the exam include:
• Data Strategy
The table below provides each subject area in more detail. For suggestions on studying for each objective, proceed to the matching sections on the pages that follow.
ERP: Record to Report (1)
Identify the Features and Preferences which need to be configured to support a customer specific requirement.
Identify the Best Practices of setting up the NetSuite Chart of Accounts.
Identify how NetSuite Segments are handled in NetSuite, and when to use custom segments.
Recognize NetSuite recommended Best Practices around period end close, including when Multi-Book is used.
Identify the constraints of features and functionality related to Journal Entries.
Identify how exchange rates are used throughout NetSuite.
Identify how NetSuite taxes are configured.
ERP: Procure to Pay (2)
Identify considerations when setting up related Entity records.
Given a requirement, determine the configuration/solution for an order process.
Identify the implications of shipping setup and use.
Determine the considerations for setup and execution of the fulfillment process.
Given a scenario, determine appropriate invoicing configuration and setup and when consolidated invoicing feature is appropriate.
Understand the different components of the ARM or Basic Rev Rec module and be able to set it up to adapt to the recognition method elected by the user.
Identify recommended practices for customer payment setup and processing.
Given a requirement, determine the configuration/solution for a customer return process.
ERP: Design to Build (3)
Select the appropriate Item Type for a given use case.
Given a scenario, determine appropriate inventory management options.
Identify the transactions and records related to building Assemblies.
Identify options in pricing.
Recognize how various transactions affect item costing.
ERP: Procure to Pay (4)
Given a requirement, determine the configuration/solution for a purchase and receiving process.
Given a requirement, determine the configuration/solution for a Vendor Bill, Bill Payments.
Given a requirement, determine the configuration/solution for a vendor return process.
Recognize the elements in configuring the Fixed Assets Module.
Analytics and Dashboard (5)
Given a scenario, select the appropriate Dashboard portlet content.
Recognize which SQL expressions will yield desired search results. (CASE, DECODE, NULLIF, Date functions)
Identify configuration options available when customizing email alerts for saved searches.
Using Expression Builder, select the expression which would yield the desired results.
Recognize which record to use as the basis of a search to yield a desired result.
Identify the feature in saved searches to obtain the described results.
Given a scenario, determine whether to use a custom search or a report.
Identify the advantages of various methods of publishing dashboards.
Given a situation identify whether a SuiteScript or SuiteFlow required to meet a customer requirement.
Identify components of the workflow in a diagram.
Recognize available SuiteFlow actions.
Compare differences between custom form & field display options and uses cases where appropriate.
Identify various methods of restricting users to a particular custom form.
Given a custom form layout requirement, determine which feature(s) should be used, including Advanced PDF.
Given a situation identify when to use SuiteBundler.
Identify custom field settings for displaying data from other records.
Recognize NetSuite recommended practices for creation and use of custom fields.
Identify implications of changing field properties or values in a live environment.
Data Strategy (7)
Determine the proper use of advanced options in CSV Import.
Understand the use of CSV templates and saved mappings.
Analyze an error in the CSV Import process to determine the appropriate resolution.
Given a customer requirement, determine migration strategy for transaction history and opening balances and inventory counts.
Organize the steps required to successfully complete an import of CSV records and sublist data.
Identify the implications of permissions related to accessing and manipulating data in bulk.
(8) Recognize recommended NetSuite practices for creating and assigning custom roles.
A company purchased and received 100 chairs for a conference room. Four of the chairs were the wrong style and must be returned.
What steps are performed after approving the Vendor Return Authorization?
A. Shipping the Return > Close Return
B. Shipping the Return > Crediting the Return
C. Shipping the Return > Create a Journal Entry
D. Shipping the Return > Mark Shipped on the Return Authorization
Which statement is true about Drop Ship and Special Order items?
A. Can be used for Non-Inventory items for Resale and Inventory items.
B. Items can be marked as both Drop Ship and Special Order,
C. Vendor ships items to customer’s address.
D. Impact Asset and Cost of Goods Sold (COGS) accounts upon item receipt and fulfillment.
Which is valid permission level for Persist Search?