SunShine
01/27/2025, 3:15 PMCeligo AI
01/27/2025, 3:15 PMAI generated answer (using internal Slack threads):To know the columns of an inventory item in a search, you can use the NetSuite UI to create a search and then load it in a script to examine the columns and filters. This will allow you to recreate it yourself in SuiteScript. Here is an example of how you can define the columns for an inventory item search in SuiteScript:
javascript
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'}
]
In this example, 'matrix' is a column and its join id is 'parent'. Please note that the 'matrix' column is not a join, and you should use the same approach as the search in the UI does.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/27/2025, 3:16 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.86372143
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852907658
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848113775
Celigo AI
01/27/2025, 3:16 PM