Why does adding something like {custbody_my_purchaseorder_reference.status} cause two duplicate lines in the search results?

AI generated answer (using internal Slack threads):

The issue of duplicate lines appearing in the search results when adding something like

{custbody_my_purchaseorder_reference.status}

is likely due to the way NetSuite handles line-level fields in saved searches. When you include a line-level field in your search results, NetSuite will return a separate result row for each line of the transaction that has a value for that field. This is because NetSuite treats each line of a transaction as a separate record in the context of the search. So, if you have a transaction with multiple lines and each line has a value for

{custbody_my_purchaseorder_reference.status}

, then each of those lines will appear as a separate result in your search, causing what appears to be duplicate results. To avoid this, you can adjust your search criteria to only include the main line of the transaction. This can be done by setting the "Main Line" criteria to "True". This will ensure that only the main line of the transaction is included in the search results, effectively eliminating the duplicate lines. However, please note that this will also exclude any line-level information from the search results. If you need to include line-level information in your search results, you may need to consider a different approach, such as creating a separate search for the line-level information and then combining the results with your main search. Remember to always test your saved searches thoroughly to ensure they are returning the expected results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******