NetSuite ERP Consultant Sample Test

March 2019

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
Contents
About this Sample Test ................................................................................................................................. 4
Notes about the actual Exam: ....................................................................................................................... 4
I. Identify Accounting Preferences to be configured to support a customer specific
requirement. ................................................................................................................................................ 5
II. Identify the implications of Chart of Accounts Setup. ................................................................ 5
III. Identify where and how default financial segments (including accounts and subsidiaries) are
set and used on transactions. ...................................................................................................................... 5
IV. Recognize NetSuite recommended practices around period close and accounting/tax period
structure. ...................................................................................................................................................... 6
V. Identify the constraints of features and functionality related to Journal Entries. .................... 6
VI. Identify how exchange rates are used throughout NetSuite. .................................................... 6
VII. Identify considerations when setting up related Entity records. ............................................... 6
VIII. Given a requirement, determine the configuration/solution for an order process. ................. 6
IX. Identify the implications of shipping setup and use. .................................................................. 7
X. Determine the considerations for setup and execution of the fulfillment process. ................. 7
XI. Given a scenario, determine appropriate invoicing configuration and setup. .......................... 7
XII. Compare the differences between the various revenue recognition functionalities. ............... 8
XIII. Identify recommended practices for customer payment setup and processing. ...................... 8
XI. Given a requirement, determine the configuration/solution for a customer return process. . 9
XII. Identify the parameters in configuring commissions. ................................................................ 9
XIII. Recognize the functionality differences between Customer Center and My Account. ............. 9
XIV. Select the appropriate Item Type for a given use case. .............................................................. 9
XV. Given a scenario, determine appropriate inventory management options. ............................. 9
XVI. Identify the transactions and records related to building Assemblies. ................................... 10
XVII. Recognize how various transactions affect item costing. ......................................................... 10
XVIII. Identify options in pricing. ......................................................................................................... 11
XIX. Given a requirement, determine the configuration/solution for a purchase process. ........... 11
XX. Given a requirement, determine the configuration/solution for a vendor return process. ... 11
XXI. Recognize the elements in configuring the Fixed Assets Module. ........................................... 11
XXII. Given a scenario, select the appropriate Dashboard portlet content...................................... 12
XXIII. Recognize which SQL expressions will yield desired search results. ........................................ 12
XXIV. Identify configuration options available when customizing email alerts for saved searches. 12
XXV. Using Expression Builder, select the expression which would yield the desired results. ....... 12

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XXVI. Recognize which record to use as the basis of a search to yield a desired result. .................. 13
XXVII. Identify the feature in saved searches to obtain the described results. .................................. 13
XXVIII. Given a scenario, determine whether to use a custom search or a report formula? .............. 13
XXIX. Given a scenario, determine when the Alternate Date/Period Range feature should be used.
13
XXX. Identify the advantages of various methods of publishing dashboards. ................................. 14
XXXI. Identify data security considerations when publishing custom records to
Customer/Vendor/Partner Centers. .......................................................................................................... 14
XXXII. Recognize available SuiteFlow actions ...................................................................................... 14
XXXIII. Compare differences between custom form & field display options and uses cases where
appropriate. ................................................................................................................................................ 14
XXXIV. Identify implications of various methods of restricting users to a particular custom form. ... 15
XXXV. Given a custom form layout requirement, determine which feature(s) should be used. ....... 15
XXXVI. Identify custom field settings for displaying data from other records. ................................... 15
XXXVII. Recognize NetSuite recommended practices for creation and use of custom fields. ............. 15
XXXVIII. Identify implications of changing field properties or values in a live environment. ............... 16
XXXIX. Identify NetSuite account settings which can only be changed by sending a request to
NetSuite Customer Support. ...................................................................................................................... 16
XL. Determine the proper use of advanced options in CSV Import. .............................................. 16
XLI. Organize the steps required to successfully complete an import of CSV records and sublist
data. 16
XLII. Given a customer requirement, determine migration strategy for transaction history and
opening balances........................................................................................................................................ 17
XLIII. Identify the implications of permissions related to accessing and manipulating data in bulk.
17
XLIV. Recognize recommended NetSuite practices for creating and assigning custom roles. ......... 17
XLV. Answer Keys: .............................................................................................................................. 18

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
About this Sample Test

