update sal_midetail set jpgb = 'MIBP', qty = -abs(qty), gggamt = -abs(gggamt), taxamt = -abs(taxamt), totalamt = -abs(totalamt), bpamt = -abs(totalamt)  where jpgb = 'BP'
update sal_miINFO set jpgb = 'MIBP' where jpgb = 'BP'
update sal_miinfo set JPGB = 'MIBP', miamt = 0, totalamt = -ABS(totalamt), bpamt = ABS(totalamt),  taxamt = -ABS(taxamt), gggamt = -abs(gggamt), misuamt = -abs(misuamt) where JPGB in ('MJBP', 'MIBP') and miamt >0 and ilja <2018-05-21

update bas_proddetail set meqty = qty where qty <> 1
update bas_proddetail set qty = 1 where meqty = qty