Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Trying to identify new customers -date created field and merging
We frequently get duplicate customer records (mainly because the website allows people to register as a new customer with an already existing email address, but that’s the topic of other threads…)
We want to keep the most recent record when merging the duplicate records because it makes sense that that record would have the most up to date information. However, using the most recent record as the Master creates the following problem:
The Date Created of the merged record becomes the date that the latest record was created. We want it to be the date that the oldest record is created. Anyway to do this and still have the other fields have the data from the most recent record? Date Created does not seem to be an editable field. Having the Date Created equal the newest record instead of the oldest duplicate record creates problems when we run reports such as “New Customers this month” , where we use Date Created to determine the “new customers”.