None of these questions are on the ERP Consultant Exam. Most of these questions were written by the same
authors who wrote the actual exams. We have tried to write them to a similar level of difficulty as the actual exam
questions, but do not guarantee this.

This sample test is provided to give you an idea of the format of questions that might be asked on the exam.
However, the sample test does not provide comprehensive coverage of all topics on the test. All material listed in
the SuiteFoundation Study Guide may be tested.

Being able to answer all the below questions correctly does not guarantee that you will pass the SuiteFoundation
exam. We do not publish our passing score.

The number of sample questions per test objective does not reflect the actual weighting of the exam. Any
objective may have more, or fewer, questions than are presented here. All objectives have at least one sample
question included here.

Notes about the actual Exam:

When the correct answer includes selecting more than one answer (For example, “Which two…”), the
Exam will force you to choose the correct NUMBER of answers.

Matching questions are worth the same point value as any other question, though they may take longer
to answer. Also, there is no partial credit, all the matches must be correct.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 I. Identify Accounting Preferences to be configured to support a customer specific requirement.
1) Which three requirements can be addressed using standard NetSuite functionality in accounting preferences?

A. Automatically Email Drop Ship P.O.s.

B. Send Order Fulfilled Confirmation Emails.
C. Send Email Confirmation when Sales Order Updated.
D. Send Email Confirmation when Sales Order Canceled.
E. Automatically Email Sales Rep on Sales Order Approval.

2) A company has decided to use the Class segment to track product lines on sales. They would like to force users to
enter a value in this field and have configured the system to show the class field at the line level of transactions.

Which two configurations are required to meet these requirements?

A. Set a default value based on the Class of the current user.

B. Enable the accounting preference Make Classes Mandatory.
C. Disable the accounting preference Make Classes Mandatory.
D. Create a dummy value called "No Class" to select on transactions where a product line is not applicable.

II. Identify the implications of Chart of Accounts Setup.

3) Which action is recommended for undesired accounts in preparing for go-live?

A. Leave undesired accounts active to avoid disabling features.

B. Leave undesired accounts active in case transactions post to them.
C. Inactivate undesired accounts to remove them from searches and reports.
D. Inactivate undesired accounts to prevent transactions from posting to them.

4) What is a benefit of viewing Chart of Accounts with Show Inactives Marked?

A. Accounts can be sorted by subsidiary.

B. The Inline Editing option becomes available.
C. Amounts posted to inactive default accounts are visible.
D. Inactive and delete checkboxes can be used to disable features.

III. Identify where and how default financial segments (including accounts and subsidiaries) are set and used on
transactions.
5) Which three valid characteristics affect setting up and assigning NetSuite default segments
(Department/Class/Location)?

A. Locations are available for tracking inventory.

B. Segments can be used to restrict data access.
C. Segments can be defined in relation to each other.
D. Only Classes can be configured for Commissions.
E. Departments can be defined in a hierarchy for reporting purposes.

6) Which segment combinations require SuiteScript?

A. Limit Account to specific Classes

B. Limit Class to specific Departments
C. Limit Account to specific Subsidiaries
D. Limit Department to specific Subsidiaries

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 IV. Recognize NetSuite recommended practices around period close and accounting/tax period structure.
7) Which two statements are true about the Multiple Calendars feature?

A. Without this feature, Tax Periods are the same as Accounting Periods.
B. Without this feature, the Tax Years are the same across all subsidiaries.
C. With this feature, U.S. and Canadian subsidiaries can utilize Tax Period functionality.
D. With this feature, different fiscal calendar definitions can be used on the same subsidiary for accounting
and tax periods.

