【问题描述】

旗舰版销售出库单下推了发票删除后，再次下推发票钩稽时提示“单据没有钩稽数量，不能钩稽”？

【原因分析】

原因为销售出库单上的钩稽数量不为0导致。

【解决方案】

可参考以下脚本执行处理：

select * into ICStockBillEntry_bak from ICStockBillEntry

go

update t1 set FHookStatus = 0, FHookInterID = 0

from ICStockBill t1 join ICStockBillEntry t2 on t1.FInterID = t2.FInterID 

left join ICHookRelations t3 on t2.FInterID = t3.FIBInterID and t2.FEntryID = t3.FEntryID and t3.FIBTag = 1 and t1.FTranType = t3.FTranType

where t1.FTranType = 21 and t2.FAllHookQTY <> 0 and t3.FGroupNo is null

go

update t2 set FAllHookQTY = 0, FCurrentHookQTY = 0, FAllHookAmount = 0, FCurrentHookAmount = 0, FStdAllHookAmount = 0, FStdCurrentHookAmount = 0

from ICStockBill t1 join ICStockBillEntry t2 on t1.FInterID = t2.FInterID 

left join ICHookRelations t3 on t2.FInterID = t3.FIBInterID and t2.FEntryID = t3.FEntryID and t3.FIBTag = 1 and t1.FTranType = t3.FTranType

where t1.FTranType = 21 and t2.FAllHookQTY <> 0 and t3.FGroupNo is null

go

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。