云星空修改库存更新方式
可参考以下脚本处理:
--直接更新系统参数表T_BAS_SYSPARAMETER里对应组织的库存参数(FPARAMETEROBJID='STK_StockParameter')设置的xml设置值(<UpdateStockPoint>1</UpdateStockPoint> ),1是保存时,2是审核时
update T_BAS_SYSPARAMETER set FPARAMETERS='<STKStockParameter>
<UpdateStockPoint>1</UpdateStockPoint>
<ClearAtSameTime>True</ClearAtSameTime>
<BatchNumPickRegulation>2</BatchNumPickRegulation>
<QGPPickRegulation>1</QGPPickRegulation>
<LotManageLevel>2</LotManageLevel>
<ControlSerialNo>True</ControlSerialNo>
<SerialManageLevel>M</SerialManageLevel>
<PlusAndMinus>3</PlusAndMinus>
<OneZeroInv>2</OneZeroInv>
</STKStockParameter>' where FPARAMETEROBJID='STK_StockParameter'
--直接更新系统参数表T_BAS_SYSPARAMETER里对应组织的库存参数(FPARAMETEROBJID='STK_StockParameter')设置的xml设置值(<UpdateStockPoint>1</UpdateStockPoint> ),1是保存时,2是审核时
update T_BAS_SYSPARAMETER set FPARAMETERS='<STKStockParameter>
<UpdateStockPoint>1</UpdateStockPoint>
<ClearAtSameTime>True</ClearAtSameTime>
<BatchNumPickRegulation>2</BatchNumPickRegulation>
<QGPPickRegulation>1</QGPPickRegulation>
<LotManageLevel>2</LotManageLevel>
<ControlSerialNo>True</ControlSerialNo>
<SerialManageLevel>M</SerialManageLevel>
<PlusAndMinus>3</PlusAndMinus>
<OneZeroInv>2</OneZeroInv>
</STKStockParameter>' where FPARAMETEROBJID='STK_StockParameter'