ODBC guide

Connect inventory item to location


Connects an inventory item to a location by creating an inventory level record. Use Action='connect' in the WITH clause.

UPDATE InventoryLevels 
SET LocationId=25801916516
WHERE InventoryItemId=43512276942948
WITH(
 Action='connect' --or adjust or set
, ContineOn404Error=0 
)