问题现象: | 客户作期末处理时,提示“报尚有暂估报销单据未进行结算成本处理”,采购已经全部结算,暂估结算处理已经全部处理,包括部分结算的。但期末处理还这样提示。通过后台跟踪,跟踪的语句在附件,跟踪的结果也在附件。申请远程处理,急,等结账。 |
问题原因: | |
解决方案: | 您好,已就该问题与用户赖先生电话沟通并远程,此问题【经查看数据】现做如下分析与答复: 【问题原因】 经检查发现导致该问题原因为以前年度的暂估入库单记账后在后台ia_subsidiary表中的暂估标识不正确,建议打上相关模块(如存货、采购、平台、年结等)的最新补丁后跟踪测试。 【解决方案】 执行如下脚本前请做好数据备份! update ia_subsidiary set bflag=1 from ia_subsidiary where id in( select ia_subsidiary.id FROM IA_EstiSettle left join aa_enum a on IA_EstiSettle.cBusType=a.enumcode and enumtype='IA.Bustype' and localeid=DBO.UDF_GetLocaleID() INNER JOIN Inventory ON IA_EstiSettle.cInvCode = Inventory.cInvCode Left JOIN RdRecords ON IA_EstiSettle.iRdsID = RdRecords.AutoID Left join ia_subsidiary on RdRecords.autoid=ia_subsidiary.id -- and ia_subsidiary.bFlag=1 left join RdRecord on RdRecords.id=RdRecord.id WHERE (isnull(RdRecords.cBAccounter,'')<>'' or IA_EstiSettle.iRdsID=0) and (((isnull(IA_EstiSettle.iSVQuantity,0)=0 and isnull(IA_EstiSettle.iRdsid,0)=0) or (isnull(IA_EstiSettle.iSVQuantity,0)=0 and isnull(IA_EstiSettle.iRdID,0)=0) or (isnull(IA_EstiSettle.iSVQuantity,0)=0 and isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype=N'01' or (ia_subsidiary.cvoutype=N'33' and ia_subsidiary.csrcvoutype = N'01')))) or (isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype=N'01' or (ia_subsidiary.cvoutype=N'33' and ia_subsidiary.csrcvoutype = N'01')))) and IA_EstiSettle.dSVDate<='2011-12-31' AND (IA_EstiSettle.bAccount=0) and (isnull(IA_EstiSettle.iSVQuantity,0)<>0 or isnull(IA_EstiSettle.iSVPrice,0)<>0) AND IA_EstiSettle.cWhCode IN (N'01',N'02',N'04',N'05',N'06',N'07',N'08',N'09',N'10') AND (IsNull(IA_EstiSettle.cVouchType,N'01') = N'01' Or (IsNull(IA_EstiSettle.cVouchType,N'') = N''))) and cbustype<>'分期收款' 【注意事项】修改前请务必做好数据备份;可在测试环境下先行引入用户数据后执行脚本测试验证 |
相关补丁: | |
版本: | 8.90 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 期末处理报尚有暂估报销单据未进行结算成本处理 |
最后更新: | 2012-01-18 23:56:18 |