Inbound Shipment flow error

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'..is 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."

1

Comments

7 comments
Date Votes
  • 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!

    1
  • Hi Dipayan,

    The inbound shipment record is tricky to work with. You have to remember it is a container for different purchase orders and the various line items that can be on the inbound shipment record. Even NetSuite classifies this record as "other" and not a transaction.

    To receive an inbound shipment you will want record type = "receive inbound shipment" and your operation will be "add". You mappings should include:

    1. Receiving location (name)
    2. Inbound shipment (ideally this should be the internal ID of the inbound shipment record)
    3. Date (delivery date and make sure to set the date format masking and right time zone)
    4. Vendor (optional)
    5. Items : Receive = true or false (use handlebar expression: {{#compare ActualQuantityReceived "!=" 0}}"T"{{else}}"F"{{/compare}})
    6. Items : quantity to be received (actual quantity received. NOTE: NetSuite does not allow over receipts. This will error out if you try to over receive)
    7. Items : rate (price of the items received. This could be optional)
    8. Items : ID (Don't use Items : Item. This should be marked as a key field to find existing lines. This is the line number of the item you are trying to receive and likely why you are getting a sublist error. Items may not be unique on an inbound shipment as you can have the same item on two different PO's so NetSuite need the line number (ID) to find the right line to update.  You can get this value by either doing a dynamic search for the value or you can do a lookup step before you create the receive inbound shipment to get a list of the line ID's for the open inbound shipments. Or perhaps you are already getting the line ID from the vendor so that would be a standard mapping).

    Good luck. I hope this helps.

    0
  • Thank you chris. But I am lost in Item lookup.I used the below lookup

    BGM+351+27350839+9'
    DTM+137:20210907:102'
    DTM+17:20210906:102'
    RFF+VN:447xxx'
    RFF+ON:PO-69-0000xxx'
    ......
    ......
    LIN+17++6416868566xxx:EN'
    PIA+1+79920001xx:SA'  //vendor item code
    IMD+F++:::Polarshine xxxxxx xxxxx :1L'
    QTY+12:60.0'

    But still getting a sublist error. Please advise.

    Another question arrived, how this DESADV got to know for which sales order I am creating it? I mean it should match with specific sales order item details, quantity..right?

    0
  • Hi Dipayan Samanta,

    Thanks for posting this to the community. If you need additional help, my recommendation is that you sign up for an office hours session where one of our solution consultants can provide guidance.

    0
  • Update: Our issue has already been resolved. Yes, Receive Inbound Shipment works for flows using FTP > Netsuite, as opposed to what we have been informed previously.

     

    Hi,

    We are having problems with automating the receipt of inbound shipment. It just stopped working for us. The flow shows that the process was successful, but nothing is happening in our Netsuite side.

    1. We were informed by Celigo support that Inbound Shipment/Receive Inbound Shipment was never supported by Celigo.

    2. Netsuite support informed us that these are not scriptable ever since.

    But this process was working for us properly last year and just stopped around November. We are unable to find a way to make this work even with all the time we spent with both support teams.

    I just want to clarify with the community, Receive Inbound Shipment from FTP via Celigo to Netsuite is something that is working for your accounts, right?

    0
  • Our team has successfully built integrations that will receive the native NetSuite Inbound Shipment Transaction.  It takes some work and creativity to get it up and running especially since the integration uses a virtual record so you cannot directly leverage the normal concepts of External IDs.  As a certified Celigo Channel Partner we can certainly assist you.

    0
  • Hi Martin Jahn,

     

    Thanks for the feedback. After months of tweaking, we were able to have it run again. Unfortunately, there was some mapping we needed to add, that was previously not there. Though the strange thing about this is that the flow was previously running with no problem, even without these mappings and just suddenly stopped last Nov 2021.

     

    Thanks!

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post