Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Create/Update records with values that are "Inactive"
I am trying to perform an insert/update operation on Customer records, and running into an error when the "Sales Rep" assigned to the Customer record is inactive. We have many sales reps that have left the company, and we mark their employee records as "Inactive" when they leave. We want to keep historical data, and leave the inactive users as the sales reps on the Customer record - reassigning to an active sales rep is not an option.
The insert/update operation is performed through Dell Boomi, an integration software. I believe it uses ODBC/JDBC and not the API.
0