对一些品种数量校正

update sphwph set shl=1-1 where spid='SPH00002323' and pici='JHAYMA00017433_5 ' and hw='HWI00000022'

update sphwph set shl=-1+1 where spid='SPH00002323' and pici='JHAYMA00021159_2' and hw='HWI00000022'

3月7日调拨后少了398

update sphwph set shl=0+398 where pici='JHAYMA00024241_1' and spid='SPH00001472' and hw='HWI00000002'

3月25日退货入库少入200

update sphwph set shl=339+200 where pici='JHAYMA00013010_2' and spid='SPH00008367' and hw='HWI00000003'

转载于:https://blog.51cto.com/bks2015/1918469