問題現(xiàn)象：用戶使用計劃價核算，暫估方式為單到回沖，在9-10月份采購結算后，發(fā)現(xiàn)存貨暫估余額表中的報銷金額是實際金額而非計劃價！但是，存貨明細帳上顯示的紅藍回沖單都是計劃價！檢查后發(fā)現(xiàn)，入庫單上暫估金額為0，當采購結算時，將發(fā)票金額回寫到暫估金額上了！現(xiàn)在，已經(jīng)將庫存選項中入庫單自動代出選中，再做業(yè)務沒有此問題。但是，以前的單據(jù)不知道怎么辦？能不能直接修改入庫單上的暫估單價！ 解決方案：可以使用附件中的更改語句在查詢分析器中針對數(shù)據(jù)帳套執(zhí)行，以進行更改 --更改 update b set iaprice=convert(decimal(20,2),isnull(iaprice,0)) from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and isnull(iaprice,0)<>0 update b set iunitcost=convert(decimal(20,2),isnull(iprice,0))/iquantity from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and iaprice is not null and caccounter is not null and iunitcost is null and isnull(iprice,0)<>0 and isnull(iquantity,0)<>0 update b set facost=iunitcost from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and iaprice is not null and caccounter is not null and facost is null and isnull(iprice,0)=isnull(iaprice,0) update b set facost=convert(decimal(20,2),isnull(iaprice,0))/iquantity from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and iaprice is not null and caccounter is not null and facost is null and isnull(iprice,0)<>isnull(iaprice,0) and isnull(iquantity,0)<>0 update a set isvacost=b.facost from pursettlevouchs a left join rdrecords b on b.autoid=a.irdsid update a set isvaprice=convert(decimal(20,2),isvquantity*isvacost) from pursettlevouchs a left join rdrecords b on b.autoid=a.irdsid where isnull(a.isvquantity,0)<>isnull(b.isquantity,0) update a set isvaprice=convert(decimal(20,2),b.imoney) from pursettlevouchs a left join rdrecords b on b.autoid=a.irdsid where isnull(a.isvquantity,0)=isnull(b.isquantity,0)