问题现象: | 在合同导航----系统导航中查询合同阶段报警却发现已经结算及收款核销的合同阶段还会报警(例如合同号2011020030、2011020038等),而且报表中相关栏目数据显示也错位了. [2011-11-19 10:59:28 补充] 数据已经上传,文件名:问题号201111180204.rar |
问题原因: | |
解决方案: | 您好,问题原因: 合同结算的时候没有填数量 解决方案: 只能通过脚本执行 alter View CM_QStageAlert as select B.GUID,strContractID,strContractName,E1.EnumName as strContractKind,EB.cStageCode,cStageName,EB.cExecID, cast(EBEI.decExecMoney as decimal(30,2)) as decExecMoney, (EB.dtAuditdate+cast(SS.cValue as int)) as dtAlertDate from CM_ExecuteBill EB inner join (select cExecID,sum(isnull(decRateMoney,0)) as decExecMoney, sum(isnull(decBalanceCount,0)) as decJSCount from CM_ExecuteBills group by cExecID having sum(isnull(decBalanceCount,0))=0 and sum(isnull(decBalanceMoney ,0))=0 ) EBEI on EB.cExecID=EBEI.cExecID inner join (select distinct cExecID from CM_ExecuteBills where bClosed=0) EBNC on EB.cExecID=EBNC.cExecID inner join CM_Contract_B B on EB.cContractID=B.strContractID inner join CM_Stage SG on EB.cStageCode=SG.cStageCode inner join CM_SystemSet SS on SS.cName=N'iStageAlertDays' inner join AA_Enum E1 On E1.EnumType=N'CM.ContractKind' And E1.EnumCode=B.strContractKind And E1.LocaleId=dbo.UDF_GetLocaleID() where EB.dtAuditdate is not null and (EB.dtAuditdate+cast(SS.cValue as int)<=GetDate()) go 由于支持网问题请将上面的引号与加号改成英文。 如有问题请及时联系 u8支持 李春秋 lichq@ufida.com.cn |
相关补丁: | |
版本: | 8.90 |
模块: | 合同管理 |
产品: | 供应链 |
问题名称: | 问题号201111140152合同阶段问题补充 |
最后更新: | 2011-12-06 23:41:04 |