服务热线:020-82116603

常识库

材料出库单生成凭证时有差异科目

发布于:2018-02-12 17:52:58

问题现象:用户使用计划价核算,暂估方式为单到回冲,在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)

澳门皇冠威尼斯人常识

澳门皇冠威尼斯人App 为您提供最优质的产品和服务

产品报价:

详情请咨询澳门皇冠威尼斯人:020-82116603

XML 地图 | Sitemap 地图