“In NetSuite, when filtering a saved search by Line Status = 1, why does it return multiple lines instead of one per transaction line?

AI generated answer (using internal Slack threads):

In NetSuite, when filtering a saved search by Line Status = 1, it may return multiple lines instead of one per transaction line due to the way NetSuite handles transaction lines. Each transaction in NetSuite can have multiple lines, including item lines, tax lines, shipping lines, etc. When you filter by Line Status = 1, it doesn't necessarily mean it will return only one line per transaction. It will return all lines that meet the criteria, which can be more than one line per transaction. For example, if a Sales Order has multiple item lines, a tax line, and a shipping line, and all these lines meet the criteria of Line Status = 1, then all these lines will be returned in the search result, not just one line per Sales Order. This is why you might see more lines in the search result than the actual number of transactions. If you want to return only one line per transaction, you might need to adjust your search criteria or use grouping or summarizing features in the saved search. For example, you can group by transaction ID or use a summary type like 'Group' or 'Count' to consolidate the lines per transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******