why does my saved searches show multiple lines on my invoice when there isnt that many

AI generated answer (using internal Slack threads):

The issue of seeing multiple lines on your invoice in your saved search, even when there aren't that many, could be due to several reasons. 1. Main Line Criteria: If you have set the "Main Line" criteria to false, it will show all the lines associated with the transaction, including tax lines, shipping lines, and item lines. If you want to see only the main transaction line, you should set "Main Line" to true. However, if you need line detail, you should set "Main Line" to false and add additional criteria to filter out unwanted lines. For example, you can set "Tax Line = false" and "Shipping Line = false" to exclude tax and shipping lines. 2. Joins: If you are using joins in your saved search, it can create duplicate lines. This is because joins can result in a Cartesian product, where each row from the first table is combined with each row from the second table. If you have multiple payments applied to an invoice, it can result in duplicate invoice lines in your saved search. 3. Grouping: If you are grouping data in your saved search, it can also cause multiple lines to appear for a single invoice. This is because each group is treated as a separate line in the saved search. 4. Summary Searches: If you are using a summary search, the line count in the UI might not be correct, especially if a lot of data is grouped. To resolve the issue, you might need to adjust your search criteria or use a summary search with distinct for sum amount. If the issue is caused by a specific field, such as the "paying transaction:memo" field, you can try converting it into a text formula field to remove the duplicates. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******