【问题描述】

根据仓库的实际业务，需要修改库存更新控制方式。

【解决方案】

以下举例为现库存更新控制方式为“单据保存后立即更新”，修改为“单据审核后立即更新”的处理步骤，反之步骤相同。

1、审核所有库存单据，暂停业务；

2、执行以下语句更新库存更新控制方式。

if not exists
(select 1 from POStockBill where FStatus=0 and FCancellation = 0 union all
select 1 from ICSTJGBill where FStatus=0 and FCancellation = 0 union all
select 1 from POInStock where FStatus=0 and FCancellation = 0 union all
select 1 from ICStockBill where FStatus=0 and FCancellation = 0 union all
select 1 from ZPStockBill where FStatus=0 and FCancellation = 0 union all
select 1 from ICVMIInStock where FStatus=0)
begin

--更改系统参数表
update t_SystemProfile set fvalue = 0    --0为审核更新，1为保存更新
WHERE fcategory='ic' and fkey='UPSTOCKWHENSAVE'     

--更改库存单据表POStockBill、ICSTJGBill、POInStock、ICStockBill、ZPStockBill、ICVMIInStock中字段 fUPSTOCKWHENSAVE 的值，与系统参数表中的值相同
update POStockBill set FUpStockWhenSave = 0
update ICSTJGBill set FUpStockWhenSave = 0
update POInStock set FUpStockWhenSave = 0
update ICStockBill set FUpStockWhenSave = 0
update ZPStockBill set FUpStockWhenSave = 0
update ICVMIInStock set FUpStockWhenSave = 0

--校对即时库存
exec CheckInventory
print('库存更新控制方式变更成功')
end
else
begin
print('账套中还有库存单据未审核，请审核后再执行！')
end

3、执行完成后再继续进行业务。

【注意事项】

变更库存更新控制方式时，切记需将全部库存单据审核完成后再进行变更。