问题现象：用户使用计划价核算，暂估方式为单到回冲，在9-10月份采购结算后，发现存货暂估余额表中的报销金额是实际金额而非计划价！但是，存货明细帐上显示的红蓝回冲单都是计划价！检查后发现，入库单上暂估金额为0，当采购结算时，将发票金额回写到暂估金额上了！现在，已经将库存选项中入库单自动代出选中，再做业务没有此问题。但是，以前的单据不知道怎么办？能不能直接修改入库单上的暂估单价！ 解决方案：可以使用附件中的更改语句在查询分析器中针对数据帐套执行，以进行更改 --更改 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)