Is there a way I can partially fulfill sales order...
# general
k
Is there a way I can partially fulfill sales orders using CSV Import or Suitescript or using any other connectors. I was able to import Sales Orders using CSV Import but not the item fulfillments.
k
@KRISHNA @AK47 unless I'm missing the point, yes you can create IF's from a CSV. Go to Transactions>Sales Orders> Fulfill Orders See button on top "Import - CSV"
k
@Kman with that CSV Import option it fulfills entire sales order but I don't want to fulfill all of it. I want to partially fulfill the items in a sales order and chose the status either Picked / Shipped. Did you tried partial fulfillment by any chance?
k
So what's the reason you want to fulfill partially/ only select picked/ shipped?
a
@Kman @KRISHNA The built in CSV import didn't work for us either. It just takes a list of SOs and creates an item fulfillment for the entire order. We have a few different tools that we build to handle IFs. One, that we call Bulk Fulfill, allows us to choose a group of SOs, see a summarized list of items and quantity, choose the quantity to ship, and then generate an appropriate IF against as many SOs as it could. Another one just fulfills the whole order complete once it's created. These fill different needs for us, but the only way to create a partial IF would either be manually through the UI or through a script that creates an IF.
k
Yes if you need to do bulk partial fulfillments, most likely you need a script which imports a file or a script that imports the data from an external system and puts it into NS.. (I've done this part with Celigo integration before)
k
@Kman It's interesting to see a coincidence I am using Celigo too to partially import them.
k
What is the source of the data?
b
@Kman do you use Celigo to integrate cancellation/ refunds?
r
@Chris Corcoran on the Celigo team might have insight
c
@Krishna which Celigo tool are you referring to? If it’s CloudExtend Excel for NetSuite I can get you in touch with our Solution Consultant (Kevin) who can help you get these partial fulfillments done directly in Excel.