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 [[27522]] 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 [[lineunique key]].  

Did this answer your question?