Download NetSuite Customization and Configuration Practices and more Exams Advanced Education in PDF only on Docsity!
NETSUITE ERP Consultant exam – Sample
questions and answers 2023
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. - A. Automatically Email Drop Ship P.O.s. B. Send Order Fulfilled Confirmation Emails. D. Send Email Confirmation when Sales Order Canceled. 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. - B. Enable 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. 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 - B. Leave undesired accounts active in case transactions post to them. 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. - C. Amounts posted to inactive default accounts are visible. 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. - A. Locations are available for tracking inventory. B. Segments can be used to restrict data access. E. Departments can be defined in a hierarchy for reporting purposes. 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 - B. Limit Class to specific Departments 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. - B. Without this feature, the Tax Years are the same across all subsidiaries. D. With this feature, different fiscal calendar definitions can be used on the same subsidiary for accounting and tax periods. 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.
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 - B. Change the sales order form to a cash sale. 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. - 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. 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. - C. The Enable Multi-Location Inventory feature can be enabled anytime after enabling the Inventory Feature. 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 D. Combine Employee Time on Invoices - A. Group Time by Employee B. Combine Time Items on Invoices
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 $ 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 - B. Initial amount is set to 10% C. In Arrears is Enabled F. Recurrence count is 12 Match the Revenue Recognition Feature with how it can be used.
- Revenue Commitment
- VSOE
- Revenue Recognition Schedule
- 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 - 3. Revenue Recognition Schedule - A. Shows list of Revenue Recognition Journal Entries to be generated
- VSOE - B. Allows auto-allocation of revenue across elements sold in a bundle
- Revenue Commitment - C. Allows recognition of revenue before invoicing
- Revenue Recognition Template - D. Allows definition of % of revenue to be recognized up front 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 - C. Authorize and charge/capture a credit card Which statement is true about the default impact of receiving a customer return?
A. Drop ship and Special Order are both supported between subsidiaries. B. Pick, Pack, Ship is an option for inter-company transfers, just as for fulfillment 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. - 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. 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 - A. including service items as a component in the assembly B. including components that are serialized or lot-numbered items D. tracking variation in the quantities of components from one batch of assemblies to the next A company wants to introduce tighter controls on their inventory costing by leveraging the "Landed Cost" feature. Which two 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. - B. Landed Cost can be allocated by Weight, Cost, Quantity, or manually overwritten. D. Both the Inventory Item, and the Landed Cost Item must be marked Landed Cost = True. 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.
- by Line Quantity
- by Overall Item Quantity
- by Overall Parent Quantity
- by Overall Pricing Group Quantity - A. ___ Pricing is applied according to the quantity included in the line item. 1. by Line Quantity B. ___ Pricing is applied for all line items for the same item on a transaction. 2. by Overall Item Quantity C. ___ Pricing is applied for all items in the same hierarchy. 3. by Overall Parent Quantity 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. - B. Enable Bill in Advance of Receipt functionality. 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. - A. Enable the Vendor Return Authorizations feature C. Use the standard Vendor Activity report. 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.
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 - B. Recipient from Results tab > Recipient Field = Sales Rep 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 - A. Available Filter in the Filter Region must not use the same field as the Criteria B. Parentheses must balance 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... - A. Created From Fields... 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. - B. Use a Saved Search using Summary functionality on the Results Columns. 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)* B. Ratio x/y C. Difference x D. (x+y)/40 - D. (x+y)/ 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 - c. Amount (Gross) 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. - A. Label publishing roles to identify them. D. Create separate publishing roles for each center. 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. - C. Only the customer surveys for the logged in customer if the customer filter is applied. Match the setting to its definition.
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
- Role could get access to other new custom forms
- Other users, like Administrators, would not be able to switch out of this custom form
- User still has access to other custom forms
- This is the best method - A. Hide or disable the custom form field (2. Other users, like Administrators, would not be able to switch out of this custom form) B. Clear the Enabled checkbox for all other custom forms under Customize Role > Forms (1. Role could get access to other new custom forms) C. Use the Restricted checkbox under Customize Role > Forms (4. This is the best method) D. On the custom form, mark Preferred for the user's role (3. User still has access to other custom forms) 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 - B. The transaction form is not using the layout they just created in the Print Template field 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. - B. The Transaction field sources the value from the entity. D. The Entity Field defaults to Retail and is changed to Wholesale manually. 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. - D. This field allows the dynamic filtering of the list/record field by a particular attribute. Which format of a custom field ID is recommended by NetSuite? A. custbody_[number] B. custbody_[field name] C. custbody_[date][number] D. custbody[company identifier][field name] - D. custbody[company identifier]_[field name] 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 - C. If there are transactions with that item in closed periods, the account cannot be changed on the item record. 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. - B. Bulk Transaction Delete. C. Trigger a COGS recalculation. 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
B. ___ Import Journal Entries for each month of last two years. - 2. Enter opening balances dated to two years ago. C. ___ Persuade the customer to forego this requirement. - 4. This will not show on financial reports. D. ___ Import custom records in place of transactions. - 3. After running NetSuite for two years, comparative reports will then be available 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.
- Manual Entry, CSV Import, Web Services. Valid in non-OneWorld only
- Manual Entry, CSV Import, Web Services, OneWorld does not matter.
- Manual Entry and CSV Import only
- Manual Entry and Web Services only - A. ___ Assign Quantity On Hand at the time of creating Item records. - 1. Manual Entry, CSV Import, Web Services. Valid in non-OneWorld only B. ___ Enter the Inventory Worksheet on the day of go-live. - 3. Manual Entry and CSV Import only C. ___ Enter the Inventory Adjustment on the day of go-live. - 4. Manual Entry and Web Services only D. ___ Enter purchase transactions on the day of go-live. - 2. Manual Entry, CSV Import, Web Services, OneWorld does not matter. 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 - A. SuiteScript C. CSV Import 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 - B. Use the same custom role for all Sales Reps, automatically limiting them to see only data in their own subsidiary. 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
