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

Morning everyone - is there a way of mass updating bills to different departments?

Did you try mass update? might work not sure if classification is exposed in Mass update

I am now trying to mass update Item Fulfillment, but can see any way to do that

The CSV import does not have that category nor the mass update

I'm comfortable with coding but havent given a stab at suitescript

How long do you think I'd take to perform it?

That depends on what kinf o refinements you want

You coud create a simple rest service that changes the department on a specified (or a list) of bills

Or you could write a wizard page with a map/reduce scrit wich would be more complicated

Was looking for something simple right now, like moving item fulfillments from COGS to expenses

If it is a one time only I would just create a script that receives a list of IDs, loads and updates the record

And invoke the service using postman so it wouldn't impact the Netsuite governance

Just as a time reference, how long would it take for you to do it?

I've never tried a CSV import with bills though

I got my way around bills via CSV, pretty straightfwd, even though wanted to use the mass update

But now I'm trying to move item fulfillments around and cant see a way to do it

I'll probably move the balance around using a journal, but wanted to make it cleaner

As <@UMZJF3BCH> said CSV would be alot easier, as a developper I always try to solve things with scripts

Probably would take a day or two to get a script like that working