第一步,查询条数与K3预出库数量是否一致。
select * from ICSerial t1,t_icitem t3
WHERE t1.fitemid=t3.fitemid and t3.fnumber='长代码' and t1.fvalid=0
第二步,需要把作废未清除的单据在ICSerialFlow 删掉, 要在ICSerial把入库时的单据重新写进来,把fstatus和fvalid=1 改为1。
delete ICSerialFlow from ICSerial t1,ICSerialFlow t2,t_icitem t3
WHERE t1.fitemid=t3.fitemid and t3.fnumber='长代码' and t1.fvalid=0 and t1.FSerialID=t2.fserialid and t1.finterid=t2.finterid
update ICSerial
set ICSerial.finterid=t2.finterid,ICSerial.ftrantypeid=t2.ftrantypeid,ICSerial.FSNListID=t2.FSNListID,ICSerial.fstatus=1,ICSerial.fvalid=1 from ICSerial t1,ICSerialFlow t2,t_icitem t3
WHERE t1.fitemid=t3.fitemid and t3.fnumber='长代码' and t1.fvalid=0 and t1.FSerialID=t2.fserialid