处理: 1:未在流水中出现的单据 1:先回退状态到03,已验收, update tb_usc_import_master set status='03' where import_master_id in('RK20170512100848') 2:然后界面进行验收操作。之后更新以下表 修正库存: select t.jit_stock_sum_qty,t.jit_stock_available_qty from tb_usc_jit_stock t where t.barcode is not null and t.jit_stock_sum_qty>1 update tb_usc_jit_stock set jit_stock_sum_qty=1,jit_stock_available_qty=1 where barcode is not null and jit_stock_sum_qty>1 修正采购表 select * from tb_usc_po_detail dtl where dtl.po_quantity