https://netsuiteprofessionals.com logo
Join Slack
Powered by
I have an issue creating Item Fulfillments off of ...
# suitescript
s
I have an issue creating Item Fulfillments off of drop ship purchase orders with kit items. On the Sales Order, the top level kit item is not drop shippable, but the child items are, so only the child items appear when the PO is created. In the UI, there's a "mark shipped" button on the PO, but no "fulfill" button on the SO. The UI is smart enough to make the proper fulfillment off the PO with the child items on it, but in SuiteScript, I can only transform the SO into an Item Fulfillment, not the PO, and when I do, it transforms with only the top level kit item. I don't know how to do that transformation properly in suitescript. Does anyone have any idea how that would work?
b
what type of items are you using for your kit item
members?
s
I don't know how to tell to be honest
I do know that they are fulfillable non inventory items, and the top level is non drop shippable, which is why only the child items appear on the PO
b
what you described should be the same as the drop shipped non inventory items
transform the sales order to an item fulfillment
you should really look into which items are on your kit item
s
When I transform the sales order to an item fulfillment in suitescript, it only has 1 line item of the original 3 on the sales order: the top level kit item, which is not on the purchase order
In the UI there isn't even a button to fulfill off the sales order
b
is the item backordered?
s
Which, the two child items that don't appear when I transform?
b
the kit item on the sales order
s
They all look like non inventory items... doesn't that mean they cant be backordered?
b
netsuite tracks inventory for kit items
so the kit can be backordered
generally the cause of no fulfill button on the sales order is a backorderd item
s
Would that explain why the two child items are not on the transformed Item Fulfil though?
I see no inventory information on the parent kit item as far as I can tell
b
use the standard form to view the sales order
its includes columns for committed, fulfilled, invoiced, back ordered and quantity
pretty much essential for debugging problems like this
if you cant do that, add them to your form
s
The back ordered column on the item level is simply empty
Picked, packed, fulfilled, invoiced are all 0 for all 3 line items on the Sales order, and Committed and Backordered columns are empty for all 3
Quantity is 2 for all three lines, if that matters
b
committed 0 tends to imply there is nothing to fulfill
do you have a location set at the header or line
s
I do not, you think that could be related?
b
probably
you might actually have to regenerate the purchase orders if the location isnt set
s
Why?
b
the location of the purchase order comes from the sales order
if there is none on the sales order, it won't be populated on the purchase order
you might be able to get away with editing the purchase order to have the proper location
but i would recommend starting from a pristine sales order with the location set
s
You're right that theres no header level location on the generated po, (there are line level locaitons) but the PO is still fulfillable from the UI
Changing the location on the sales order did not affect my ability to fulfill it from the UI
I haven't tried re running the script to see if the added location suddenly adds the child items to the item fulfillment but i doubt it
b
is this a new sales order?
s
Not sure how you want to define it, but no it's not from today. it's a real production order that my script is failing to process a shipment for.
It's pending fulfillment
b
im saying make a test order that is a copy with the location properly set
and see if the script works then
although to be honest, as long as the fulfill button shows on the sales order, it probably will work
s
ok thanks for the input, ill try to get a test order created
4 Views
Open in Slack
PreviousNext
Powered by