is there any sql command that pulls the last system notes date for a transaction. I used the function maximum on date but then I have to gourp all other fields to see them on the summary results

Not sure what the exact issue is, you don't normally use a summary function on one column and not the others if you want to see them.

sometimes in the results you can do a formula and show max({field}) but as @Sandii says, without knowing your goal…

Tried doing the max/* comment */({field}) over.. partion by... Trick?

Isn’t this similar to the “Order By” column of search results?

@Netsuite Tragic, yes it is. But you don't have to use a summary search. No columns needs to be sum/group/max/...