saved searches for credit memos keep duplicating line items, why is this ?

AI generated answer (using internal Slack threads):

The duplication of line items in saved searches for credit memos can occur due to several reasons: 1. Joins: If you are using joins in your results, it can create duplication. For example, if you have two payments applied to those invoices, it will create duplicates in your saved search. 2. Lack of Main Line Criteria: If you don't define the "Main Line" criteria in your search, your result will have duplicate lines. 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 default). 3. Custom Transaction Records: If you are using custom transaction records, there can be intermittent return of doubled values. This can occur due to a glitch in NetSuite and may not be related to user behavior. 4. Multiple Line Items: If the same line item is listed twice on the sales order, it will appear as a duplicate in the saved search. To avoid these duplications, you can try the following: - Set 'Tax Line = false' and 'Shipping Line = false'. - Use 'System note..type' and select 'create'. - Set 'account type = income' to remove most of the duplicates. - Add 'cogs line false' to your criteria. - If you are joining to the Payment related to the invoice in your results, like with applying transaction joins, try to avoid it as it can create duplicates. - You can also try to create a summary search and use distinct for sum amount. Remember, these are general suggestions and the exact solution may vary depending on your specific criteria and 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. ******