https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hello all, We are having a very difficult time to...
# suitescript
a
Hello all, We are having a very difficult time to partially fulfill sales orders and are wondering if anyone has experience using workflows or scripting to accomplish this? I imagine this will require scripting since I gave workflows and also Integrator.io my best shot. But if anyone has any other ideas I'd love to hear. Scenario: We have a Sales Order with 3 lines. Let’s say 1 or 2 of the lines we Drop Ship from a Vendor, and creating a Drop Ship Purchase Order. When the Vendor ships these items, we find out by pulling a report with the matching PO # on it from our UPS account and putting this on an FTP site. We want to match this PO with the Sales Order and only fulfill the items that are on the PO. Any ideas on how to only fulfill that 1 or 2 items on the PO? We have attempted to use workflows and Integrator.io with little success. What happens is that we can only get to fulfill the entire Sales Order, not just the items on the Purchase Order. Thanks. FYI... I'm not a coder.
a
we had a similar problem but partially fulfilling PO's and currently have a work around with using record imports and/or using a script
b
whats the value of the 
Default Items to Zero Received/Fulfilled
order management preference
m
is the location on your line?
i dont understand why you cant fulfill the individual lines
b
my guess is that his account defaults to fulfill all committed items
m
oh right
that also
once you receive the PO, you have inventory, therefore; able to commit the single item > create fulfillment
anything else that does or does not have inventory shouldn't matter on the fulfillment
a
@battk thats correct. The 
Default Items to Zero Received/Fulfilled
is unchecked on our . What kind of ripple effect could this have on other workflows or scripts if I check it?
b
fulfillments (and item receipts) have a checkbox on them to determine if the line has been Fulfilled or Received
the 
Default Items to Zero Received/Fulfilled
controls if that checkbox starts out checked or not checked
Either scenario requires additional work for partial fulfillment/receipt
if 
Default Items to Zero Received/Fulfilled
is checked, your script needs to check that checkbox on every line that you want fulfilled and leave the non shipped lined unchecked
the opposite is true if 
Default Items to Zero Received/Fulfilled
is unchecked, you need to unmark the fulfilled checbox on every line that is not fulfilled and leave the shipped lines checked
the second scenario tends to be slightly easier if a script doesnt need to support partial fulfillments, it doesnt need to uncheck or check any checkboxes when creating item fulfillments
a
Yeah, that makes sense. We use integrations like Ozlink and I imagine they must be doing similar when we dont fulfill all the items in a order. An added complexity for us is that these are Drop Ship PO's, so we never actually have the inventory in stock. And we have various integrations and scripts that could be affected by this so I think I'll need to reach out to partners like Ozlink and RF Smart. Maybe they'll have some insight as well. I also found this Suiteanswer id: 31186 SuiteScript > Partially Fulfill Sales Order by Specific Purchase Order. Do you think that could be the solution?
b
its similar to the solution i outlined
its more clever in that it uses a field on the sublist to determine if it was from a particular purchase order to determine whether or not to mark the fulfill checkbox
30 Views
Open in Slack
PreviousNext
Powered by