Show kit components on sales order transaction saved search

AI generated answer (using internal Slack threads):

To show kit components on a sales order transaction saved search, you need to create a saved search of the type transaction/sales order that shows the Kit and its respective components with price. However, starting with a transaction search might run you into the single-join limitation. A possible workaround is to start with an Item search and then reach to the member items and to the transactions to get what you want. Alternatively, you can use the SuiteAnalytics Workbook, which doesn't have the single join limitation. If you want to display all items on sales orders but only show the Member Items of a Kit/Package, rather than the Kit/Package itself, you can use a formula in your search results. The formula would look something like this:

CASE WHEN {itemtype} = 'Kit' THEN {item.memberitem} ELSE {item} END

. This formula will show the Member Items of Kits, Assemblies, and Inventory Items. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******