Saved Search question, I need to get a count of how many Sales Orders someone edited, I can do that by pulling the system notes and looking for the Type that equals "Changed", but it gives me a sum of each of the changes in the system notes, So if a user changes 1 Sales Order, but changes 10 things on that Sales order, it gives me 10, but I only want 1 as the user only edited the 1 sales order. Any ideas?

Summary by record id + time of the change?

I'm sorry, I am not following you, are you saying do this in the Criteria or the Results, can you send me a screen shot?

Search on transaction Filter Type sales order Mainline as true System notes filter as per need. Results Group by System notes > user count internal id.

Here is where I am at right now, the Created works great, but the Change formula is the one that I am struggling with. @Edgar Valdes I tried what you suggested, but that really skewed the numbers, so I am thinking I may have not done it correctly,

Shouldn't it be a mainline search?

@Todd Juenemann The problem is: you are grouping by Set By, but you are not summarizing for Transaction ID also... You need the combination of User + Transaction to be unique and THEN sum or count the unique values

I tried your way, but it is giving super huge number, like one of my users edited 8,891 sales orders, which I know is not possible, It is counting all the times the system notes records a change, and on some sales orders, the system notes show multiple fields that got changed when the user edited the sales order, whether they actually did or not, which is normal behavior for us on Sales Orders as we have it recalculate item weights in case the qty on a line changes. So even if the user only goes in and edits the PO, the system still changes the DIMS fields.

In my example, the report gives me 31 summary changes for Credit Memo for a single user If I drill down the summarization it gives me 654 changes (multiple changes for the same 31 CM for the same user) I double check in Excel and the same 31 unique Credit Memos are there

That is weird, maybe I missed something, I will dig into more. I wish NetSuite would track when users Edit a record better.