| 解决方案： |
最大单据号问题,请按以下步骤处理：备份ufsystem 数据库后修改;在查询分析器中ufsystem数据库下执行:
update ufsystem..ua_identity set iFatherId=(select max(bomid) from UFDATA_001_2006..bom_bom),iChildId=(select max(bomid) from UFDATA_001_2006..bom_bom) where cacc_id='001'and cVouchType='bom_bom'
update ufsystem..ua_identity set iFatherId=(select max(bomid) from UFDATA_001_2006..bom_parent),iChildId=(select max(bomid) from UFDATA_001_2006..bom_parent)where cacc_id='001'and cVouchType='bom_Parent'
update ufsystem..ua_identity set iFatherId=(select max(bomid) from UFDATA_001_2006..bom_OpComponent),iChildId=(select max(OpComponentId) from UFDATA_001_2006..bom_OpComponent)where cacc_id='001'and cVouchType='bom_OpComponent'
update ufsystem..ua_identity set iFatherId=(select max(bomid) from UFDATA_001_2006..bom_OpComponent),iChildId=(select max(OptionsId) from UFDATA_001_2006..bom_OpComponentOpt)where cacc_id='001'and cVouchType='bom_OpComponentOpt'
|