Share with colleagues and friends who could benefit from our webinars too!
In observance of Public Holidays and Oracle Mandatory Year-End break, our NetSuite Support Guru Team will be offline on December 25 to 29 and January 1, 2024.
The NetSuite Support Community site will be up and running on the dates mentioned above, and you may continue to post your questions and discussions. Our NetSuite Support Gurus will respond to unanswered questions posted during the holiday break once we resume normal operations on January 2, 2024.
We wish you a safe and enjoyable Holiday Season. We are grateful for your participation and contributions in the community, and we look forward to collaborating with you in 2024.
NetSuite Support Community Team
How to create saved search for system notes of field with most recent change only?
I have a custom field. I want to see the most recent change to this field on a search.
I have the date refined to today and am looking at the
System note date
I cannot use a summary search. The old and new value fields are numbers and none of the numerical functions work, using max shows the maximum which is not necessarily the required value, same problem with minimum, same problem with all the summary functions.
I am specifying the field in the criteria of the search, is there some function or formula I can apply there to make it show the most recent entry only?