I have a large issue that you can read about here for further context:
Matrix items have lost their connection to matrix options list. Urgent — NetSuite Community
Essentially, I'm trying to make a saved search so that the only items which have a colour variant and do in fact have colour options assigned to them will appear as options for my transactions.
As examples, on the left is a broken item, it has lost its matrix options and cannot be used at this time. The record can in no way be updated to add new fields or information for further filtering.
On the right is a working item, it still has its colour variants listed and can be interacted with without error.
I was hoping to create a saved search that filters out any items where Matrix Item Name Template (matrixitemnametemplate) contains '{custitem_matrix_colour}' and Colour {custitem_matrix_colour} is also empty. But saved search is telling me that matrixitemnametemplate is an unrecognized field (custitem_matrix_colour does work).
CASE WHEN {matrixitemnametemplate} IS NOT NULL THEN 'Valid' ELSE 'Invalid' END
CASE WHEN INSTR({matrixitemnametemplate}, '{itemid}-{custitem_matrix_colour}') > 0 AND NVL({custitem_matrix_colour}, '') = '' THEN 1 ELSE 0 END
Either of the above return unrecognized.
I have also tried to use itemoptions as that looks like a suitable field when viewing the record in xml, but that is also unrecognized field to a saved search.
Is there a reason that matrixitemnametemplate is unrecognized or does anyone have a suggestion on how I could otherwise perform this check?
I am in desperate need of help here, so all suggestions on what I could try are welcome.