14.2固定资产变动 报下标越界
有三张卡片, 要变动, 结果出错, 之后这几张就一值 是下标越界, 其他的卡片 正常..
反结账到上一期, 编辑卡片, 报 以后期间已经有变动,不允许修改,
但查找不到后面的变动卡片.
sql一时还无法看到问题,这种提示是程序访问到不正确的信息造成的,可能需要开发根据客户账套跟踪分析,建议提数据提单
[code]select v.*, t.FName_Cht as FDeprMethodName_Cht, t.FName_En as FDeprMethodName_En,i.fincometax,i.FdifIncomeTax ,FWorkCenter=twc.FName,FCostCenter=tcc.FName from (select * from vw_fa_card where FAlterID= 8454 ) as v left join T_FaDeprMethod as t on v.FDeprMethodID = t.FID left join t_fabalance bal on v.fassetid=bal.fassetid and v.fyear=bal.fyear and v.fperiod=bal.fperiod left join t_fabalcard i on bal.Fbalid=i.Fbalid left join t_workCenter twc on twc.FItemID=v.FWorkCenterID left join t_BASE_CostCenter tcc on tcc.FItemID=v.FCostCenterID
go
select * from t_faclear where FAlterID=8454
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select * from t_facarditemdefine where fbasic=0 order by fname
go
select c.* from t_facarditem c where c.FAlterID=8454 and c.FAMulAlterClassID=0
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select FAlterID,FYear,FPeriod from t_faalter where FAssetID=3113 and (FYear*1000+FPeriod)=2016002 order by FYear,FPeriod,FAlterNum
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select FAlterID,FYear,FPeriod from t_faalter where FAssetID=3113 and (FYear*1000+FPeriod)<2016002 order by FYear,FPeriod,FAlterNum
[/code]
[code] select count(*) FIsFind from t_FABalCard C inner join t_FABalance B on C.FBalID = B.FBalID Inner Join (select Sum(cast(isnull(FNew,0) as int)) FIsNew,FYear,FPeriod,FAssetID From t_FAAlter Where FYEAR = 2016 And FPERIOD = 2 And FASSETID = 3113 group by FAssetID,FYear,FPeriod ) Temp on B.FAssetID = Temp.FAssetID and B.FYear = Temp.FYear and B.FPeriod = Temp.FPeriod where FModule = 'CL' and isnull(Temp.FIsNew,0) = 1
go
select FBalID,FNumAlter,FDeprPeriods,FWorkLoad,FNumP,FOrgValP,FAccumDeprP,FDecPreP,FOrgValInc,FOrgValDec,FAccumDeprInc,FAccumDeprDec,FDecPreDec,FDecPreInc,FYtdDecPreInc,FYtdDecPreDec,FDeprShould,FDepr,FYtdDeprInc,FYtdDeprDec,FYtdOrgValInc,FYtdOrgValDec from t_FABalance where FAssetID=3113 and FYear=2016 and FPeriod=2
go
select a.FNum FOthNum,a.FAMiuValueRead FOthAMiuValueRead, a.FResidueVal FOthResidueVal from t_faCard a left join t_faalter b on a.falterid=b.falterid where a.FAlterID=8454
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FOrgValCur=(FOrgValP + FOrgValInc - FOrgValDec), FAccumDeprCur=(FAccumDeprP+FAccumDeprInc-FAccumDeprDec+FDepr),FDeprPeriodsCur=FDeprPeriods,FPeriodCur='2016年2期' from t_FABalance where FAssetID=3113 and FYear=2016 and FPeriod=2
go
select a.FAccumDeprP as FAccumDeprP1,a.FDepr as FDepr1,a.FDeprPeriods as FDeprPeriods1,isnull(b.FPurAmountP,0) as FOldPurAmtP from t_fabalance a left join t_FaBalPurchase b on a.FBalID=b.FBalID where a.fassetid=3113 and a.FYear=2016 and a.FPeriod=2
go
select * from vw_fa_device where FAlterID=8454
go
select * from vw_fa_orgfor where FAlterID=8454
go
select * from vw_fa_orgfor where FAlterID=8454
go
select * from t_FAPicture where FAlterID=8454
go
select FID,FAlterID,FBarCode,FRemark from t_FABarCode where FAlterID=8454 Order By FBarCode
go
select * from vw_fa_dept where FAlterID=8454
go
select * from vw_fa_expense where FAlterID=8454
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select i.FItemID,ISNULL(i.FNumber,'') as FItemNumber,ISNULL(i.FName,'') as FItemName,ic.FItemClassID,ic.FNumber as FItemClassNumber,ic.FName as FItemClassName From t_ItemDetailV vd Left Outer join t_Item i ON vd.FItemID = i.FItemID,t_ItemClass ic Where vd.FDetailID = 138 And vd.FItemClassID = ic.FItemClassID Order By vd.FItemClassID
go
SELECT FAssetDetailID,FDeprDetailID FROM t_FACard WHERE FAlterID=8454
go
select FAlterID,FBarcode,FRemark from t_FABarCode where FAlterID=8454
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select a.FAlterID from t_FAAlter a left join t_facard b on a.FAlterID=b.FAlterID where FAssetID=3113 and FYear=2016 and FPeriod=2
[/code]
[code]以下为跟踪到的语句
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select FAlterID,FYear,FPeriod from t_faalter where FAssetID=3113 and (FYear*1000+FPeriod)<=2016002 order by FYear,FPeriod,FAlterNum
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select v.*, t.FName_Cht as FDeprMethodName_Cht, t.FName_En as FDeprMethodName_En,i.fincometax,i.FdifIncomeTax ,FWorkCenter=twc.FName,FCostCenter=tcc.FName from (select * from vw_fa_card where FAlterID= 8454 ) as v left join T_FaDeprMethod as t on v.FDeprMethodID = t.FID left join t_fabalance bal on v.fassetid=bal.fassetid and v.fyear=bal.fyear and v.fperiod=bal.fperiod left join t_fabalcard i on bal.Fbalid=i.Fbalid left join t_workCenter twc on twc.FItemID=v.FWorkCenterID left join t_BASE_CostCenter tcc on tcc.FItemID=v.FCostCenterID
go
select * from t_faclear where FAlterID=8454
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select * from t_facarditemdefine where fbasic=0 order by fname
go
select c.* from t_facarditem c where c.FAlterID=8454 and c.FAMulAlterClassID=0
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select FAlterID,FYear,FPeriod from t_faalter where FAssetID=3113 and (FYear*1000+FPeriod)=2016002 order by FYear,FPeriod,FAlterNum
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
Select FAlterID,FYear,FPeriod from t_faalter where FAssetID=3113 and (FYear*1000+FPeriod)<2016002 order by FYear,FPeriod,FAlterNum
[/code]
数据问题,要后台跟踪账套,联系服务人员吧
14.2固定资产变动 报下标越界
本文2024-09-16 15:46:21发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-4962.html