TROUBLESHOOTING: I’m not receiving the expected number of items on inbound shipments?



  • Imbema Support account

    Need help on Inbound shipment flow.

    1. To create inbound shipment flow, i should use netsuite record "receive inbound shipment" OR "inbound shipment"?

    2. can you give me more details on lookups in attached screenshot?  i used inbound shipment lookup-> purchase order record type and Item lookup to 'inventory part' it correct?

    Getting error: "Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record."

  • Kate Larson Senior UX Researcher Community moderator

    Moderator note: Please see the response posted under "Inbound Shipment flow error".

  • Martin Jahn Channel Partner
    Celigo University Level 1: Skilled

    Documentation is tough all around but here is what worked and allowed me to receive partial quantities on lines and selectively receive lines as well in my integration flow based on the lines passed in the source data:

    1. Date -> set as needed
    2. Inbound Shipment (Field ID:internalid) -> set to internal id of the Inbound Shipment you want to receive
    3. Items : Replace All Lines -> hard code to "true" so only the lines you pass are added to the receipt
    4. Items : Quantity to be Received -> the qty to receive
    5. Items : Receive -> hard code to "true' if all your source data lines have qty to be received
    6. Items : Item (InternalId) -> I needed to do a look up from the SKU (item name) passed by my external application
    7. Items : ID -> this is the line key from the Inbound Shipment (Items - Line Id is the field when doing a Saved Search on Inbound Shipments)

    I also added a custom record import as my first step to track the External ID's of the submitted 'Receive Inbound Shipment' to prevent duplicates being processed as there is no 'Receive Inbound Shipment' record created (it is essentially a virtual record that ultimately creates item receipts).

    Happy Integrating to you all!

  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Martin Jahn,

    Thank you so much for taking the time to share your resolution! We really appreciate it. If there's anything else you can think of to improve your experience in the product or in the documentation, please let us know!

  • Aishwarya M J Referral Partner
    Celigo University Level 4: Legendary

    Hi Courtney Jordan Martin Jahn,

    I have a similar custom flow to receive Inbound shipments in NetSuite. I am able to receive inbound shipments successfully. However, when the receipt is for the partial quantities of item lines, the inbound shipment still gets received in full. For e.g. if Item A has 5 Quantities in the Inbound Shipment, I initiate the receipt for only 2 but the receipt gets created for all the 5 quantities.

    Below given is my mapping.

    Could you please review and suggest a solution?

    Thanks in advance.



Please sign in to leave a comment.