K3WISE 15.0,查询固定资产卡片报错

栏目:k3wise知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

K3WISE 15.0,查询固定资产卡片报错

K3WISE 15.0,查询固定资产报错


跟踪到的语句,手工执行也是报错,有没有大神指导下,哪里出错了,怎么修复
select v.FWorkBookID,v.FAlterID,v.FYear,v.FPeriod,v.FCleared,v.FNew,v.FOtherAlter, v.FDate,v.FAssetID,v.FAssetNumber,v.FAssetName,v.fincometax, v.FDeprPolicyID,v.FPolicyName ,v.FPolicyNumber,v.FAssetDetailID,v.FDeprDetailID,(v.FLifePeriods - bal1.fdeprperiods) as FLifeRemain,v.FAssetAcctName,v.FDeprAcctName ,FWorkCenter=twc.FName,FCostCenter=tcc.FName,space(255) as FAssetDetail,space(255) as FDeprDetail into #TmpCardTable8648 from (select vv.*,bal.forgvalp,bal.fnump,bal.faccumdeprp,i.fincometax,card.FAssetDetailID,card.FDeprDetailID from vw_fa_card vv left join t_fabalance bal on vv.fassetid=bal.fassetid and vv.fyear=bal.fyear and vv.fperiod=bal.fperiod left join t_fabalcard i on bal.Fbalid=i.Fbalid left join t_FACard Card on Card.FAlterID = vv.FAlterID) v left join t_facarditem t1 on v.FAlterID=t1.FAlterID left join vw_fa_expense p on p.FAlterID=v.FAlterID left join (select fdeprperiods,FAssetID from t_fabalance B where FYear=2018 and Fperiod=5) bal1 on bal1.FAssetID = v.FAssetID left join t_WorkCenter twc on twc.FItemID=v.FWorkCenterID left join t_BASE_CostCenter tcc on tcc.FItemID=v.FCostCenterID left join #TempOrderBy151244439359158 newTmp on v.FAlterID=newTmp.FAlterID where FWorkBookID='1' order by v.FAlterID,v.FYear,v.FPeriod,v.FAssetID


经过两天排查,发现了 一个数据库和一个视图,金蝶升级脚本没有写完全,导致升级有错误。代码无法上传,需要的发邮件szfw #*****## qq.com
错误代码:3604(E14H)
Source :Microsoft OLE DB Provider for SQL Server
Detail :多次为 'v' 指定了列 'FAssetDetailID'。
1.重启服务器电脑;
2.若还不行,备份账套后,进行数据库日志收缩;
3.若还不行,做数据提单看看。
有没有老师回复下

K3WISE 15.0,查询固定资产卡片报错

K3WISE 15.0,查询固定资产报错跟踪到的语句,手工执行也是报错,有没有大神指导下,哪里出错了,怎么修复select v.FWorkBookID,v.FAlter...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息