问题现象: | 861SP2应用财务和供应链一体化,8月份结完账后,核对存货核算暂估材料余额表的余额与总账模块的应付账款下的暂估应付款余额不等,经检查,暂估应付款制单都是根据存货核算系统自动生成的,并未手动录入暂估应付款的凭证;另外采购管理的采购结算余额表与存货核算的暂估材料余额表也不一致,客户不知道8月份暂估到底是按哪个数据为准,烦请总部给予帮助解决,不胜感谢 [2011-9-28 23:58:13 补充] 数据已上传到FTP上,文件名为201109280222.rar |
问题原因: | |
解决方案: | 您好,已就该问题与一线同事电话沟通,此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 经过检查发现问题原因为部分暂估入库单在rdrecords表中的facost暂估单价及pursettlevouchs表中的isvaprice暂估金额不正确导致。建议一线在用户处将861后续存货系统最新补丁打全并同步升级数据库脚本进行跟踪测试。 【解决方案】 执行如下脚本请做好数据备份! use ufdata_902_2011 update rdrecords set facost=dj from rdrecords join (SELECT Sub2.ID,sum (Sub2.IAInPrice) / sum(Sub2.IAInQuantity) as dj,(sum(iA_Subsidiary.IAInQuantity)* sum (Sub2.IAInPrice) / sum(Sub2.IAInQuantity))as je FROM (Inventory INNER JOIN IA_Subsidiary ON Inventory.cInvCode = IA_Subsidiary.cInvCode inner join rdrecords on rdrecords.autoid=IA_Subsidiary.id Left Join Rdrecord ON RdRecord.ID=Rdrecords.ID ) INNER JOIN IA_Subsidiary Sub2 ON (IA_Subsidiary.ID= Sub2.ID And Sub2.cVoutype= N'24' And IA_Subsidiary.Imonth= Sub2.Imonth) WHERE IA_Subsidiary.iMonth=7 And isnull(RdRecord.cBusType,'') <> N'受托代销' and (ia_subsidiary.psvsid is not null And ia_subsidiary.cvoutype = N'30') group by Sub2.ID )ia on rdrecords.autoid=ia.id where autoid in(SELECt distinct rdrecords.autoid FROM IA_Subsidiary inner join rdrecords on rdrecords.autoid=IA_Subsidiary.id Left Join Rdrecord ON RdRecord.ID=Rdrecords.ID WHERE IA_Subsidiary.cVouType= N'30' AND IA_Subsidiary.bFlag=2 AND IA_Subsidiary.iMonth=7 And isnull(RdRecord.cBusType,'') <> N'受托代销') update pursettlevouchs set isvacost=rds.facost,isvaprice=isvquantity*facost from pursettlevouchs join (select autoid,facost from rdrecords)rds on pursettlevouchs.irdsid=rds.autoid where id in(select pursettlevouchs.id from ((ia_subsidiary inner join pursettlevouchs on ia_subsidiary.psvsid=pursettlevouchs.id) inner join pursettlevouch on pursettlevouch.psvid=pursettlevouchs.psvid) inner join rdrecords on rdrecords.autoid=IA_Subsidiary.id Left Join Rdrecord ON RdRecord.ID=Rdrecords.ID INNER JOIN Inventory ON ia_subsidiary.cInvCode = Inventory.cInvCode left join ComputationUnit ON inventory.cComunitCode = ComputationUnit.ccomunitcode WHERE IA_Subsidiary.cWhCode IN (N'111',N'112',N'113',N'114',N'115',N'116',N'117',N'118',N'119',N'211',N'212',N'213',N'214',N'215',N'216',N'311',N'312',N'313',N'314',N'315',N'316',N'317',N'411',N'412',N'413',N'414',N'415',N'416',N'511',N'512',N'513',N'514',N'515',N'516',N'517',N'611',N'612',N'613',N'614',N'615',N'616',N'617',N'618',N'518',N'318',N'319',N'320',N'619',N'299') and cvoutype= N'30' and ia_subsidiary.bflag=2 And isnull(RdRecord.cBusType,'') <> N'受托代销' and (bispuracc<>baccount) AND IA_Subsidiary.iMonth<8 and ia_subsidiary.psvsid is not null ) 【注意事项】修改前请务必做好数据备份;可在测试环境下先行引入用户数据后打补丁测试验证 |
相关补丁: | |
版本: | 8.61 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 861暂估与总账对账不平 |
最后更新: | 2011-10-19 23:17:21 |