i am trying to do a saved search that returns the item sublist fields on an item receipt transaction in netsuite

AI generated answer (using internal Slack threads):

To create a saved search that returns the item sublist fields on an Item Receipt transaction in NetSuite, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. In the Criteria subtab, add the following filters: - Type is Item Receipt - Main Line is False (This ensures that the search returns line-level data, i.e., the item sublist fields) 4. In the Results subtab, add the columns you want to display in your search results. For example, you might want to include Item, Quantity, and Amount. If you want to display only the subitem name without the parent, you can use a formula field. Here's an example of a formula that extracts the subitem name from a concatenated string:

LTRIM(regexp_substr({item},'[^:]*$'))

. This formula uses regular expressions to find the part of the string after the colon, which is where the subitem name is located in a "parent : subitem" string. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******