how to obtain from a saved search the line id of t...
# ask-stanley-ai
r
how to obtain from a saved search the line id of the components of a kit on a sales order?
c
AI generated answer (using internal Slack threads):
To obtain the line id of the components of a kit on a sales order from a saved search, you would need to use the line id as a search column and a sublist field. However, it's important to note that this might not work for kit items due to the way they are structured in NetSuite. For viewing kit component items on a sales order, you would need to check the "DISPLAY COMPONENTS ON TRANSACTIONS" field on the Item Record, Components tab. However, this checkbox is applicable for print tickets and not for original forms. Even with this checkbox checked, kit components might not be visible or iterable when loading the sales order record. As for creating a saved search that shows the Kit and its respective components with price, it might not be possible to do exactly as described due to the single-join limitation in a transaction search. A possible workaround could be to start with an Item search and then reach to the member items and to the transactions to get what you want. Alternatively, you could use the SuiteAnalytics Workbook, which doesn't have the single join limitation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848088443
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83574003
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834269226
Please provide your feedback on this answer.