1. WHS Adjust
download sample
all columns (except LocationNotes) are needed to be filled in
the adjustment adds the value that you put. so if you need to decrement, put a negative value, to add put a positive value
2. Daily Update Tactical Inventory
EXEC dbo.SP_Fill_Warehouse_Stocks @Warhouse = N'TACT_CA'
3. Tactical Inventory Update Query
Save inventory file as "StockForWarehouse_TACT_CA.txt" into export folder as text(tab delimited) file
Run - EXEC dbo.SP_Fill_Warehouse_Stocks @Warhouse = N'TACT_CA'
To force inventory update on tracker run - EXEC dbo.SP_Copy_SC_Stock_ToDB_wAMTDumps