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.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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