V. Identify the constraints of features and functionality related to Journal Entries.

8) What is the impact of enabling the “Void Transactions Using Reversing Journals” setting?

A. It displays a VOID button on the transaction and voids the Journal Entry.
B. It displays a VOID button on the transaction and creates a Reversing Journal Entry.
C. It displays a CANCEL button on the transaction and allows a manual Journal Entry to be associated.
D. It displays a CANCEL button on the transaction and negates the GL impact, making the transaction non-
posting.

VI. Identify how exchange rates are used throughout NetSuite.

9) All multi-currency features are enabled in a OneWorld account. Given the following image of the NetSuite
currencies screen:

What does the Base Currency column with a value of "Yes" mean?

A. The currency is used on bank account records.

B. The currency is used on customer or vendor records.
C. The currency is used on subsidiary records or the company information.
D. The currency record was flagged as allowable for setup as a Base Currency.

VII. Identify considerations when setting up related Entity records.

10) Which functionality is included when the Consolidated Payments feature is enabled?

A. The credit limit set on individual subcustomers records is enforced.

B. Consolidated Unbilled Orders are shown as a sublist on the customer record.
C. The A/R Aging report shows the un-consolidated balance for each subcustomer.
D. Only consolidated statements for the entire customer-subcustomer can be printed.

VIII. Given a requirement, determine the configuration/solution for an order process.

11) A company has customers with centralized purchasing departments that buy products for multiple locations at the
same time. The customers want the products shipped to different locations from the same order.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 Which two features and/or functions in NetSuite need to be enabled?

A. Advanced Shipping
B. Shipping Label Integration
C. Multiple Shipping Routes
D. Enable Line Item Shipping

12) A company's corporate policy requires re-approval for any changes made to approved sales orders prior to
fulfillment. A sales order was entered, approved and then changed but did not go back through the approval
process.

Why did this sales order not go back through the approval process?

A. The change was made by the originator of the sales order.

B. The "Require Re-Approval on edit of Sales Order" preference is not set.
C. The change did not affect the dollar amount of the order, therefore no re-approval is required.
D. The change was made by a user with Administrator rights.

13) A customer has multiple open sales orders on file. A customer deposit is applied to the wrong sales order.

What is the process to unlink the deposit from the sales order to allow it to be applied to a different one?

A. Delete the Deposit Application record.

B. Change the sales order form to a cash sale.
C. Once linked, deposits cannot be unlinked and need to be credited or deleted.
D. On the Customer Deposit, the sales order field will be a drop down. Choose the appropriate sales order to
link it to.

IX. Identify the implications of shipping setup and use.

14) What are two considerations for shipping integration?

A. Shipping Items track profitability per Sales Order.

B. Tracking numbers assigned on the Fulfillment flow backward to the Sales Order.
C. Both Fedex and UPS support use of negotiated rates when charging customers for shipping.
D. Shipping Items can be used by multiple subsidiaries, as long as they have the same base currency.

X. Determine the considerations for setup and execution of the fulfillment process.
15) Which statement is true about enabling the Multi-Location Inventory feature?

A. It is recommended to fulfill all open orders after enabling Multi-Location Inventory, before distributing
inventory.
B. The quantity and valuation on inventory reports will not include the quantity distributed per locations.
C. The Enable Multi-Location Inventory feature can be enabled anytime after enabling the Inventory Feature.
D. The Multi-Location Inventory feature can be disabled anytime after distributing inventory.

XI. Given a scenario, determine appropriate invoicing configuration and setup.

16) An employee reports eight hours of consulting services for three days to the same customer.

Which two invoicing preferences option will produce an invoice with 24 hours of time at the billable rate?

A. Group Time by Employee

B. Combine Time Items on Invoices
C. Bill Employee Costs To Customer

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 D. Combine Employee Time on Invoices

