存貨31001 出庫審核提示“在當前期間不夠出庫，小于當前存貨總賬數(shù)量” 銷貨單自動出庫，所以是在審核銷貨單時提示的。

問題原因：存貨明細賬中多了一行銷售出庫單號為“IO-2017-03-0044”記錄。

解決方法： 

1、執(zhí)行修復(fù)數(shù)據(jù)腳本。 

--處理31001存貨錯誤數(shù)據(jù) DELETE FROM ST_SubsidiaryBookWHERE id = 2353995UPDATE ST_AssistantDataBookSET outQuantity = outQuantity - sumquantity , outAmount = outAmount- sumAmount , outVoucherAmount = outVoucherAmount-sumOutVoucherAmount , asOutQuantityAmount = asOutQuantityAmount- sumOutAmount , outExpenseAmount = outExpenseAmount-sumoutexpenseamountFROM ST_AssistantDataBook JOIN ( SELECT r.assistantDataBookID , SUM(r.quantity) AS sumQuantity , SUM(r.amount) AS sumAmount , SUM(r.outAmount) AS sumOutAmount , SUM(outVoucherAmount) AS sumOutVoucherAmount , SUM(ISNULL(r.outAmount, 0) - ISNULL(r.outVoucherAmount, 0)) AS sumoutexpenseamount FROM ST_AssistantDataRelation rWHERE r.[subsidiaryBookID] = 2353995 GROUP BY r.assistantDataBookID ) a ON ST_AssistantDataBook.id = a.assistantDataBookID DELETE FROM ST_AssistantDataRelation WHERE [subsidiaryBookID] = 2353995