Is it possible to loop through Items on a Sales Or...
# suitescripte
ericbirdsall
10/25/2021, 8:48 PMIs it possible to loop through Items on a Sales Order and change the Location field on all of them?
Whenever I try to loop, the first location updates but none of the others.
Copy code
var itemCount = salesOrder.getLineCount({
sublistId: 'item'
});
var currentLocation = salesOrder.getValue({
fieldId: 'location'
});
for (i = 0; i < itemCount; i++) {
salesOrder.selectLine({
sublistId: 'item',
line: i
});
salesOrder.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'location',
value: currentLocation,
});
salesOrder.commitLine({
sublistId: 'item',
})
}d
Dan Anderson
10/25/2021, 9:22 PM Copy code
record.setSublistValue({
sublistId: 'item',
fieldId: 'location',
value: location,
line: line
});Dan Anderson
10/25/2021, 9:23 PMThis is the code I use, it doesn't have the selectLine and commitLine logic you have it sets the sublist value for the selected line in one method.
c
creece
10/25/2021, 9:28 PMYou don't need to select the line unless the record object is in dynamic mode as well.
e
ericbirdsall
10/25/2021, 9:30 PMIm sorry - I'm trying to do this client side. I think client side I have to user N/currentRecord and in that case, I do need to use selectLine / setCurrentSublistValue and commitLine
(please correct me if I'm wrong)
c
creece
10/25/2021, 9:33 PMI'd do it on beforeSubmit personally. It avoids having to deal w/ client side logic and it also works for imports should they ever do it.
creece
10/25/2021, 9:34 PMThe only reason(s) to do it client side is they need the location info immediately for some reason. The only thing client side should really be used for is validation IMO. Do the rest in a before or after submit unless it really warrants being client side.
💯 1
s
stalbert
10/25/2021, 10:17 PMof course, I'd be writing this something simple like
_.forEach(salesOrder.item, line => line.location = somelocation)b
battk
10/26/2021, 12:39 AMsetCurrentSublistValue is asynchronous, use forceSyncSourcing to avoid committing multiple lines at the same time
e
ericbirdsall
10/26/2021, 1:03 PMthank you @battk that was exactly what I was looking for
3 Views