处理入库异常

1 调整条码状态
update [Udit.CSR].[dbo].[入库条码异常_copy1] set [STATUS]=0
where [WMS收料单号]=’22250327W32F’ and [STATUS]=12

2 调整收料单入库数量
update [Udit.Mms].[dbo].[mms_receivedetail] set [InNum]=Num
where [BillNo] = ‘22250327W32F’ and Num>0 and [InNum]=0

3 调整入库单