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.
I came across this article in SuiteAnswers: https://netsuite.custhelp.com/app/answers/detail/a_id/79769/kw/assign%20record%20to%20inactive%20user
The article references .csv uploads and the need to mark the users "Active", then upload the file, and then switch them back to "Inactive". This is not an option through the Boomi process, or it would require an enormous and unstable workaround to check if a sales rep is inactive, change the user record to "Active", run the insert/update operation, and then change the user record back to "Inactive".
My questions are:
1) Is there a way to insert/update records that contain an inactive user?
2) If not, what is the best practice for this situation?