NetSuite ERP Consultant Exam Latest
2023-2024 Exam 200+ Questions And
Verified Answers|Already graded A
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
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 - 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? -
ANSWER- Only administrators have access to the 'Reject' Proposal' button
1
,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
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? - 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? - ANSWER-
Must 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
2. Charge/capture (upon fulfillment)
Customer center vs. Account center - ANSWER- 1. Customer center - a role,
accessible from netsuite.com
2. My Account - only available from the eCommerce site
Review the SQL functions - 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
2
, 4. 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?
1. Hidden
2. Normal
3. Inline
4. Disabled - 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? - ANSWER- 1. Inline
2. Suitescript
3. Delete all data
4. 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 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? - ANSWER- 1. Standalone invoice
2. Item fulfillment
How to prevent returned items from being added back into inventory? - ANSWER-
1. Clear re-stock option on item record
2. Enter write-off account on item return record
How to view records without NS login? - ANSWER- File cabinet - 'Make all Files
available without Login'
3
2023-2024 Exam 200+ Questions And
Verified Answers|Already graded A
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
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 - 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? -
ANSWER- Only administrators have access to the 'Reject' Proposal' button
1
,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
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? - 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? - ANSWER-
Must 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
2. Charge/capture (upon fulfillment)
Customer center vs. Account center - ANSWER- 1. Customer center - a role,
accessible from netsuite.com
2. My Account - only available from the eCommerce site
Review the SQL functions - 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
2
, 4. 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?
1. Hidden
2. Normal
3. Inline
4. Disabled - 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? - ANSWER- 1. Inline
2. Suitescript
3. Delete all data
4. 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 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? - ANSWER- 1. Standalone invoice
2. Item fulfillment
How to prevent returned items from being added back into inventory? - ANSWER-
1. Clear re-stock option on item record
2. Enter write-off account on item return record
How to view records without NS login? - ANSWER- File cabinet - 'Make all Files
available without Login'
3
