Download NetSuite Customization and Configuration and more Exams Advanced Education in PDF only on Docsity!
NetSuite ERP Consultant Exam questions and
answers
Which 3 requirements can be addressed using standard NS functionality in Accounting Preferences? - 1. Automatically Email Drop Ship PO's, 2. Send Order Fulfilled Confirmation Emails, 3. Send Email Confirmation when SO is cancelled. 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. What 2 configs are required? - 1. Enable the account pref: Make Classes Mandatory, 2. Create a dummy value called "No Class" Which action is recommended for undesired accounts in preparing for go-live - Leave undesired accounts active in case transactions post to them What is a benefit of viewing Chart of Accounts with Show Inactives Marked - Amounts posted to inactive default accounts are visible Which 3 valid characteristics affect seeting up and assigning NS default segments (Dept/Class/Location) - 1. Locations are available for tracking inventory, 2. Segmenets can be used to restrict data access, 3. Departemnets can be defined in a hierarchy for reporting purposed Which segment combinations require SuiteScript? - Limit Class to specific Departments (no Script required: Limit account to specific Class or subsid, and limit dept to subsid) Which two statements are true about the Multiple Calendars feature - Without this feature, the Tax Years are the same across all subsids, AND With this feature, different fiscal calendar defs can be used on the same subsid for accounting & tax periods What is the impact of enabling the "Void Transactions Using Reversing Journals" setting - It displays a VOID button on the transaction and creates a Reversing JE All multi-curr features are enabled in a One-World account. What does the Base Currency column with a value of "Yes" mean - The currency is used on subsidiary records or the company information Which functionality is included when the Consolidated Payments feature is enabled - The A/R Aging report shows the un-consolidated balance for each sub customer
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. Which 2 features need to be enabled? - Multiple Shipping Routes & Enable Line Item Shipping A company's corp policy requires re-approval for any changes made to approved sales orders prior to fulfillment. A SO was entered, approved, then changed but did not go back thru the approval process. Why? - The "Require re-approval"pref is not set A customer has multiple open SO's on file. A customer deposit is applied to the wrong sales order. What process to unlink? - Change the SO to a cash sale What are 2 considerations for shipping integration - Tracking numbers assigned on the fulfillment flow back to the SO, and Both FedEx and UPS support use of negotiated rates Which statement is true about enabling the Multi-Location Inventory feature? - The Enable Multi-Lccation Inventory feature can be enabled anytime after enabling the Inventory Feature An employee reports eight hours of consulting services for 3 days to the same customer. Which 2 invoicing prefs will produce an invoice within 24 hours of time at the billable rate? - Group Time by Employee, and Combine Time Items on Invoices A company sells yearly service contracts for $1,000 that require 10% initial fee. These are sometimes discounted. They bill at the end of the month. What's the settings - Initial Amount set to 10%, In Arrears is Enabled, Recurrence count is 12 Revenue Commitment - Allows recognition of revenue before invoicing VSOE - Allows auto-allocation of revenue across elements sold in a bundle Revenue Recognition Schedule - Shows list of Rev Rec JE to be generated Revenue Recognition Template - Allows definition of % of rev to be recognized up front With credit card integratino enabled, what happens when a standalone cas sale is saved - Authorize and charge/capture credit card Which statement is true about the default impact of receiving a customer return - Returned item is added to available inventory What impact does the manager commission sched have on the commissions a manager receives - Manager schedules calculate commission for Sales Managers based on the sales made by Sales Reps they manage, as well as the sales they make directly
Display "unassigned" in results if blank - IS NULL Display date by day of the week - TO_CHAR Compares 2 values, then returns specified paramenter if they match - DECODE Which setting on a saved search will email only the assigned Sales Rep - Recipient from results When buliding a saved search where "use expressions" is checked, which 2 requirements? - 1. Available Filter in the Filter region cannot be same as the Criteria, 2. Parenthesis must balance An Invoiced Saved Search needs to display the Items and Original quantities from the SO. Which join relationship - Created from fields A customer needs to report outgoing order information from several warehouse locations - Use a Saved Search using Summary functionality on the Results columns Which formula would require a custom search formula because it is not supported by a custom report formula? - (x+y)/40 (Supported includes: Percent Diff, Ratio, and Difference) Alternate Date Range options - Date What are 2 recommended practices when publishing dashboards - Label publishing roles to identy, Create separate publishing roles for each center Custom record to track customer satisfaction survey. What data will show in the Customer Center - none - Custom records cannot be linked to the Customer Center Enable Optimistic Locking - causes the system to check for conflicting updates when users attempt to save updates to a custom record instance Enable Inline Editing - allow records to be edited directly when they display as a LIST Enable System Notes - tracks all changes made to a record Allow Child Record Editing - allow records to be edited directly when they display as a SUBLIST A company uses a custom transaction body field to track informatino on SO's. The field should populate with the supervisor of the current user - Set a dynamic default of "Current User's Supervisor" on the Validation & Defaulting tab when setting up the custom transaction body field
Which statement is true about custom fields with a display type of disabled - A mandatory field cnanot be disabled unless the field has a default value T/F: A disabled field can display a default value - FALSE T/F: A disabled field is not available for transaction line (column) fields - FALSE T/F: If a field does not have a default, sourced, or custom information, it will not display on a form - FALSE Hide or disable the custom form field - Other users, like Admins, would not be able to switch out of this custom form Clear the Enabled checkbox for all other custom forms under Customize Role > Forms - Role could get access to other new custom forms Use the Restricted checkbox under Customize Role > Forms - This is the best method On the custom form, mark Preferred for the user's role - User still has access to other custom forms printed and email versions of a custom HTML form look different, explain - the transaction form is not using the layout they just created in the Print Template field What is the impact of using the "Filter Using" setting when creating a custom Trans Body field, beyond allowing the user to source data onto the transaction? - This field allows the dynamic filtering of the list/record field by a particular attribute There is an "in Transit" option for inventory during which time it is not counted as an asset for either subsidiary - FALSE what is the format of a custom field ID recommended by NS - custbody_[company identifier]_[field name] What is the impact of changing an Asset account on item records - 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 NS customer support - Bulk Transaction Delete, and Trigger a COGS recalculation which csv option should be selected when importing to track custom fields? - update and log system notes for custom fields
nexus - defines jurisdiction in which you collect & pay sales and/or purchase taxes; required component of Advanced tax functionaltiy tax control account - define tax types & contain GL postings of indirect taxes such as VAT and sales tax tax type - defines where the paid or collected tax is tracked on the balance sheet & used to define tax codes tax code - determines tha amount of tax applied to each line item on your transaction tax group - combines several tax codes that can then be applied to a transaction tax schedule - determines how NS calculates taxes for items within each nexus tax agency - defines a vendor record as the taxing authority to which taxes are paid on behalf of customers, from the tax code Year End Automatic Close - no JE required, closing the period per a normal close will finalize the year Year End Manual Close - manually post the year end journal entry to zero amounts in P&L and post to Retained Earnings consolidated exchange rates - 3 rates are maintained for each period-parent-subsidiary: current, average, historical consolidated exchange rates versus currency exchange rates - Consolidated applies to: consolidated reports, set per accounting period, base currency for one pair of related subsidieares, manually edited in the Consolidated Exchange Rates Table consolidated exchange rates versus currency exchange rates - Currency exchange rate applies to: transactions, "as of" effective date, base currency and one foreign currency, manually add new rows to Currency Exchange Rates each subsidiary has a base currency - subsids can manage & report their books in local currency - currency list must include the base currency of each subsid and any other currency in which transactions will be recorded -
use consolided exchange rates to translate transactions and balances between base currency & the currency you are reporting in (1 of the parent currencies) - normally the base currency is the local currency, but reporting that subsid in the context of the different parent, and then translate (using the consolidated rate) to report in the parent's currency - you can change the primary currency on a customer or vendor record, resets the default for transactions, credit limits, and aggregate balance - If primary currency is changed you must re- enter the credit limit, cannot remove any currencies which have transactions against them advanced inventory management - calculate reorder based on historical data; assumes demand is mostly constant; reordering based on reorder point may create excess inventory demand planning - order based on the expected demand demand planning calculation - based on: outstanding CRM data (opps, quotes, SO's, ), projection of historical demand; provides ability to use the sales history of another item for calculations service items - allow tracking of time & recording billable hours Assembly items - Members: non inventory & other charges; item price is INDEPENDENT of members; separate COGS, income from components; decrease asset accounts of member items and increase asset account of the assembly kit items - item price is INDEPENDENT of members; separate INCOME acct; decrease asset of components item groups - INDEPENDNT price; accounts specified on members; descrease asset of members; Only GROUPS allow you to change members on the fly on the transaction record inventory Items, assemblies, and service items - can all be members of Assemblies, Kits, and Item Groups adjust inventory transaction - inclusive of stock total; lot number and serialize are visible; if no cost then adustment has zero value and no GL impact adjust inventory worksheet - exclusive of previous stock total - resets the count to the quantity entered; uses average cost so it overrides FIFO/LIFO Advanced receiving - needed to be able to receive & bill pay separately Advanced shipping - needed to be able to fulfill & invoice separately
SuiteScript only examples - custom server requests from browser; create transactional records; sublist manipulation; redirect user to suitelet; udpate related records; copy print delete attach records; web services calls; scripted portlets suiteflow does not do anything with portlets - TRUE suiteanalytics - edit data from results; use as portlet; attach to a record as a sublist; dynamically obtain data suiteflow limitations that can be implemented with suitescript - accessing sublists; calling web services; updating other records; initiating a workflow on related records; designing complex business logic workflow triggers - client side - before user submit, before record submit workflow triggers - server side - scheduled, before record submit, after field edit, before user edit, after field sourcing, edit use external ids when importing: - 1. entities with parent/child relationships; 2. entities using auto-generated numbers; 3. external ids make it easier to import transactions and CRM records by avoiding use of EntityIDs 3 options for entering go-live AR & AP transactions - 1. customer/vendor > financial tab > opening balance; 2. import or manual recreation of fully detailed bill; 3. use a fake non- inventory item tagged to uncategorized account (preferred) 3 ways to enter go-live inventory count - 1.enter on hand count upon create; 2. adjust inventory; 3. adjust inventory worksheet inventory worksheet - csv importable; point in time inventory count adjust inventory - user interface; will not create a static number for go live; can be imported using suitetalk web services
