ODBC guide

Adjust inventory level

Adjusts the inventory level of an item at a single location. Use Action='Adjust' in the WITH clause and provide the AvailableAdjustment amount (positive or negative).

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