what is the formula(text) that will return items o...
# suitescriptj
Janiece
11/10/2021, 6:01 PMwhat is the formula(text) that will return items on a fulfillment record line in a saved search?
Janiece
11/10/2021, 6:02 PMI tired
{item}{itemname}e
eblackey
11/10/2021, 6:56 PMare you wanting a concatenated list of all of the items on an item fulfillment record?
j
Janiece
11/10/2021, 7:45 PMyes! but its for a fulfillment request record @eblackey
e
eblackey
11/10/2021, 7:54 PMI know the fulfillment request record is a bit different from item fulfillment. but this might work. If you do a summary search and use the NS_CONCAT (won’t be in the function list) function you can get a concatenated list of items.
eblackey
11/10/2021, 7:56 PMThis is what it will look like on the results tab…
j
Janiece
11/10/2021, 11:14 PMThat did not work for me
Janiece
11/10/2021, 11:14 PMthis is the saved search I want to add it to:
Janiece
11/10/2021, 11:15 PMso I essentially want a column relating to the iterm(s) that are attached to the fulfillment request
Janiece
11/11/2021, 1:49 AM@eblackey thank you for your input, do you think what I want to do is possible?
Janiece
11/11/2021, 2:53 AM@Ross Kennedy
e
eblackey
11/11/2021, 1:18 PMAll of the those columns would need to be summary of GROUP and the new column with the formula above would need to be set to summary of MINIMUM. Can you share a screenshot of the Results tab.
n
Netsuite Tragic
11/12/2021, 7:38 AMIs it also Mainline = F?
3 Views