Hello, I am trying to set a line value for a sales...
# suitescriptp
Phillip
01/19/2021, 9:16 PMHello, I am trying to set a line value for a sales order line after the sales order has been initially created. When I have a sales order with four or more lines the script does not work. What am I doing wrong?
b
battk
01/19/2021, 9:19 PMexpect to share more code, especially whatever you use for looping
p
Phillip
01/19/2021, 9:21 PMfor (var x = 0; x < lines; x++)
{ //for loop
var numbertoset2 = x+1;
numbertoset2 = parseInt(numbertoset2);
var n2 = numbertoset2.toString();
soRecord.setSublistValue({
sublistId : 'item',
fieldId : 'custcol_kit_number',
line : x,
saveneeded='1';
} // end of for loop
/*soRecord.setValue({
fieldId : 'custbody_pi_renumkitnum',
value : false});*/
log.debug({details:"gothere = " + saveneeded});
if (saveneeded === '1')
{
var recId= soRecord.save({
enableSourcing: true,
ignoreMandatoryFields: true
});
log.debug({details:"savedrecord" + recId});
}
Phillip
01/19/2021, 9:21 PMthere is the code
b
battk
01/19/2021, 9:23 PMstill need to share what lines is
p
Phillip
01/19/2021, 9:24 PMvar soRecord = record.load({
type: record.Type.SALES_ORDER,
id: recordId
});
//Get the number of line items
var lines = soRecord.getLineCount({
sublistId: 'item'
});
a
alien4u
01/19/2021, 9:26 PMThis is not valid...
p
Phillip
01/19/2021, 9:27 PMI fixed it: var numbertoset2 = x+1;
numbertoset2 = parseInt(numbertoset2);
var n2 = numbertoset2.toString();
soRecord.setSublistValue({
sublistId : 'item',
fieldId : 'custcol_kit_number',
line : x,
value : n2});
saveneeded='1';
a
alien4u
01/19/2021, 9:27 PMUntitled
p
Phillip
01/19/2021, 9:28 PMthe problem is the kit number is not being set when the sales order has four lines
a
alien4u
01/19/2021, 9:29 PMAlso be careful with
parseInt(numbertoset2);p
Phillip
01/19/2021, 9:29 PMwhat is radix?
a
alien4u
01/19/2021, 9:29 PMp
Phillip
01/19/2021, 9:31 PMthanks. the kit number sets fine when I have one or two lines but it does not set anything in the field when there are four lines. I run the debugger and I can see the correct values are set
a
alien4u
01/19/2021, 9:32 PMCan you set that value in the UI for that Order with 4 lines?
p
Phillip
01/19/2021, 9:32 PMyes. you can
b
battk
01/19/2021, 9:34 PMyour code is fine, if ugly looking
battk
01/19/2021, 9:34 PMnothing in there would specifically fail at 4 lines
battk
01/19/2021, 9:35 PMin my account, it works normally for an order with 4 lines
p
Phillip
01/19/2021, 9:37 PMits weird. I can not get it to work in mine
b
battk
01/19/2021, 9:37 PMyou can try taking a look at user event scripts or workflows deployed to sales orders to see if they are causing issues
battk
01/19/2021, 9:37 PMthe code i used looks like
battk
01/19/2021, 9:38 PM Copy code
require(["N/record"], function (record) {
var soRecord = record.load({
type: record.Type.SALES_ORDER,
id: "28446",
});
//Get the number of line items
var lines = soRecord.getLineCount({
sublistId: "item",
});
for (var x = 0; x < lines; x++) {
//for loop
var numbertoset2 = x + 1;
numbertoset2 = parseInt(numbertoset2);
var n2 = numbertoset2.toString();
soRecord.setSublistValue({
sublistId: "item",
fieldId: "custcol_kit_number",
line: x,
value: n2,
});
saveneeded = "1";
} // end of for loop
log.debug({ details: "gothere = " + saveneeded });
if (saveneeded === "1") {
var recId = soRecord.save({
enableSourcing: true,
ignoreMandatoryFields: true,
});
log.debug({ details: "savedrecord" + recId });
}
});a
alien4u
01/19/2021, 9:38 PMKit Items and Group Items behave weird at the line level and they may be adding weird lines... you need to check if that is the case...
p
Phillip
01/19/2021, 9:38 PMgot it. we do have kit items on the so
Phillip
01/19/2021, 11:29 PMI did get it working. thanks for your help
l
Lee Hopper
01/22/2021, 12:29 AM@Phillip Do you mind sharing how you got it working? I can imagine needing to do something similar in the future and getting stuck on this.
p
Phillip
01/22/2021, 3:24 PMI made a change to our integration process to populate the checkbox when the salesorder is created. the sales order was being updated multiple times
3 Views