In an item saved search, how can I show the member item linenumber field?

AI generated answer (using internal Slack threads):

In order to show the member item linenumber field in an item saved search, you would need to use a formula field. However, it's important to note that NetSuite's Saved Search functionality only allows for one join, and getting the member item linenumber would require two joins, which is not directly supported. Here's a workaround that might help: 1. Create a new Formula (Text) field in your saved search. 2. In the formula field, use the

{item.memberitem}

syntax to reference the member item. This will return the member item's internal ID. 3. Unfortunately, there's no direct way to get the linenumber from this, as it would require a second join which is not supported in saved searches. Please note that this is a limitation of NetSuite's Saved Search functionality and there's no direct way to achieve this. You might need to consider other options such as SuiteScript or SuiteAnalytics Workbook if you need to get this information frequently or in a more automated way. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******