17) A company sells yearly service contracts for $1,000 that require a 10% initial fee. These are sometimes
discounted. They bill at the end of each month.

How should the billing schedule for this company be configured? Which three settings would be correct?
Recurrence frequency is monthly.

A. Initial amount set to $100

B. Initial amount is set to 10%
C. In Arrears is Enabled
D. In Arrears is disabled
E. Recurrence count is 11
F. Recurrence count is 12

XII. Compare the differences between the various revenue recognition functionalities.
18 . Match the Revenue Recognition Feature with how it can be used.

1. Revenue Commitment
2. VSOE
3. Revenue Recognition Schedule
4. Revenue Recognition Template

A. Shows list of Revenue Recognition Journal Entries to be generated

B. Allows auto-allocation of revenue across elements sold in a bundle
C. Allows recognition of revenue before invoicing
D. Allows definition of % of revenue to be recognized up front

XIII. Identify recommended practices for customer payment setup and processing.

19. With credit card integration enabled, what happens when a standalone cash sale (no preceding sales order) is saved
with a Credit Card payment type selected?

A. Authorize a credit card only.

B. Charge/capture a credit card only.
C. Authorize and charge/capture a credit card.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 XI. Given a requirement, determine the configuration/solution for a customer return process.

20. Which statement is true about the default impact of receiving a customer return?
a. The returned item is added to available inventory.
b. The returned item is marked as an expense.
c. The returned item is added to a “Repair” location.
d. The returned item has no impact on inventory on hand count.

XII. Identify the parameters in configuring commissions.

21) What impact does the manager commission schedule have on the commissions a Manager receives?

A. Manager schedules have no impact on the commission the Manager receives. It is only used for reporting
purposes.
B. Manager schedules calculate commission for Sales Managers based on the sales they make only. Employee
commissions do not affect the Manager.
C. Manager schedules calculate commission for Sales Managers based on the sales made by Sales Reps they
supervise as well as the sales they make directly.
D. Manager schedules calculate commission for Sales Managers based on the sales made by all Sales Reps
regardless of reporting structure as well as the sales they make directly.

XIII. Recognize the functionality differences between Customer Center and My Account.
22) Which Center Type is used to grant Customers access to “My Account”?

A. Sales Center
B. Customer Center
C. Accounting Center
D. My Account Center
E. Ecommerce Center

XIV. Select the appropriate Item Type for a given use case.
23) A company is a big box retailer of kitchen appliances. Every kitchen appliance sold has a unique 13-digit alpha-
numeric code that every consumer must reference when doing the following:

· Registering their product online for a factory warranty

· Returning a defective appliance back to the manufacturer

Which feature most fully meets this company's needs given these requirements and characteristics?

A. Lot-numbered Inventory
B. SKU numbers
C. Serialized Inventory Items
D. Auto-Generated Numbers

XV. Given a scenario, determine appropriate inventory management options.

24) A company does quarterly cycle counts for the top three inventory items with the highest turnover. The most
recent cycle count resulted in the following inventory discrepancies for these three items:

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 Which scenario most closely matches the "best practice" for ensuring accurate inventory quantities?

A. Create a journal entry posted to the asset account of each item for the cost associated with each difference.
B. Create an Inventory Adjustment where each line item represents the item cycle counted and its
corresponding difference.
C. As part of the period close process, complete the "Reconcile Inventory" task for the period the cycle count
was conducted in.
D. Run the "Inventory Activity Detail" for the quarter the cycle count was conducted in. Edit and Save the
oldest transaction for each item. NetSuite will auto-adjust to reflect the current, correct on hand quantities.

25) Which two statements are true about Intercompany Inventory transactions?

A. Drop ship and Special Order are both supported between subsidiaries.
B. Pick, Pack, Ship is an option for intercompany transfers, just as for fulfillments of sales to customers.
C. Inventory must be valued at the same cost in the new subsidiary as the cost in the originating subsidiary.
D. There is an “In Transit” option for inventory, during which time it is not counted as an asset for either
subsidiary.

