Why does adding something like {custbody_my_purchaseorder_reference.status} cause two duplicate lines in the search results? This is a custom body field, not a line-level field, and the search is already filtered to Mainline=true

AI generated answer (using internal Slack threads):

The issue of seeing duplicate lines in the search results when adding a custom body field like

{custbody_my_purchaseorder_reference.status}

even when the search is filtered to

Mainline=true

is likely due to the way NetSuite handles joins in saved searches. When you join a custom field to fetch body-level fields from the source transaction, it might result in multiple lines in the search results. This is because the join operation is performed at the line level, even though it might seem like it's at the header level. In other words, even if the

Mainline=true

filter is applied, the join operation could still result in multiple lines in the search results if there are multiple line-level records associated with the same header-level record. To avoid this, you could try applying the

Mainline=true

filter on both the source transaction and the joined transaction. This might help ensure that the join operation is performed at the header level, thereby preventing the appearance of duplicate lines in the search 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. ******