Changing NetSuite Contact Owner when Marked Private

This article is relevant if you are a NetSuite administrator and you are seeking to clean up contact records.

Background

One of our clients was having trouble with updating NeSuite contact records that were marked Private. The client was unable to edit the Contact.  When they tried, NetSuite offered a warning that you can’t edit records that are private. When they tried to edit the Private field, it effectively was disabled (we tried using script and received the same error messages).

It turns out that the field was marked Private a while back when the client was using NetSuite’s Outlook Integration.  Microsoft Outlook has a Private field function that was synchronized with NetSuite.  The private field value can only be changed by the owner of the record.  The owner of the record is one that created the contact.

How to Update NetSuite Contacts Marked Private

Here is what we had to do to solve this issue:

  1. Identify the record owner.   In our case, it was one employee that was no longer with the company.
  2. We exported all the contacts to CSV file that were marked private with the Contact internalid.
  3. We then reactivated the employee record and temporarily gave system access as Administrator.
  4. We logged back into NetSuite as the reactivated employee (as an Administrator) and then performed a CSV import of the file we just exported.
  5. On the CSV import map, we set the field “Is Private” to No.
  6. We imported all the records which marked “Is Private” to No.
Once that set of work was complete, the records are no longer private and now you can use NetSuite’s built-in mechanism to Change Contact Owner via a Mass Update.

Take Control of NetSuite

Get good help around you for taking care of NetSuite.  Contact us if you are looking for assistance.
Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to setup a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Tags: , , , | Category: CRM, NetSuite | Leave a comment

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>