Hello everybody. We had Item fulfillment created without classes, which is setting our financial reporting wrong. Is there any way to update item fulfillment lines like we can do for other transactions ? Thanks !

If it's always based off the item, you could try to do something with a workflow sublist action group

Thanks for your help ! I meant, when the record is already created, is there a way to update past item fulfillments ?

@LRG you can use Celigo's CloudExtend Excel for NetSuite to update line level detail (class) for the fulfillment records.

@Chris Corcoran Thanks. What's the catch with the free version ?

The free version allows for downloads, not upserts. The trial restricts you to upserting 50 records at a time so if your data set is relatively small you may even get that done for free. No specific license is needed. A few prerequisites such as web services and user access token permissions is all that is required.

I'll check on that. Thanks !

Does take a little bit of effort to get the CloudExtend working - but it does let you touch fulfillments, which you can't really do with CSV uploads

You can update item fulfillment lines like any other transaction, why do you need something special to do this?

From him asking about it, I assumed it was a large volume of updates.

I cannot find Item fulfillment records in CSV updates. I need to update 3000 item lines

Ah, didnt realize they weren't csv-able. I've always handled missing class issues in a script.

That looks handy. I tried to create a workflow that would set the line's class to match the item's configured class.

Yeah - you'd have to do a scheduled update.

It's gonna trigger at 9:30 pm normally. I'll see if it's configured the right way. Do that mean that I need to open each record individually for the workflow to be initiated though ?

No - a scheduled workflow could do the updates en masse

If I set it up for all "item fulfillments" that means it's gonna trigger on every item fulfillment ?

You might reconsider doing that via workflow - you need a certain level of "i know how this works" in order to pull that one off.

Well, I would not trigger it live before making sure that it works on our sandbox 😄

if you are sure you set up the items correctly, you can turn off the workflow once the fields are updated so it doesn't keep running every night

Yeah, I'm trying a manually triggered wf now on the sandbox to avoid unnecessary computing from happening. Then I'll circle it with a saved search.

👍

Thanks to all of you for your guidance !