XVI. Identify the transactions and records related to building Assemblies.

26) Which three actions are supported using assembly functionality?

A. including service items as a component in the assembly

B. including components that are serialized or lot-numbered items
C. tracking replacement of one component with another similar component
D. tracking variation in the quantities of components from one batch of assemblies to the next

XVII. Recognize how various transactions affect item costing.

27) A company wants to introduce tighter controls on their inventory costing by leveraging the “Landed Cost” feature.

Which three statements are true about Landed Cost setup features?

A. Multiple Landed Cost Categories can be applied to an Item Receipt.

B. Landed Cost can be allocated by Weight, Cost, Quantity, or manually overwritten.
C. Multiple Bills can be linked to the same Landed Cost Category on the Item Receipt.
D. Both the Inventory Item, and the Landed Cost Item must be marked Landed Cost = True.
E. A freight bill can be linked to multiple Item Receipts and allocated automatically between them.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XVIII. Identify options in pricing.
28) Match the pricing use-case to the method to determine the quantity pricing. (Not all choices will be used)

A. ___ Pricing is applied according to the quantity included in the line item.
B. ___ Pricing is applied for all line items for the same item on a transaction.
C. ___ Pricing is applied for all items in the same hierarchy.

1. by Line Quantity
2. by Overall Item Quantity
3. by Overall Parent Quantity
4. by Overall Pricing Group Quantity

XIX. Given a requirement, determine the configuration/solution for a purchase process.

29) A company's purchasing department creates purchase orders for everything they order and needs to enter the
vendor bill prior to the goods being received.

What needs to be configured in NetSuite?

A. Nothing; this is default functionality.

B. Enable Bill in Advance of Receipt functionality.
C. Click Receive and Bill when the vendor invoice arrives.
D. Configure a workflow to allow the bill to be entered prior to receiving the goods.

XX. Given a requirement, determine the configuration/solution for a vendor return process.
30) A purchasing department needs to track defective items that are returned to the vendor for replacement or
credit.

What two settings need to be configured in NetSuite?

A. Enable the Vendor Return Authorizations feature

B. Enable the Credit in Advance of Vendor Return preference
C. Use the standard Vendor Activity report.
D. Customize the Inventory Activity Detail to filter by transaction type, and add column for Vendor RMA status.
E. Customize the A/P Register to filter by transaction type Vendor Returns, and add a column for Item Name.

XXI. Recognize the elements in configuring the Fixed Assets Module.

31) Which statement is true regarding the Fixed Asset Management setup option to “Restrict Ability to Reject
Proposals”?

A. If this option is checked, only users with the Fixed Asset Management Role can reject proposals.
B. If this option is not selected, all NetSuite users will have the ability to reject asset proposals.
C. If this option is checked, only NetSuite Administrators can reject proposals
D. If this option is checked, only users with the "Reject Proposal" permission can reject proposals

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XXII. Given a scenario, select the appropriate Dashboard portlet content.
32) The Sales Manager of a company manages 4 sales teams. In order to establish the value of an incentive bonus,
she will measure each team’s performance using a month-by-month comparison, taking into account the
following information:

• The increase in company sales since the previous evaluation

• Each team's relative contribution to the overall results
• Each team's size

Which Dashboard feature will provide the information?

A. KPI Scorecard portlet

B. Custom Search portlet
C. A combination of trend graphs and report snapshots
D. A combination of reminders in the reminder portlet and KPI Meters

XXIII. Recognize which SQL expressions will yield desired search results.
33) Match the SQL code with its result:
A. NULLIF
B. IS NULL
C. CASE
D. TO_CHAR
E. DECODE
1. To avoid divide by zero errors: if result is zero, replace with null
2. Returns value based on different conditions
3. Display “Unassigned” in results if blank
4. Display date by day of the week
5. Compares 2 values, then returns specified parameter if they match

