NetSuite ERP Consultant Certification Exam with 100% Correct Answers 2023

NetSuite ERP Consultant Certification If a $15 shipping charge is added to a sales order for 3 items, and 1 of those is fulfilled/billed first and the remaining 2 items are fulfilled/billed later, how much of the shipping charge shows up on each bill? ($5/10, $15/0, or $0/15) - Correct answer-It will only charge for the amount shipped. Thus - $5 for the first item and $10 for the next two. Shipping item limited to 1 subsidiary (e.g. if UPS is a shipping item, create multiple versions for each sub) - Correct answer-Can create multiple shipping items for the same service to allow for using a carrier across multiple subs What causes a credit card hold? Choose 2 (AVS, CCV, Soft Descriptor) - Correct answer-Address Verification (AVS), Card Verification Value (CVV) Which can be shared across subsidiaries? (Vendors, Customers, Warehouse Location, Bins, Items, etc.) - Correct answer-GL Accounts, Tax Nexuses, Vendors, Customers, Warehouse Location, Bins, Items What is the email hierarchy for saved searches? - Correct answer-1. Specific Recipients 2. 'Recipients from results' tab sends emails to specific recipients baed on search filters 3. Targeting recipients based on search filters (alternate) Fixed Asset record - Correct answer-1. Include in Reports checkbox to include asset type in Asset Summary Report - all assets are included in the report by default 2. You can set asset depreciation parameters on the asset record If 'Restrict Ability to Reject Proposals' is selected, what is the outcome? - Correct answer-Only administrators have access to the 'Reject' Proposal' button Why would a custom field that has been added to a custom form but doesn't show up on the mapping screen? - Correct answer-Make sure the custom form is selected in advanced CSV settings What are the differences between inventory adjustment, inventory worksheet, and the various input methods? - Correct answer-1. Inventory Adjustment - Manual & Web Services - Inclusive of previous stock count, maintains LIFO & FIFO costing 2. Inventory Worksheet - Manual & CSV Import - Resets the inventory count to the amount entered on the worksheet Best practice to edit transactions in a closed period? - Correct answer-Give user admin role - re-open the closed period and close it again after the edits are made Where can the foreign exchange rate be configured to the historical exchange rate? - Correct answer-Subsidiary Conditions for accepting consolidated payments for child customers? - Correct answerMust be same currency & same subsidiary On which record do you enter tracking number, if you are NOT using a shipping integration? - Correct answer-Item fulfillment record What happens when there is a credit card on a sales order? - Correct answer-1. Authorize 2. Charge/capture (upon fulfillment) Customer center vs. Account center - Correct answer-1. Customer center - a role, accessible from 2. My Account - only available from the eCommerce site Review the SQL functions - Correct answer-1. CASE - Returns values based on different conditions 2. DECODE - Compares each expression to each search value 1 by 1 - IF expression = x, result is returned, IF not, default is returned 3. ISNULL - Replaces Null with another value 4. NULLIF - If two expressions are equal, then null is returned Which edition doesn't calculate tax out of the box? - Correct answer-United States Which field type to use for which scenario? 1. Hidden 2. Normal 3. Inline 4. Disabled - Correct answer-1. Hidden - field cannot be seen on the record or transaction 2. Normal - field can be edited 3. Inline - used for informational purposes - cannot be edited 4. Disabled - field cannot be edited How to delete data in bulk? - Correct answer-1. Inline 2. Suitescript 3. Delete all data 4. CSV import How to restrict a role to a custom form? - Correct answer-1. Hide or disable custom form field - other users would not be able to switch out of this custom form 2. Clear the enabled checkbox for all other forms under Customize Role Forms - Role could get access to new custom forms 3. Use the restricted checkbox under Customize Role Forms - this is the best method 4. On the custom form, mark preferred for the user's role - user can still access other forms What causes posting to COGS? - Correct answer-1. Standalone invoice 2. Item fulfillment How to prevent returned items from being added back into inventory? - Correct answer1. Clear re-stock option on item record 2. Enter write-off account on item return record How to view records without NS login? - Correct answer-File cabinet - 'Make all Files available without Login' Which transaction records are posting? - Correct answer-1. Invoice 2. Vendor Bill 3. Cash Sale Which account types can only be linked with a single subsidiary? - Correct answer-Bank accounts & credit cards KPI Scorecard vs. KPIs vs. KPI Meter - Correct answer-1. KPI - critical biz metrics, individual line within a portlet 2. KPI Scorecard - compares multiple KPIs over multiple date ranges + accounting periods 3. KPI meter - displays the KPI in a semi-circular meter with date ranges How to enable multiple addresses for one order? - Correct answer-1. Enable multiple shipping routes & line item shipping Why use global permissions? - Correct answer-Global permissions apply to all of a user's roles & and supersedes permissions set on role Can SuiteFlow trigger SuiteScript - Correct answer-Yes What are the credit card hold settings? - Correct answer-1. Ignore - doesn't matter if customer has met or exceeded their credit limit 2. Warn Only - Generates a warning when transaction is entered that puts a customer at or above the limit 3. Enforce holds - blocks entry of transaction for a customer at or above the limit 4. Days overdue for warning/hold - # of days overdue to generate warning or enforce hold Revenue recognition options - Correct answer-1. Revenue commitment - allows rev rec before billing 2. Rev rec schedule - shows list of revenue recognition journal entries to be generated 3. Rev rec template - Allows for definition of % of revenue to be recognized up front