用友软件升级后存货中暂估余额表不正确

问题现象：升级后存货中暂估余额表不正确，而且报销金额与红字回冲单的金额合计的绝对值不等。

解决方案：可以使用下面的脚本在查询分析器中针对错误帐套进行更改： update a set iaprice=ipprice,facost=ipuitcost from rdrecords a ier joi ia_subsidiary b o a.autoid=b.id where b.cvoutype i ('01','33') ad bflag2 ad cwhcode'01' ad isull(idebitdifcost,0)=0 ad isull(icreditdifcost,0)=0 ad isull(a.iaprice,0)isull(iaiprice,0) update a set iaprice=iprice,facost=iuitcost --select iprice,iaprice,ipprice,isull(b.iaiprice,0),isull(idebitdifcost,0),isull(icreditdifcost,0),* from rdrecords a ier joi ia_subsidiary b o a.autoid=b.id where b.cvoutype i ('01','33') ad bflag2 ad cwhcode'01' ad (isull(idebitdifcost,0)0 or isull(icreditdifcost,0)0) ad isull(a.iaprice,0)(isull(b.iaiprice,0)+isull(idebitdifcost,0)-isull(icreditdifcost,0)) update rdrecords set imoey=COVERT(DECIMAL(20,2),iaprice) where covert(decimal(20,4),iquatity)=covert(decimal(20,4),isquatity) ad isull(imoey,0)iaprice update rdrecords set imoey=covert(decimal(20,2),isquatity*facost) where autoid i(select autoid from rdrecords where iquatity isull(isquatity,0) ad isull(isquatity,0)0) update pursettlevouchs set isvacost=rdrecords.facost from pursettlevouchs left joi rdrecords o rdrecords.autoid=pursettlevouchs.irdsid where isull(pursettlevouchs.isvquatity,0)0 update pursettlevouchs set isvaprice=covert(decimal(20,2),isull(isvquatity,0)*isull(isvacost,0))