Creating Saved Searches Based on a Merchandise Hierarchy

The Merchandise Hierarchy Node field can be utilized in saved searches to provide useful filtering capabilities.

Hierarchy node filters can be applied to the following:

For more information regarding saved searches, see the help topic Saved Searches.

Using the Hierarchy Node Field in Item Saved Searches

Item saved searches are useful in NetSuite when you need to apply filters to lists of items, such as when you want to limit the eligibility of a promotion to a specific group of items. You can use a merchandise hierarchy node as a filter in such saved searches, creating a search that only lists items assigned to a specific node.

For example, you can create a saved search that lists all the items assigned to a node for women’s jackets. You can then create a promotion that can only be applied to the women’s jackets assigned to that node.

For more information on using saved searches in promotions, see Promotions.

To create an item saved search based on a hierarchy node:

  1. Go to Lists > Search > Saved Searches > New (Administrator)

  2. In the Search Type list click Item.

  3. Enter a name for the search in the Search Title field.

  4. In the Criteria subtab, on the Standard subtab, select Hierarchy Node in the Filter list.

  5. In the Saved Item Search popup window select the hierarchy node or nodes that you want to filter on.

  6. Click Set.

  7. Click Preview to see the search results, or click Save to create the saved search.

Using the Hierarchy Node Field in Transaction Saved Searches

Transaction saved searches are useful in NetSuite when you want to examine transactions for specific inventory items. You can use a merchandise hierarchy node as a filter in such saved searches, creating a search that only lists transactions involving items assigned to a specific node.

To create an transaction saved search based on a hierarchy node:

  1. Go to Lists > Search > Saved Searches > New (Administrator)

  2. In the Search Type list click Transaction.

  3. Enter a name for the search in the Search Title field.

  4. In the Criteria subtab, on the Standard subtab, select Item Fields... in the Filter list.

  5. In the Saved Transaction Search popup window select the hierarchy level that contains the node or nodes that you want to filter on. If you have prefixed the name of the hierarchy levels with [MH] it is easier to locate them in the list.

  6. Select the hierarchy node or nodes that you want to filter on.

  7. Click Set.

  8. Click Preview to see the search results, or click Save to create the saved search.