Hi all,
We're presently writing flows for integration with a 3PL.
So here's the scenario:
- We receive an order, with each of the order items (SKUs) being pushed from our e-commerce platform (and sometimes B2B platforms).
- All of the SKUs, including Kits, are unique, and are Special Order Items in Netsuite (the Kits' member items are all Special Order Items also).
- Netsuite converts the Sales Order into a Purchase Order, which we write to a Saved Search for periodic collection by Celigo, following which is converted into CSV for placement on our 3PL's FTP for collection at their end.
So here's where the fun begins.
Firstly, all of the above works perfectly, no issues whatsoever.
When our 3PL fulfills the order, they create two files, as follows:
- A Delivery Note, which is used for us to receipt in stock via the native Item Receipting system in Netsuite.
- A Shipment notification which is used to trigger Item Fulfillment via the native Item Fulfillment system in Netsuite.
So here's where things get tricky and what we would like some advice/assistance on, from anyone that may have encountered and resolved similar issues.
When a Special Order Item Purchase Order is transformed from a Sales Order into a Purchase Order by Netsuite's internal processes, if there is a Kit on an order, the Kit SKU is converted into the sum of it's parts on the Purchase Order.
e.g. ABC123 is a kit made up of 2 x AB123 and 3 x AC345 Inventory Item SKUs.
So per the above, someone has ordered a few standard Inventory Items and 1 x ABC123 Kit.
Our order when it gets converted into a Purchase Order no longer contains the Kit SKU at all, only a list of Inventory Item SKUs.
When we process the Item Receipt, which is done when our 3PL has our order in basically "Packed" status, just before being consigned for shipment, we receipt the stock into Netsuite via the Item Receipt, which works fine (keeping in mind that Item Receipts are receipting against the original Purchase Order), so this step works beautifully and everything is rosey.
So, we have the items "in stock".
Now when we receive the second file to trigger our Item Fulfillment flow, add our consignment information, carrier, tracking links and shipping cost, this is where things diverge into two different pathways:
1. Item Fulfillments for standard Inventory Items, since they're on the original Sales Order that came from our e-commerce platform as the same SKU as that which appears on the Purchase Order that was sent to the 3PL, functions fine and will process without any issues.
2. Item Fulfillments for kits are erroring in Celigo as the SKU on the original Sales Order is not available in the PO that was sent to the 3PL (all they're aware of is the kit member items, given there's no nesting of items on the PO in Netsuite to denote which items are kit members, nor does it seem to pass the kit header SKU).
So, my questions:
1. Does anyone know of a way of, or setting, to include the header/Kit SKU as part of the conversion process of a PO generated from a Sales Order as a Special Order in Netsuite?
2. Does anyone know of a field in the Netsuite that can be sent in addition to the standard PO information to show which items are part of a kit?
With our existing flow it is processing Inventory Items without an issue, though when attempting to process kit item components, we're getting the following error message coming back from Netsuite:
"Failed to create, update/transform record because You cannot create an inventory detail for this item."
I'm assuming this is because what we're passing back to create the IF is realistically the wrong SKU, given we should really be passing back the Kit SKU since that's how it was ordered on the Sales Order (and the IF wants to follow suit), yet when we're attempting to pass the information we're sending the individual kit member item SKUs.
Any clues on how we can tackle this would be greatly appreciated.
Regards,
Christian