解决方案: |
在查询分析器中执行附件中的脚本文件,根据销售发票表、销售发货单表和销售出库单表的实际id号更改系统库表ua_identity update ufsystem..ua_identity set ichildid=(select max(autoid) from ufdata_055_2005..salebillvouchs), ifatherid=(select max(sbvid) from ufdata_055_2005..salebillvouchs) where cacc_id='055' and cvouchtype='billvouch' update ufsystem..ua_identity set ichildid=(select max(idlsid) from ufdata_055_2005..dispatchlists), ifatherid=(select max(dlid) from ufdata_055_2005..dispatchlists) where cacc_id='055' and cvouchtype='dispatch' update ufsystem..ua_identity set ichildid=(select max(autoid) from ufdata_055_2005..rdrecords), ifatherid=(select max(id) from ufdata_055_2005..rdrecords) where cacc_id='055' and cvouchtype='rd' 注意:请将脚本中的ufdata_055_2005中的055更改为实际的帐套号,然后再执行脚本 |