This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know if there is an easier way than csv import to update the next count date and count interval on the locations sublist for items in an account that is using RF-Smart.

I'd like to update a large swath of items, but CSV importing will take too long. I'd really like to script this but I'm having trouble setting those fields.

Or, is there an RF-Smart feature that helps update these fields in bulk?

CSV works great for this, how many items are you trying to update?

I don't have the exact total, but we have 54 locations. So if it were  10k items over those locations, this would break out into a minimum of 22 imports. I was just hoping I could do this more passively with a map/reduce script.

You can't set the location in the CSV and do them all in one go?

Maybe. I'll look again, but I thought the import would be an items import with a line for each location holding the count interval and next count date.

Am I thinking about this wrong?

image.png

Instead of Pheonix - which I hardcode you could probably do the internal ID of the location

You can also use inventory reporting tool to export the list of all items missing the information than there is a KB article that walks you through the mapping.

Yes. I believe this would work, but still would be many many imports. Maybe that is the only way.

It's definitely not the only way.  For me personally, I'd just knock the CSV's out instead of fiddling with my own personal Map/Recude.

But I'm not as script inclined as others.

use the little "+"-sign on your csv import, next to the location sublist. that lets you add another sublist line so to speak. you can do that 22 times. but, the maximum lines in a csv import is 25 000 so you might have to split your file into 3

<@U03DF9QL7FX> <@U07HXTT03FV> <@U2C74JTPY> Thanks for all of your thoughts. I ended up writing a map/reduce script that is doing the job. This is an update to over 3 million location lines so CSV importing was not an option.

It took me a while to figure out because I'm not a professional developer, but I've got it to work and I'm happy about it. It is going to take days to grind through everything, but it is running in the background.