Item Range Function (FSN.Range.Items)
Item Range Function (FSN.Range.Items)
Description
The Range > Item function, also available by typing FSN.Range.Items(), makes it easy for users to return a list of items based on the function arguments.
Function Arguments
| Argument Name | Input Information | Required | Default Value |
|---|---|---|---|
| Include Filter | Specifies the items to include. Multiple values can be specified by another dynamic array (e.g., using a named range, specifying a range of cells like E1:E10, etc) or concatenated as a string using the ^ character. Additionally, if the values are numeric wildcards and range values can be used such as 100-200, 10*, or 1*-20?0. | No | Include all items |
| Exclude Filter | Specifies the items to exclude. Values can be specified as they are in the Include Filter | No | Exclude none |
| Subsidiary | Specifies the subsidiary to use to determine the items to return. Only items that are valid for the subsidiary are returned. | No | Does not filter by subsidiary |
| Include Blank | Determines whether or not to include the <No Item> explicit blank value in the list | No | TRUE |
| Level | Specifies the maximum level of the hierarchy to return. A value of 2 will return all levels <= 2 | No | Includes all levels |
| Include Inactive | Specifies whether or not to return items marked as IsInactive=T in NetSuite | FALSE (Excludes inactive) | |
| Include Rollup | Include rollup value (Hierarchy) for values with children | TRUE (parent rollup Hierarchy values are returned) | |
| Rollup Only | If TRUE, then only top-level rollup values are returned | No | FALSE |
| Horizontal | Controls whether the returned dynamic array spills vertically or horizontally. This values is useful when creating reports based on items, where values are specified in a single row across the sheet. | No | FALSE (returns a vertical list) |
| Rollup First | When TRUE, returns the rollup (Hierarchy) values before the children. When false, the rollup value is returned after the children | No | TRUE (Rollup value is returned first) |
Remarks
- Review the Function filter syntax for selecting ranges as needed.
- #SPILL! may appear in the array function cell when the resulting array determined by your parameters will not fit in the provided Excel area.
Example
Let's say you wanted to return all Carbide Mill item sizes. You know that for Carbide Mill items, they all start with IIR on their item number.
- Select Functions > Range > Items
- Type in IIR* under Include Filter and select OK
- View the results to see the distinct list of Items in this category
- From here, easily use a GetListInfo function to return the Display Name for each item number as well
