While Updating/Creating new Inbound Shipment records using CloudExtend Excel , there is one
Gotcha that users need to be aware of due a limitation in the data available to our App.
In the inbound shipment template screenshot shown below, on item 1017, you can notice that internalID is populated as [] when you download an existing record.
The issue here is it is not the internalID of the item in context, rather it is a reference to Line Unique Key of the item in the linked Purchase Order PO#21 .
How to find Line Unique Key
Users can find the Line Unique Key by creating a saved search on PO as below
Tying it all together with CloudExtend
As part of your workflow you'll want to first use the CloudExtend raw data download to quickly retrieve your PO's and lookup the Line Unique Key using Excel VLOOKUP from the related PO and place the value in the Items List: Shipment Item field in the proper format of