NetSuite ERP Consultant Exam Latest
2023-2024 Exam 200 Questions And
Correct Answers(Verified
Answers)|Agrade
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) –
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) – 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) –
ANSWER- Address Verification (AVS), Card Verification Value (CVV)
Which can be shared across subsidiaries? (Vendors, Customers, Warehouse
Location, Bins, Items, etc.) – ANSWER- GL Accounts, Tax Nexuses, Vendors,
Customers, Warehouse Location, Bins, Items
What is the email hierarchy for saved searches? – ANSWER- 1. Specific
Recipients
- ‘Recipients from results’ tab sends emails to specific recipients baed on search
filters - Targeting recipients based on search filters (alternate)
Fixed Asset record – ANSWER- 1. Include in Reports checkbox to include asset
type in Asset Summary Report – all assets are included in the report by default - You can set asset depreciation parameters on the asset record
If ‘Restrict Ability to Reject Proposals’ is selected, what is the outcome? –
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? – 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? – ANSWER- 1. Inventory Adjustment – Manual & Web
Services
- Inclusive of previous stock count, maintains LIFO & FIFO costing
- 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? – 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? - ANSWER- Subsidiary
Conditions for accepting consolidated payments for child customers? – ANSWERMust be same currency & same subsidiary
On which record do you enter tracking number, if you are NOT using a shipping
integration? – ANSWER- Item fulfillment record
What happens when there is a credit card on a sales order? – ANSWER- 1.
Authorize
- Charge/capture (upon fulfillment)
Customer center vs. Account center – ANSWER- 1. Customer center – a role,
accessible from netsuite.com - My Account – only available from the eCommerce site
Review the SQL functions – ANSWER- 1. CASE – Returns values based on
different conditions - DECODE – Compares each expression to each search value 1 by 1 – IF
expression = x, result is returned, IF not, default is returned - ISNULL – Replaces Null with another value
- NULLIF – If two expressions are equal, then null is returned
Which edition doesn’t calculate tax out of the box? – ANSWER- United States
Which field type to use for which scenario?
- Hidden
- Normal
- Inline
- Disabled – ANSWER- 1. Hidden – field cannot be seen on the record or
transaction - Normal – field can be edited
- Inline – used for informational purposes – cannot be edited
- Disabled – field cannot be edited
How to delete data in bulk? – ANSWER- 1. Inline - Suitescript
- Delete all data
- CSV import
How to restrict a role to a custom form? – ANSWER- 1. Hide or disable custom
form field – other users would not be able to switch out of this custom form - Clear the enabled checkbox for all other forms under Customize Role > Forms –
Role could get access to 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 can still access
other forms
What causes posting to COGS? – ANSWER- 1. Standalone invoice - Item fulfillment
How to prevent returned items from being added back into inventory? – ANSWER1. Clear re-stock option on item record - Enter write-off account on item return record
How to view records without NS login? – ANSWER- File cabinet – ‘Make all Files
available without Login’
Which transaction records are posting? – ANSWER- 1. Invoice - Vendor Bill
- Cash Sale