Hi, how to check the current item is matrix parent or matrix child or regular inventory item use N/search. the matrix/matrix child column is not available, https://1117015.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_2/script/record/item.html

message has been deleted

Should be more clear, I meant in search columns in scritp, I am very often getting "_An nlobjSearchColumn contains an invalid column join ID, or is not in proper syntax: matrix_" apparently matrix is not listed in search column, so wondering if there other way

the standard technique for searches it to build it in the ui first

thanks for the tip. I thought matrix was standard search column for suitescript, but not any more obviously

it is a column, but as your error message suggests, its not a join

var inventoryColumns = [

                

'type',

                

'itemid',

                

'internalid',

                

'_*matrix*_',

                

'locationquantityavailable',

                

'inventorylocation',

                

'custitem_cubic_charge_weight',

                

'custitem_ps_disable_sd_delivery',

                

'custitem_cubic_carrier',

                

'custitem_cubic_carrier_express',

                

'custitem_cubic_carrier_mult',

                

'custitem_cubic_charge_weight',

                

'custitem_avt_total_length',

                

'custitem_avt_total_width',

                

'custitem_avt_total_height',

                

'weight',

                

'custitem_avt_total_packages',

                

'custitem_avt_ifs_cubic_volume',

                

'custitem_stockoverride',

                

'custitem_assemblyhours',

_*{'name': 'matrix', join: 'parent'}*_

            

]

Join id is 'parent', isn't it?

same answer as before, do whatever the search in the ui does