The goal is to update the qty required or other fields on the material lines of an existing BOM using an import scenario.

I am aware of using the @InventoryID as a lookup, but in our scenario  there may be multiple material lines for the same inventory id on a single operation.  These are typically non-stock items that are called out with different descriptions.  

The other option I’m aware of is to lookup by line number, but we have run into issues with this too. When a BOM is edited there are sometimes gaps in the AMBomMatl.lineNbr field, whereas the <Line Number> lookup is always looking at sequential lines.  This may result in the wrong line being updated, or an error if the line number doesn’t exist.  Is there a way to retrieve the sequential line number in a GI, so that we can be sure we are editing the correct line?

Any thoughts  @dennisgodsill36 or other import scenario gurus out there?

Thanks in advance!

Laura