【问题描述】

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

【解决方案】

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

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

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

if not exists(select 1 from POStockBill where FStatus=0 and FCancellation = 0 union allselect 1 from ICSTJGBill where FStatus=0 and FCancellation = 0 union allselect 1 from POInStock where FStatus=0 and FCancellation = 0 union allselect 1 from ICStockBill where FStatus=0 and FCancellation = 0 union allselect 1 from ZPStockBill where FStatus=0 and FCancellation = 0 union allselect 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 = 0update ICSTJGBill set FUpStockWhenSave = 0update POInStock set FUpStockWhenSave = 0update ICStockBill set FUpStockWhenSave = 0update ZPStockBill set FUpStockWhenSave = 0update ICVMIInStock set FUpStockWhenSave = 0

–校对即时库存exec CheckInventoryprint(‘库存更新控制方式变更成功’)endelsebeginprint(‘账套中还有库存单据未审核，请审核后再执行！’)end

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

【注意事项】

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