存貨結(jié)存數(shù)量*單價不等金額
發(fā)布于：2018-02-13 14:05:23
問題現(xiàn)象：存貨結(jié)存數(shù)量*單價不等金額
解決方案：執(zhí)行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
