T+12.1存货31001 出库审核提示“在当前期间不够出库，小于当前存货总账数量”

存货31001 出库审核提示“在当前期间不够出库，小于当前存货总账数量” 销货单自动出库，所以是在审核销货单时提示的。

问题原因：存货明细账中多了一行销售出库单号为“IO-2017-03-0044”记录。

解决方法： 

1、执行修复数据脚本。 

--处理31001存货错误数据 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