Handling Matrix items – Netsuite Saved Search

1. Create an item saved search that excludes parent matrix items and includes all other inventory types and child matrix items.

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

2. Under Criteria tab > Standard subtab, add the filter:

   • Matrix Item = False

3. Hit Save & Run.

This should exclude only the parent matrix item from the saved search result. Child matrix items and other inventory items will remain included.

2. Saved Search to Show Parent Matrix Items Only

Note: This Search can also be used for other item types aside from Assembly Items.

1. Click the Criteria tab,

• Type = is Assembly/Bill of Materials
• Matrix Item = is True
• Matrix Child Item = is False

2. Click the Results tab,

• Add Name and set the Summary Type to Group

3. Create an Item Saved Search that Excludes all Parent and Child Matrix Items

1. Navigate to Lists > Search > Saved Searches > New
2. Select Item as Search Type.
3. Under Criteria tab > Standard subtab, add the following filters:
   
   a. Matrix item = False
   b. Matrix Child Item = False
   
4. Under Results tab > Columns subtab, add/remove fields according to your preference.
5. Rename the search and click Save & Run.

4. Show Only Child Matrix Item Name in Results of Item Saved Search

When creating Item Saved Searches, the Name field displays the parent matrix item name before the matrix child, e.g. Parent Item : Matrix Child. User would like to display the Child Matrix Item Name only.

1. Navigate to Lists > Search > Saved Searches > New
2. Click Item
3. Search Title:Enter Title
4. On Criteria tab, mark Use Expressions checkbox

Add the following on fields:

Not	Parens	Filter	Description	Formula	Parens	And/Or
		Matrix Item	is true			Or
		Matrix Child Item	is true

    5. Click the Results tab
6. Click Column subtab
7. Field: Add Formula (Text)
Formula: Enter case when {parent} is null then {name} else {feedname} end

     8. Click on Add

     9. Click Save & Run