Why would a saved search show one number on results (say 50), when printed as csv also show 50, but when emailed with results as a csv, it shows a multiple of the 50 (100, 150)? The column in question is in an item saved search: (Summary Type: Sum)

{transaction.quantity} - {transaction.quantityshiprecv}

I even tried Summary Type: Maximum with:

SUM({transaction.quantity} - {transaction.quantityshiprecv})

Have you found a solution to this? Here's my thought, the discrepancy you're encountering might be due to the 'Summary Type' setting in your saved search. When you set the 'Summary Type' to 'Sum', NetSuite sums up all the records that have the same characteristics. However, when you email the results as a CSV, the 'Summary Type' setting may not apply, and thus each individual record is listed separately, causing the total quantity to be a multiple of the original amount. A potential solution would be to adjust your saved search to not use summary fields, but instead use a formula field to calculate the difference between {transaction.quantity} and {transaction.quantityshiprecv} on each line. This should provide consistent results across different output methods (on-screen, CSV, email, etc.).

I actually did figure it out. It turns out someone had a "Recipient from Results" filled out with "Vendor", so 2 things were happening: 1. It was multiplying the quantity by the number of vendors associated with each item 2. It was sending the email to all associated vendors