服务热线:400-6530-219

知识库

存货出库单列表和出库汇总不平

发布于:2018-02-14 18:55:22

问题现象:1、存货材料出库单列表和出库汇总不平,其中齐选的数据差一分钱,全部的查询差3分钱. 2:有一些存货在存货的暂估余额表中结存数量为0,金额不为0
解决方案:1、如果仍想对上,可以用下面的语句根据存货明细帐更改一下单据上的计划金额 update a set ipprice=iaoutprice from ia_subsidiary b inner join rdrecords a on b.id=a.autoid where dvoudate>='2005-5-1' and cvoutype='11' and isnull(iaoutprice,0)<>isnull(ipprice,0) 问题2:可以使用下面语句进行更改: update b set facost=ipunitcost from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and facost is null and caccounter is not null update a set isvacost=facost,isvaprice=convert(decimal(20,2),isvquantity*facost) from pursettlevouchs a inner join rdrecords b on a.irdsid=b.autoid where isnull(facost,0)<>isnull(isvacost,0) and facost is not null and isvquantity<>0 update b set facost=isnull(iaprice/iquantity,0) from rdrecord a inner join rdrecords b on a.id=b.id where cvouchtype='01' and caccounter is not null and isnull(iaprice/iquantity,0)-isnull(facost,0)>0.01 and facost is not null

用友知识

用友软件 为您提供最优质的产品和服务

产品报价:

详情请咨询广州用友:020-82116603