采购系统账表查询问题-用友U8

对应版本:用友U8.52对应产品线：供应链对应模块：采购管理模块问题现象:未完成业务明细帐的未完成金额应该不等于采购暂估表的本期结余金额，差额很大问题原因：数据错误解决方案：对于有正确的iaprice的值的数据执行脚本：updaterdrecordssetimoney=CONVERT(DECIMAL(20,2),iaprice)whereconvert(decimal(20,4),iquantity)=convert(decimal(20,4),isquantity)andisnull(imoney,0)iapriceGOupdatepursettlevouchssetisvacost=rdrecords.facostfrompursettlevouchsleftjoinrdrecordsonrdrecords.autoid=pursettlevouchs.irdsidGOupdaterdrecordssetiaprice=convert(decimal(20,2),iquantity*facost)whereisquantity0GOupdaterdrecordssetimoney=convert(decimal(20,2),isquantity*facost)whereautoidin(selectautoidfromrdrecordswhereiquantityisquantityandisquantity0)GOupdaterdrecordssetiaprice=iprice,facost=iunitcostwhereisnull(iaprice,0)=0andisquantity0GOupdaterdrecordssetimoney=convert(decimal(20,2),isquantity*facost)whereisquantity0andisnull(imoney,0)=0GOupdatepursettlevouchssetisvaprice=convert(decimal(20,2),isvquantity*isvacost)GOupdaterdrecordssetimoney=CONVERT(DECIMAL(20,2),iaprice)whereconvert(decimal(20,4),iquantity)=convert(decimal(20,4),isquantity)andisnull(imoney,0)iapriceGOupdatepursettlevouchssetisvacost=rdrecords.facostfrompursettlevouchsleftjoinrdrecordsonrdrecords.autoid=pursettlevouchs.irdsidGOupdaterdrecordssetiaprice=convert(decimal(20,2),iquantity*facost)whereisquantity0GOupdaterdrecordssetimoney=convert(decimal(20,2),isquantity*facost)whereautoidin(selectautoidfromrdrecordswhereiquantityisquantityandisquantity0)GOupdaterdrecordssetiaprice=iprice,facost=iunitcostwhereisnull(iaprice,0)=0andisquantity0GOupdaterdrecordssetimoney=convert(decimal(20,2),isquantity*facost)whereisquantity0andisnull(imoney,0)=0GOupdatepursettlevouchssetisvaprice=convert(decimal(20,2),isvquantity*isvacost)GO

本文链接：https://www.bbsufida.com/u8/43357.html