I have a list of items +-3000
We have a new subsid...
# suitescripts
Simon
10/05/2023, 7:24 PMI have a list of items +-3000
We have a new subsidiary.
I want to add the subsidiary to the items
Is there's a trick to do it ?
m
Martin
10/05/2023, 7:25 PMmass update?
s
Simon
10/05/2023, 7:26 PMlet me try
Simon
10/05/2023, 7:27 PMThat's what I thought. Update Subsidiary is not available with mass update
d
David B
10/05/2023, 8:05 PMcsv import, hands down
David B
10/05/2023, 8:07 PMyou'll need to set the existing subsidiary(ies) plus the new subsidiary (so need to export the current selections)
i.e. the item currently has a value for subsidiary of
1|3|461|3|4|6✅ 1
s
Simon
10/05/2023, 8:08 PMok
Simon
10/05/2023, 8:08 PMI will give it a try
d
David B
10/05/2023, 8:09 PMgood luck, let us know
s
Simon
10/05/2023, 8:19 PMIt did not work
There's a problem with the Form
Simon
10/05/2023, 8:19 PMI'm looking for a suitescript script
m
Martin
10/05/2023, 8:20 PMthen do it, get a map reduce load a search and update the subsidiaries
d
David B
10/05/2023, 8:20 PMwhat's the problem with the form? is the subsidiary field hidden/disabled/unavailable?
s
Simon
10/05/2023, 8:22 PMI have the map reduce
Ritem.setValue({fieldId: 'subsidiary',value: '7,9'});
doesn't work
i tried without ''
Same result
Simon
10/05/2023, 8:23 PMThe CSV import return
61 is an invalid custom form ???
I tried the standard one, also not working
Simon
10/05/2023, 8:23 PMBut as I said, I prefer to do it with a script, because I have more control
🤷♂️ 1
m
Martin
10/05/2023, 8:24 PMit’s an array not a string, do [7,9]
☝️ 1
👍 1
d
David B
10/05/2023, 8:25 PMFWIW, the custom form error is because you need to import different item types separately (inv, non-inv, service, *etc).
If this isn't a one off, investing the time into setting up a M/R is def. the smart thing to do
👍 1
netsuite 1
s
Simon
10/05/2023, 8:34 PMBTW Martin thanks a lot. It's working perfectly
Thanks David too
👍 1
2 Views