出庫(kù)單單價(jià)及數(shù)量是正數(shù),但金是負(fù)數(shù)
發(fā)布于：2018-02-05 13:58:08
問(wèn)題現(xiàn)象：出庫(kù)單單價(jià)及數(shù)量是正數(shù),但金是負(fù)數(shù)
解決方案：update rdrecords set iprice=b.iaoutprice from rdrecords a join ia_subsidiary b on a.autoid=b.id where b.brdflag=0 and a.iprice<>b.iaoutprice and a.iquantity*a.iunitcost<>a.iprice
