Updating Matrix Throws a Notice: "The following matrix subitems exist but aren't included in the options ..."

Scenario

When trying to update a Matrix Item through the Update Matrix function on the Parent Matrix, users may encounter the following error:

"The following matrix subitems exist but aren't included in the options you just specified. On the Matrix tab, please make sure the options you select include all existing subitems."

This happens when there's a Child Matrix Item that has a Matrix Option that is not selected on the Parent Matrix.

Solution

This can be solved by adding the Matrix Options on the Parent that was already on the Child Matrix.

I. Create Saved Search to look for the missing values

        1. Navigate to Lists > Search > Saved Searches > New 

 2. Select Item

3. Mark Use Expressions checkbox 

4. Filter:

Note: For every required filter stated in the below substeps, use the dropdown menu to select it.

1. Select Name (Internal)
1. Set: Enter Name of the Parent Item 
2. And/Or: Select Or

2. Select Sub-Item Of 

5. Click Results

 6. Field:

Note: Always click Add, once Field is selected and adjust as needed.

6. Save and Run

7. Note the results of the Search

II. Create a CSV file similar columns as shown in the example below:

III. Import the CSV file:

1. Navigate to: Setup > Import/Export > Import CSV Records

2. Set the following: 

1. Import Type: Select Items

2. Record Type: Select Item Type

3. Select one file to upload, and upload the CSV file

4. Click Next

5. Import Options: Select Update

6. Click Next

7. Under the first File Mapping page, map the respective fields on the File to NetSuite Fields

Example:

8. Click Next

9. Run the import

Once the Import is done, check the saved search or the Parent Matrix Item record to see if the options are now added. Once the Matrix Options are added, users may now proceed to use the Update Matrix function.