XXIV. Identify configuration options available when customizing email alerts for saved searches.

34) Which setting on a saved search will email only the assigned Sales Rep when search criteria are met?

A. Specific Recipients tab > Recipient = Sales Rep

B. Recipient from Results tab > Recipient Field = Sales Rep
C. Updated Fields tab > Send On Update field = checked
D. Send Email Alerts When Records are Created/Updated field = checked

XXV. Using Expression Builder, select the expression which would yield the desired results.
35. When building a saved search where “Use Expressions” checkbox = True, which two are requirements in the setup?
A. Available Filter in the Filter Region must not use the same field as the Criteria
B. Parentheses must balance
C. Audience must be set to Allow Audience to Edit
D. Parentheses must be used on every line

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 XXVI. Recognize which record to use as the basis of a search to yield a desired result.

36. An Invoice Saved Search needs to display the items and original quantities from the sales order.

Which Join relationship in the Results Columns should be used to retrieve the information?

A. Created From Fields...

B. Billing Transaction Fields...
C. Applying Transaction Fields...
D. Applied To Transaction Fields...
E. Fulfilling/Receiving Transaction Fields...

XXVII. Identify the feature in saved searches to obtain the described results.
37. A customer needs to report outgoing order information from several warehouse locations. For each warehouse, the
report needs to display the following:

• Number of orders
• Number of fulfillments
• Total value of fulfilled orders
• Total volume fulfilled

What is the most efficient solution to fulfill the requirements?

A. Use a custom report based on Quantity Fulfilled Metrics.

B. Use a Saved Search using Summary functionality on the Results Columns.
C. Add a sublist of transactions to Warehouse Location records with a transaction type filter displayed in the
footer.
D. Develop a scripted solution creating a custom record to capture the information every time an order is
saved and fulfilled.

XXVIII. Given a scenario, determine whether to use a custom search or a report formula?
38. Which formula below would require a custom search formula because it is not supported by a custom report
formula?

A. Percent Difference of X ((x-y)/x)*100

B. Ratio x/y
C. Difference x-y
D. (x+y)/40

XXIX. Given a scenario, determine when the Alternate Date/Period Range feature should be used.
39. In order to customize the Sales by Sales Rep Report, to compare Sales results across multiple
time periods, which field can be added under Edit Columns to be set with Alternate Date Range
options?
a. Date Created
b. Sales Rep
c. Amount (Gross)
d. Date

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 XXX. Identify the advantages of various methods of publishing dashboards.
40) What are two recommended practices when publishing dashboards?

A. Label publishing roles to identify them.

B. Create one publishing role per dashboard.
C. Have one dashboard for the entire organization.
D. Create separate publishing roles for each center.

XXXI. Identify data security considerations when publishing custom records to Customer/Vendor/Partner Centers.
41) A customer is using Custom Records to track customer satisfaction surveys.

What data will NetSuite show when creating a list view for that Custom Record in the Customer Center?

A. All customer surveys are visible to all customers.

B. Only the customer surveys for the logged in customer.
C. Only the customer surveys for the logged in customer if the customer filter is applied.
D. No customer surveys are returned, as Custom Records cannot be linked to the Customer Center.

42) Match the setting to its definition.

Answer options may be used only once.

A. ___ Causes the system to check for conflicting updates when users attempt to save updates to a custom
record instance.
B. ___ Allow records to be edited directly when they display as a sublist.
C. ___ Allow records to be edited directly when they display as a list.
D. ___ Tracks all changes made to a record.

1. Enable Optimistic Locking

2. Enable Inline Editing
3. Enable System Notes
4. Allow Child Record Editing

XXXII. Recognize available SuiteFlow actions

43) A company uses a custom transaction body field to track information on sales orders. The field should populate
with the supervisor of the current user.

