Can anyone tell me what went wrong with this? Not ...
# suitescriptk
KevinJ of Kansas
09/14/2020, 1:37 PMCan anyone tell me what went wrong with this? Not really a developer - just trying to use a suite answers article without having to hand type all the names. I know the issue is with my var "sub" and how i'm trying to set it -because it works without it - just not seeing what I did wrong.
Copy code
(function changeId(){
require(['N/record', 'N/currentRecord'],
function(record, currRec) {
var rec = currRec.get()
var rec = record.load({
type: record.Type.SUBSIDIARY,
id: rec.id
});
var sub = rec.getValue({
fieldID: 'name'});
rec.setValue({
fieldId: 'externalid',
value: sub
});
rec.save();
});
}())b
battk
09/14/2020, 1:46 PMfieldID vs fieldId
battk
09/14/2020, 1:48 PMgeneral warning about saving the current record means that all the current work done on the record will be lost since the record has been changed
k
KevinJ of Kansas
09/14/2020, 1:48 PMwhich is fine - i'm running this in console to set the external ID on the sub
KevinJ of Kansas
09/14/2020, 1:50 PMThat did it.
KevinJ of Kansas
09/14/2020, 1:50 PMThanks.
KevinJ of Kansas
09/14/2020, 1:50 PMThe copy/paste of the name 45 times was getting old
b
battk
09/14/2020, 1:52 PMmost would have done a csv import'
k
KevinJ of Kansas
09/14/2020, 1:52 PMCan't do a CSV import to set external ID on subsidiaries.
KevinJ of Kansas
09/14/2020, 1:52 PMb
battk
09/14/2020, 1:54 PMthat is an uninspired article
k
KevinJ of Kansas
09/14/2020, 1:54 PMI didn't write it (shrug)
b
battk
09/14/2020, 1:54 PMthere is no real need to go to every subsidiary to make that change
k
KevinJ of Kansas
09/14/2020, 1:55 PMI'm sure a more efficient script could be written.
KevinJ of Kansas
09/14/2020, 1:55 PMProblem is these folks have insane hierarchy - and I don't feel like doing vlookups to get internal IDs anymore for saved CSV imports.
m
michoel
09/14/2020, 11:09 PMnlapiSubmitField('subsidiary', subsidiaryInternalID, 'externalid', 'subsidiaryExternalId');michoel
09/14/2020, 11:09 PMFYI you can do this with a single line of SS1 on the console
michoel
09/14/2020, 11:11 PMI've done this for adhoc "mass updates" using a formula to in excel to concatenate the script. You can run about 200 at a time until you need to refresh the page to restart governance limits
2 Views