Has anyone been able to get the preferred vendor o...
# suitescripts
Santiago
10/28/2020, 3:05 PMHas anyone been able to get the preferred vendor on the item record when the Multiple Vendor feature is enabled?
s
Sandii
10/28/2020, 3:12 PMYeah its pretty straightforward, preferredvendor is available in the search module, also you can loop the vendor sublist with record module and get that way, depends your context.
s
Santiago
10/28/2020, 3:22 PMso there's a column name that is preferredvendor? isn't this preferred vendor field id vendor?
I am doing a search on an ss service and tried the lookupField functionality with the "vendor" field id and came back blank.
Going through the docs it said if the Multiple Vendor feature was enabled the preferred vendor field set would not work, and it's true cause is coming back null to the frontend.
Santiago
10/28/2020, 3:57 PM@Sandii even if I create a Column using a JOIN with the preferredvendor I get as a return an empty array as a value for that field
s
Sandii
10/28/2020, 3:59 PMYou cant use search.lookupFields to get sublist values. Preferred vendor is a column if you create a regular search
s
Santiago
10/28/2020, 4:08 PMI did create a regular seach but when I try and access through script the values aren't there, the come back blank
s
Sandii
10/28/2020, 4:24 PMThe column
vendorSandii
10/28/2020, 4:25 PM Copy code
var itemVendorArr= search.create({
type: "item",
filters: [],
columns: ["itemid", "vendor"]
}).run().getRange(0,1000).map(res => res.toJSON());s
Santiago
10/28/2020, 4:32 PMYes but the multiple vendor feature is enabled so this search will bring me back the column vendor with an empty array, and I know for a fact that the item has values
s
Sandii
10/28/2020, 4:36 PMNo it wont, I just did it
Sandii
10/28/2020, 4:38 PMmessage has been deleted
s
Santiago
10/28/2020, 4:49 PMI AM TALKING IN SCRIPT NOT IN UI!!!
s
Sandii
10/28/2020, 4:54 PMThe script I provided is the exact same search as the UI
Sandii
10/28/2020, 4:56 PMmessage has been deleted
Sandii
10/28/2020, 4:57 PMGOOD LUCK THOUGH SINCE YOU WANT TO YELL AT SOMEONE SPOONFEEDING YOU WHAT TO DO
s
Santiago
10/28/2020, 5:17 PMI'm sorry about yelling but this makes no sense I'm doing the same thing and I get balnk values in the vendor column as a result are you positive that the Multiple Vendor is enabled and you have more than 1 vendor in the item
s
Sandii
10/28/2020, 5:23 PMI showed you the screen shot, just paste your code here, probably missing something small
17 Views