Copying matrix item and setting the value of a multiselect field
I’m using record.copy to copy an existing matrix item to create a new record and update a couple of fields with values for the newly copied record. The matrix item has a custom field that’s multiselect type representing length.
I can’t figure out how to set the value of the new record to get it to save properly. I keep getting an error of this type:
Invalid item option custitem_size for item xxxx
My code is:
You are better off creating your own matrix item rather than trying to copy another. Matrix items have some non-standard fields that need to be set.
Checkout the SuiteAnswer article at: https://netsuite.custhelp.com/app/answers/detail/a_id/38898
Thanks battk. I’m trying to use record.copy since most of the data from the source record (which is already a child record) is the same on the new matrix record with the exception of length or size which is represented by the custom field.
Since I could not get it to work, I finally used record.create ad populated the fields I needed and the only time it worked to save the record is when I included a value in externalid because previous attempts were unsuccessful (hence the need to try record.copy) as I was getting a DUP_ITEM error message every single time I tried creating and then saving the record.