Free NS-ERP sample questions

Correct answer: Create two separate custom Purchase Order forms: one for the 'Raw Materials - EU' subsidiary with the fields visible, and one for all other subsidiaries with the fields hidden. Assign these forms as preferred to roles restricted by subsidiary.

The most effective and maintainable solution is to use role-based form assignments. By creating two distinct forms and assigning them as the preferred form to roles specifically configured for different subsidiaries, you create a clean separation. The custom field's 'Display' subtab does not have a 'Subsidiary' filter; it can only filter based on other field values on the same record. Using a workflow would work but is more complex than necessary. Relying on user roles to set preferred forms is the standard NetSuite best practice for this common requirement.

Correct answer: License: $11,250; Service: $3,750

NetSuite ARM allocates the transaction price based on the relative standalone selling prices (SSPs). First, calculate the total SSP: $12,000 (License) + $4,000 (Service) = $16,000. Next, find the allocation percentage for each element: License = $12,000 / $16,000 = 75%; Service = $4,000 / $16,000 = 25%. Finally, apply these percentages to the actual transaction price of $15,000: License = $15,000 * 0.75 = $11,250; Service = $15,000 * 0.25 = $3,750.

Correct answer: Override Preferences

The 'Override Preferences' advanced option in CSV import allows the user to specify a posting period in the import file that is different from the period derived from the transaction date. This enables the consultant to map the transaction date to the historical date field while mapping the posting period to the current open period, satisfying both business requirements.

Correct answer: The cost of the additional 2 units is posted to a Production Quantity Variance account.

With Standard Costing, the assembly item is always valued at its pre-defined standard cost, which is based on the standard BOM quantity (10 units). Any deviation from this standard, such as consuming extra components, is captured in variance accounts. Since the difference is in the quantity of components used, the cost of the extra 2 units is expensed to the Production Quantity Variance account, highlighting the production inefficiency.

Correct answers: Use a Formula (Numeric) with the formula: {amount} > {createdfrom.amount}; Use a Formula (Text) with a CASE statement: CASE WHEN {amount} > {createdfrom.amount} THEN 'Y' ELSE 'N' END and set the condition to 'is Y'.

Correct answer: 1. Create Purchase Order. 2. Create Vendor Prepayment. 3. Receive Items. 4. Create Vendor Bill. 5. Apply Prepayment to Bill.

The standard NetSuite workflow for vendor prepayments is to first create the Purchase Order. Then, a Vendor Prepayment transaction is created and linked to that PO, which posts a debit to the prepayment asset account and a credit to cash. After receiving the items and entering the full Vendor Bill, the previously created prepayment is then applied to the bill, reducing the open A/P balance.

Correct answer: False

This is false. While the Administrator role has the necessary permissions by default, a custom role can be configured with the 'Period Closing Management' permission to allow non-administrators to execute the Period Close Checklist tasks. This is a best practice for segregation of duties.

Correct answer: Create three Price Levels (Gold, Silver, Bronze) with Quantity Pricing Schedules. Assign these Price Levels to customers. For key accounts, create item-specific Customer-Vendor pricing on the Customer record. For promotions, use the SuitePromotions feature.

This combination correctly uses NetSuite's hierarchical pricing logic. Price Levels with Quantity Pricing Schedules handle the tier and volume requirements. For key accounts, assigning item-specific pricing directly on the customer record (Customer-Vendor Pricing) is the standard method and will override the general Price Level. Finally, the SuitePromotions feature is designed to apply additional discounts (like the quarterly campaigns) on top of the calculated price, meeting all requirements without custom scripting.

Correct answer: The user's role does not have access to all the subsidiaries listed in the file.

The CSV import process runs using the permissions of the user initiating the import. If the user's role is restricted to a subset of subsidiaries, the system will not be able to find or validate the subsidiary references for those they cannot access, resulting in an 'Invalid reference key' error, even if the names are correct. The user must either use a role with access to all required subsidiaries or have the import performed by someone who does.

Correct answer: Use a Mass Update to change the 'Inactive' field to 'Yes' for the selected customers.

Mass Updates are the primary tool in NetSuite for making the same change to a large number of records simultaneously. The user can define criteria to select the legacy customers and then define an action to set the 'Inactive' field to true for all of them in a single operation. This is far more efficient than manual updates or a CSV re-import for a simple field change.