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 questions
Answer options
A: Ensure that the item form is not set to Inactive when performing the import.
B: Ensure that member items values are greater than 1 in the Quantity field.
C: Review the mapping so that linked columns match correctly in the import. Correct answer
D: Review Data Handling options and ensure that it is set to Update.
Correct Answer:
C. Review the mapping so that linked columns match correctly in the import.
Explanation

The 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.

Why Incorrect

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.

References

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.

Scroll to Top