最大单据号有误，需要修改
微信号：yyrjlls
技术咨询，有偿服务！
复制微信号
最大单据号有误，需要修改
库存出入库单据
update ufsystem..ua_identity
set ifatherid = (select max(id) from ufdata_012_2006..rdrecord),
ichildid = (select max(autoid) from ufdata_012_2006..rdrecords)
where cacc_id=＇012＇ and cvouchtype=＇RD'
销售订单
use ufsystem
update ua_identity set ifatherid=(select max(id)from ufdata_014_2005..so_somain),
ichildid=(select max(autoid)from ufdata_014_2005..SO_SODetails)
where cacc_id='014' and cvouchtype='so_somain'
发货单
use ufsystem
update ua_identity set ifatherid=(select max(dlid)from ufdata_014_2005..dispatchlist),
ichildid=(select max(idlsid)from ufdata_014_2005..dispatchlists)
where cacc_id='014' and cvouchtype='DISPATCH'
本文链接：https://www.bbsufida.com/u8/51275.html
