Issue with creating IFs in Netsuite for Special Order Items when Kits are involved

Comments

4 comments

  • Christian Bannard
    Engaged
    Awesome Follow-up

    Just to clarify the entire underlying question here, what we really need is an example of the format of creating a multi-line Item Fulfillment and how to do so with kit items, given how Netsuite handles them in comparison to Inventory Items is a little different.

     

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Christian Bannard in my experience, this would require a somewhat complex flow and script. You would need a flow that looks something like this:

    1. Shipment notification from your 3pl
    2. NetSuite lookup step to get the sales order lines, item types, quantity, already fulfilled quantity if doing partial fulfillments
    3. NetSuite lookup step to get the kit definition of line items that are kit type (maybe could get #2 and #3 here on one lookup depending on how you make the search).
    4. Post response map script on the last lookup to convert your 3PL payload of component items back into kit format.
    5. NetSuite import step to fulfill items.

     

    You basically have to take the kit definition of NetSuite, then rebuild the kit in your lines array from the 3PL. Hopefully that makes sense.

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Christian Bannard it could get even more complex if your 3pl consolidates lines where kits share common components. For example, if you have kit A with components X and Y and kit B with components X and Z, NetSuite would have 4 order lines on the PO. When you send those 4 lines to your 3pl, some 3pls will consolidate lines with the same sku. Now you would have 3 lines instead of 4 and would need to count quantity of components fulfilled between each kit definition.

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Christian Bannard OR if you never partially fulfill and always fully fulfill an order, you could make it easy and just have a lookup to the sales order to get the SO lines, then import the item fulfillment with the array of that lookup vs using your 3pl data.

    0

Please sign in to leave a comment.