更改入库单单号及时间

wbv123

入库单修改单号及日期
create table #disable_u_accept_m (id int)
update u_accept_m set acceptno=’新单号’,execdate=’新日期’,createtime=’新日期’ where acceptno=’原单号’ and billcode=’ACC’
drop table #disable_u_accept_m

入库单更新下面商品明细
create table #disable_u_accept_c (id int)
update u_accept_c set acceptno=’新单号’ where acceptno=’原单号’
drop table #disable_u_accept_c