I am adding an item group via a scripted search. H...
# suitescriptp
pen one
02/04/2021, 12:38 AMI am adding an item group via a scripted search. How can I have the order the items are imported in match the order in the item group?
b
battk
02/04/2021, 12:56 AMprobably depends on what you are doing with the search
battk
02/04/2021, 12:57 AMi think the obvious choice of a item search with a member item column automatically has the member items in the correct order in the default sort
battk
02/04/2021, 12:58 AMthough i personally wonder why not straight up use the item group in the first place
p
pen one
02/04/2021, 1:43 AMReason is I need to do some additional scripting when the item list loads. The quantity field is populated from a main line field. If I add the item group from the UI the script does not trigger and per netsuite this is standard.
I have no sort in my search and it appears to be adding the items by internal I'd
b
battk
02/04/2021, 1:46 AMWhat are your filters and columns
p
pen one
02/04/2021, 2:04 AM Copy code
filters:
[
["type","anyof","Group"],
"AND",
["internalid","anyof","1157"]
],
columns:
[
search.createColumn({
name: "itemid",
label: "Name"
}),
search.createColumn({
name: "internalid",
join: "memberItem",
label: "Name"
}),
search.createColumn({
name: "vendorpricecurrency",
join: "memberItem",
label: "Vendor Price Currency"
}),
search.createColumn({
name: "baseprice",
join: "memberItem",
label: "Base Price"
}),
search.createColumn({
name: "saleunit",
join: "memberItem",
label: "Primary Sale Unit"
}),
search.createColumn({
name: "minimumquantity",
join: "memberItem",
label: "Minimum Quantity"
})
]b
battk
02/04/2021, 2:12 AMyou can force the sort by adding the member line column
battk
02/04/2021, 2:12 AMand sorting by it
p
pen one
02/04/2021, 2:21 AMgot it! thanks!
pen one
02/04/2021, 3:59 AMhmmm...cant seem to find that column. I tried the following:
var itemLine = result.getValue({
name: "linenumber",
join: "memberItem"});
pen one
02/04/2021, 3:59 AMand:
Copy code
var itemLine = result.getValue({
name: "linenumber"});b
battk
02/04/2021, 6:31 AMits not part of the memberitem join, look at the columns in the search for a column named member line
p
pen one
02/04/2021, 2:00 PMNot sure why but I do not have this column available. This is what I show:
pen one
02/04/2021, 3:31 PMper Netsuite customer support I need to have the Assembly Item Feature in order to be able to sort by Member Line.
pen one
02/04/2021, 4:07 PMI ended up creating a custom field in the item record and will sort via that.
5 Views