百科问答

百科问答 国内资讯 公司资讯 政策法规 培训资料 产品下载 常见问题

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

发布时间:2026-10-9 

特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品8折优惠,另有话费赠送。

 

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

解决方案:可以使用下面的脚本在查询分析器中针对错误帐套进行更改: 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))






X畅捷通软件官方正版.用友软件.企业云服务

截屏,微信识别二维码

客服QQ:5151867

(点击QQ号复制,添加好友)