What is the simplest way to set the default value for this field?

A. Utilize NetSuite's inline editing capabilities.

B. Create a workflow to set the field value using conditional criteria.
C. Create a custom user role and set the employee restriction field to "none - default to own".
D. Set a dynamic default of “Current User’s Supervisor” on the "Validation & Defaulting" tab when setting up
the custom transaction body field.

XXXIII. Compare differences between custom form & field display options and uses cases where appropriate.
44) Which statement is true about custom fields with a display type of disabled?

A. A disabled field can display a default value

B. A disabled field is not available for transaction line (column) fields
C. A mandatory field cannot be disabled unless the field has a default value.
D. If the field does not have default, sourced or custom code information, it will not display on the form.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XXXIV. Identify implications of various methods of restricting users to a particular custom form.

45) Match the method for restricting a user onto a specific custom form, with the implication of that method. Use each
answer once.
A. Hide or disable the custom form field
B. Clear the Enabled checkbox for all other custom forms under Customize Role > Forms
C. Use the Restricted checkbox under Customize Role > Forms
D. On the custom form, mark Preferred for the user’s role

1. Role could get access to other new custom forms

2. Other users, like Administrators, would not be able to switch out of this custom form
3. User still has access to other custom forms
4. This is the best method

XXXV. Given a custom form layout requirement, determine which feature(s) should be used.
46) A company has created a custom HTML form layout for their Sales Order. When they go to test the form printing
and then emailing a sample Sales Order, the printed and the emailed versions look very different. What would
explain this?

A. They forgot to clear their cache before printing the transaction

B. The transaction form is not using the layout they just created in the Print Template field
C. The end user’s Home > Set Preferences have the wrong transaction forms selected
D. The customer is in a different subsidiary from the end user

XXXVI. Identify custom field settings for displaying data from other records.
47) A company has two types of customers - Wholesale and Retail. A custom field, “Channel”, is created to manage
this requirement and is set up on the customer record and on transactions.

The company wants to ensure the correct channel is always selected on the order without scripting. Wholesale
customers go through a manual entry and approval process. There are several thousand Retail customers with
approximately 400 orders per day.

What is the recommended way this should be implemented? Choose 2.

A. The Entity Field defaults to Wholesale and is changed to Retail manually.

B. The Transaction field sources the value from the entity.
C. The Transaction field is always set manually.
D. The Entity Field defaults to Retail and is changed to Wholesale manually.

48) What is the impact of using the "Filter Using" setting when creating a custom Transaction Body field, beyond
allowing the user to source data onto the transaction?

A. This field specifies from which field the information is copied.

B. This field specifies the record type from which information is copied.
C. This field allows dynamic filtering of the list/record field using multiple attributes.
D. This field allows the dynamic filtering of the list/record field by a particular attribute.

XXXVII. Recognize NetSuite recommended practices for creation and use of custom fields.
49) Which format of a custom field ID is recommended by NetSuite?

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
 A. custbody_[number]
B. custbody_[field name]
C. custbody_[date]_[number]
D. custbody_[company identifier]_[field name]

XXXVIII. Identify implications of changing field properties or values in a live environment.

50) What is the impact of changing an Asset account on item records?

A. The account will be changed on all transactions using that item.

B. Only open transactions will have the account changed.
C. If there are transactions with that item in closed periods, the account cannot be changed on the item
record.
D. The account will be changed for transactions only in open periods; transactions in closed periods will not be
changed.

XXXIX. Identify NetSuite account settings which can only be changed by sending a request to NetSuite Customer Support.
51) Which two can be enabled by NetSuite Customer Support?

A. Disable Delete All Data.

B. Bulk Transaction Delete.
C. Trigger a COGS recalculation.
D. Recalculate Consolidated Exchange Rates.

XL. Determine the proper use of advanced options in CSV Import.

