ERP-CONSULTANT practice question 2 of 15
An inventory manager is trying to upload assembly items for the first time using the Multiple Files to Upload preference; however, they keep getting the error “Please Select member items before submitting.” How might the inventory manager troubleshoot the error?
Full set: 80 questionsThe error message, "Please Select member items before submitting," specifically indicates that the NetSuite import process cannot associate the member items with their parent assembly item. When using the "Multiple Files to Upload" feature for assembly items, one file contains the parent assembly data, and a second file contains the member item sublist data. The system relies on a "linked column" (such as Item Name/Number or External ID) that must be present and correctly mapped in both files to establish this parent-child relationship. An error in this mapping is the direct cause of the system being unable to "select" or link the members to the assembly.
A. Ensure that the item form is not set to Inactive when performing the import. An inactive form would likely prevent the creation of the item record itself, resulting in a different error, not a specific error about a sublist.
B. Ensure that member items values are greater than 1 in the Quantity field. The quantity of a member item can validly be 1 or even a fraction. The error is about the system's inability to identify the member items, not the quantity being used.
D. Review Data Handling options and ensure that it is set to Update. The scenario describes a "first time" upload, which implies creating new records. The "Update" option is for existing records; using it would cause a "record not found" error, not an issue with member items.
1. NetSuite Help Center, SuiteAnswers ID: 10089 - CSV Imports of Assembly Items and Their Members. This document outlines the two-file import process for assembly items. It states, "The key is to have a column in both files that can be used to link them together. This can be the Item Name/Number or the External ID." This directly supports that a mapping issue with the linked column is the root cause.
2. NetSuite Help Center, Topic: Item Sublist Data Import. This section explains the general principle for importing sublist data via CSV. It specifies: "For imports that add or update sublist data for existing records, you must map a column from your CSV file to a body field on the NetSuite record that can serve as a unique identifier... This mapping links the sublist data to the appropriate record." This confirms the critical role of correct mapping for linked columns.
Keep practicing
Take the free ERP-CONSULTANT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ERP-CONSULTANT practice questions
- Question 1What is the maximum number of Quantity-based Price Levels a user can set up in NetSuite?
- Question 3Which fields on a Customer record should a user set up to use Electronic Funds Transfer (…
- Question 4A company is using the Multiple Currencies feature. Which account type allows Revalue Ope…
- Question 5A company purchased and received 100 chairs for a conference room. Four of the chairs wer…
- Question 6What feature enables a user to create Billing Schedules in order to invoice sales over a …
- Question 7Which statement is true about Drop Ship and Special Order items?
