TROUBLESHOOTING: I’m not receiving the expected number of items on inbound shipments?
Q: I’m working on a custom flow to receive inbound shipments, but I’m not receiving the expected number of items on inbound shipments. I’m trying to use a lookup to return the internal ID of the item, but it’s failing. How can I resolve this?
A:
- Make sure that you don’t have any export or import filters that are causing records to be ignored.
- Make sure that the item you are trying to import has the expected values. Try hard-coding the ID of an item to test whether the record is being successfully imported. While testing, in your import, uncheck Ignore missing records. This will ensure that all of your records are coming through as expected. Here is an example of mapping that worked for us:
As you can see in the script, the NetSuite Item(InternalId) field is called “receiveitem”.
3. Make sure that the inbound shipment record is in the expected status for your flow, such as “In transit”.
If you're interested in excluding unreceived line items from partial inbound shipments in NetSuite, check out this related post.
0
Comments
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'..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."
Moderator note: Please see the response posted under "Inbound Shipment flow error".
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!
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!
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.