备份数据后，用语句对账套数据库执行，可以查询出哪里有负库存，在软件修改负库存后再取消配置：
SELECT k.UserCode , k.FullName , p.UserCode , p.FullName , a.Qty ,a.Total
FROM IniGoodsStocks a
LEFT JOIN Stock k ON k.typeId = a.KtypeId
LEFT JOIN ptype p ON p.typeId = a.PtypeId
WHERE a.Qty < 0 OR a.Total < 0
SELECT k.UserCode , k.FullName , p.UserCode , p.FullName , a.Qty ,a.NQty
FROM Ini_GoodsStocks_Qty a
LEFT JOIN Stock k ON k.typeId = a.KtypeId
LEFT JOIN ptype p ON p.typeId = a.PtypeId
WHERE a.Qty < 0 OR a.NQty < 0
DELETE r FROM IniGoodsStocks r WHERE NOT EXISTS ( SELECT * FROM Stock k WHERE k.typeId = r.KtypeId )
DELETE r FROM Ini_GoodsStocks_Qty r WHERE NOT EXISTS ( SELECT * FROM Stock k WHERE k.typeId = r.KtypeId )