52) A customer uses custom fields to track recall information about their items. The Quality Manager needs to know
when values have changed and by whom. Some of the data for the item recall is provided by vendors in CSV
format.

Which CSV option should be selected when importing the updated information from the vendor?

A. Add and Overwrite Sublists

B. Add and Log System Notes for Custom Fields
C. Update and Log System Notes for Custom Fields
D. Add or Update and Validate Mandatory Custom Fields

XLI. Organize the steps required to successfully complete an import of CSV records and sublist data.
53) A company has bought a marketing file with lists of potential Lead companies with contact
names. Order the steps for the CSV import.

A. ___Plan data file manipulations and import validation process.

B. ___Validate Imported Data.
C. ___Import Customer records.
D. ___Segregate Customer and Contact information into separate data files.
E. ___Import Contact Records.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XLII. Given a customer requirement, determine migration strategy for transaction history and opening balances.
54) Upon Go-Live on NetSuite, a customer wants to run comparative sales reports for month by month, covering the
last two years.

Match the approaches with their implications. Use each answer once.

A. ___ Import invoices for last two years.

B. ___ Import Journal Entries for each month of last two years.
C. ___ Persuade the customer to forego this requirement.
D. ___ Import custom records in place of transactions.
1. It may require creation of items no longer being sold and it affects GL.
2. Enter opening balances dated to two years ago.
3. After running NetSuite for two years, comparative reports will then be available
4. This will not show on financial reports.

55) Match the strategy for entering on hand count for go-live with available options.

Answer options may be used more than once, or not at all.

A. ___ Assign Quantity On Hand at the time of creating Item records.

B. ___ Enter the Inventory Worksheet on the day of go-live.
C. ___ Enter the Inventory Adjustment on the day of go-live.
D. ___ Enter purchase transactions on the day of go-live.

1. Manual Entry, CSV Import, Web Services. Valid in non-OneWorld only

2. Manual Entry, CSV Import, Web Services, OneWorld does not matter.
3. Manual Entry and CSV Import only
4. Manual Entry and Web Services only

XLIII. Identify the implications of permissions related to accessing and manipulating data in bulk.
56) Which two permissions will allow a user to impact data in bulk?

A. SuiteScript
B. Web Query
C. CSV Import
D. Export Lists
E. Publish Search

XLIV. Recognize recommended NetSuite practices for creating and assigning custom roles.
57) Which two use cases can be met using only custom role configuration (no scripting)?

A. Allow to Edit already existing Fulfill Sales Order transaction only, but not Create new Fulfill transactions.
B. Use the same custom role for all Sales Reps, automatically limiting them to see only data in their own
subsidiary.
C. Define some fields on Sales Reps restricted Sales Order form to be editable when in Create mode, but then
locked in Edit mode.
D. Restrict Sales Manager to Edit and View Orders from only Sales Rep reporting to them, yet allow them to
assign Customer to any Sales Rep in the company.

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.
XLV. Answer Keys:

1 A, B, D 31 C
2 B, D 32 A
3 B 33 A1, B3, C2, D4, E5
4 C 34 B
5 A, B, E 35 A,B
6 B 36 A
7 B, D 37 B
8 B 38 D
9 C 39 C
10 C 40 A, D
11 C, D 41 C
12 B 42 A1, B4, C2, D3
13 B 43 D
14 B, C 44 A, C, D
15 C 45 A2, B1, C4, D3
16 A, B 46 B
17 B, C, F 47 B,D
18 1C, 2B, 3A, 4D 48 D
19 C 49 D
20 A 50 C
21 C 51 B,C
22 E 52 C
23 C 53 A1, B5, C3, D2, E4
24 B 54 A1, B2, C3, D4
25 A, B 55 A1, B3, C4, D2
26 A, B, D 56 A, C
27 A, B, D 57 B, D
28 A1, B2, C3
29 B
30 A, C

NetSuite ERP Consultant Sample Test: March 2019 Copyright © 2019 NetSuite Inc.