How do I prevent netsuite from splitting out saved search results into mulitple lines when joining on a transaction body field?

AI generated answer (using internal Slack threads):

To prevent NetSuite from splitting out saved search results into multiple lines when joining on a transaction body field, you need to set the "Main Line" criteria in your search. If you only want the main line (header) then select "Yes", "No" for all the other transaction lines minus main line and "Either" for all lines (which is the default). However, if you are dealing with Journal Entries (JEs), the "Main Line" criteria might not be useful. In this case, you can set "Main Line" to "No" and group the results for all the columns in the results tab. To do this, click on the "Summary Type" and select "Group". Please note that these solutions are based on the assumption that you are dealing with standard transaction types. If you are dealing with custom transaction types and still experiencing issues, it might be a NetSuite issue and you might need to further investigate. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******