初始设置中增加产品结构时报错产品出库后，库存数量不减出库单累计产品，不累计数量-用友U8

对应版本:用友U8.61对应产品线：供应链对应模块：库存管理模块问题现象:初始设置中增加产品结构时报错产品出库后，库存数量不减出库单累计产品，不累计数量问题原因：数据库问题解决方案：最大单据号问题,请按以下步骤处理：备份ufsystem数据库后修改;在查询分析器中ufsystem数据库下执行:updateufsystem..ua_identitysetiFatherId=(selectmax(bomid)fromUFDATA_001_2006..bom_bom),iChildId=(selectmax(bomid)fromUFDATA_001_2006..bom_bom)wherecacc_id=’001’andcVouchType=’bom_bom’updateufsystem..ua_identitysetiFatherId=(selectmax(bomid)fromUFDATA_001_2006..bom_parent),iChildId=(selectmax(bomid)fromUFDATA_001_2006..bom_parent)wherecacc_id=’001’andcVouchType=’bom_Parent’updateufsystem..ua_identitysetiFatherId=(selectmax(bomid)fromUFDATA_001_2006..bom_OpComponent),iChildId=(selectmax(OpComponentId)fromUFDATA_001_2006..bom_OpComponent)wherecacc_id=’001’andcVouchType=’bom_OpComponent’updateufsystem..ua_identitysetiFatherId=(selectmax(bomid)fromUFDATA_001_2006..bom_OpComponent),iChildId=(selectmax(OptionsId)fromUFDATA_001_2006..bom_OpComponentOpt)wherecacc_id=’001’andcVouchType=’bom_OpComponentOpt’

本文链接：http://www.bbsufida.com/u8/45912.html