Hi All,
I am creating a Transfer Order using Afte...
# suitescriptd
D17339
02/10/2020, 6:20 AMHi All,
I am creating a Transfer Order using AfterSubmit(Applied to Sales Order), while creating transfer order I am setting the transfer order Order # dynamically ( Last Processed Transfer Order# increment by 1).
I can see few Transfer Order# are blank and few have the same Order#.
AfterSubmit(SO) gets triggered by RestLet and web services as well.
How to solve this Order# issue?
b
battk
02/10/2020, 6:44 AMare the duplicates created at the same time?
d
D17339
02/10/2020, 6:49 AMDifferent time
b
battk
02/10/2020, 6:51 AMits unlikely to be a concurrency issue then
battk
02/10/2020, 6:51 AMwhat does the order # logic look like
d
D17339
02/10/2020, 7:07 AMfunction lastProcessedSTO() {
var stoNo;
try {
//customsearch1767
var transferorderSearchObj = search.create({
type: "transferorder",
filters: [
["type", "anyof", "TrnfrOrd"],
"AND",
["numbertext", "startswith", "STO"]
],
columns: [
search.createColumn({
name: "tranid",
summary: "MAX"
})
]
});
var searchResultCount = transferorderSearchObj.runPaged().count;
log.debug("transferorderSearchObj result count", searchResultCount);
transferorderSearchObj.run().each(function(result) {
stoNo = result.getValue({
name: "tranid",
summary: "MAX"
});
});
return stoNo;
} catch (error) {
log.error('lastProcessedSTO Error', (error.message && error.name) ? error.name + ': ' + error.message + ': ' + error.stack : error.toString());
}
}
D17339
02/10/2020, 7:08 AMvar stoNo = lastProcessedSTO();
log.debug("lastProcessedSTO", "stoNo ==> " + stoNo);
b
battk
02/10/2020, 7:16 AMyou probably need to do something better than max of tranid
battk
02/10/2020, 7:16 AMtranid is a string
d
D17339
02/10/2020, 7:16 AMi will get stoNo as "STO134-1"
D17339
02/10/2020, 7:17 AMif (stoNo != 0) {
stoNo = stoNo.split("-")[0].match(/\d/g).join("");
}
log.debug("lastProcessedSTO digit", "stoNodigit ==> " + stoNo);
stoNo = parseInt(stoNo);
D17339
02/10/2020, 7:17 AMstoNo += 1;
D17339
02/10/2020, 7:17 AMThis how finally i am getting it incremented finally
b
battk
02/10/2020, 7:19 AMsearch.createColumn({
name: "tranid",
summary: "MAX"
});
battk
02/10/2020, 7:19 AMthat wont get you the largest tran id
battk
02/10/2020, 7:20 AMprimarily because tranid is not a number
d
D17339
02/10/2020, 7:21 AMoh okay
D17339
02/10/2020, 7:42 AMvar transferorderSearchObj = search.create({
type: "transferorder",
filters: [
["type", "anyof", "TrnfrOrd"],
"AND",
["numbertext", "startswith", "STO"],
"AND",
["mainline", "is", "T"]
],
columns: [
/* search.createColumn({
name: "tranid",
summary: "MAX"
}) */
search.createColumn({
name: "tranid"
}),
search.createColumn({
name: "internalid",
sort: search.Sort.DESC
})
]
});
var searchResult = transferorderSearchObj.run().getRange({
start: 0,
end: 5
});
if (searchResult.length > 0) {
stoNo = searchResult[0].getValue('tranid');
}
D17339
02/10/2020, 7:42 AMis this fine
D17339
02/10/2020, 7:42 AM?
b
battk
02/10/2020, 7:44 AM