Hello all! I'm running a transaction search from the 'View All Transactions' action on an Inventory Item (raw material). I've filtered the results to only show Work Orders, but I'm having trouble getting the assembly item from the WO to pull through to the results. On standard transaction saved searches the 'Item' field has the assembly item. But since I initiated this search from the inventory item it's filtered to that item by default and I can't find another field for the assembly. Any ideas how to access the assembly Item of the parent/WO record? Is there a way to iterate to the parent record with a custom formula and get the assembly item from that? Thanks in advance.

Have you built this search yet in the UI? You can use this "NetSuite: Search Export" chrome extension to export to suitescript

Yea, I created a saved search from the transaction search. What is the benefit of running the search from script? I normally run all my searches through the UI

the assembly item is only at the main line of the transaction