David Durst
04/12/2019, 7:20 AMvar itemsearch = search.create({
type: "item",
filters:
[
["internalid","is", "131120"],
"AND",
["vendor","is","572"],
"AND",
["ispreferredvendor","is","T"],
"AND",
["isinactive","is","F"]
],
columns:
[
search.createColumn({name: "internalid"}),
search.createColumn({name: "entityid", join: "vendor"}),
search.createColumn({name: "vendorcost"}),
search.createColumn({name: "custitem_cc_brand", sort: search.Sort.ASC})
]
});
itemsearch.run().each(function(result){
var sublist = "price";
var item = record.load({type: 'inventoryitem', id: result.getValue("internalid"), isDynamic: true});
item.selectLine({sublistId: sublist, line: 0});
item.setCurrentSublistValue({
sublistId: sublist,
fieldId: "price",
value: "0"
});
item.commitLine({sublistId: sublist});
console.log(item.save());
});creece
04/12/2019, 8:52 AMDavid Durst
04/12/2019, 9:22 AMbattk
04/12/2019, 10:16 AMPricing Sublist / Pricing Matrix in the help center. Item pricing is one of the the harder things to work withDavid Durst
04/12/2019, 8:32 PMDavid Durst
04/12/2019, 8:32 PMUncaught TypeError: Cannot read property 'isMultilineEditable' of nullDavid Durst
04/12/2019, 8:32 PMitemsearch.run().each(function(result){
var sublist = "price1";
var itemid = result.getValue({name: "internalid"});
console.log(itemid)
var item = record.load({type: 'inventoryitem', id: itemid, isDynamic: true});
console.log(item.getValue("id"));
item.selectLine({sublistId: sublist, line: 0});
item.setCurrentSublistValue({
sublistId: sublist,
fieldId: "price",
value: "1"
});
item.commitLine({sublistId: sublist});
console.log(item.save());
return true;
});battk
04/12/2019, 8:33 PMDavid Durst
04/12/2019, 8:46 PMbattk
04/12/2019, 8:54 PMbattk
04/12/2019, 8:54 PMbattk
04/12/2019, 8:54 PMDavid Durst
04/12/2019, 8:57 PMbattk
04/12/2019, 9:08 PMbattk
04/12/2019, 9:09 PMbattk
04/12/2019, 9:10 PMbattk
04/12/2019, 9:10 PMbattk
04/12/2019, 9:12 PMbattk
04/12/2019, 9:13 PMbattk
04/12/2019, 9:15 PMbattk
04/12/2019, 9:16 PMbattk
04/12/2019, 9:21 PM