核算维度明细账查询报错：查询出现异常。多次为 'bt0' 指定了列 'FID'。

INSERT INTO TMPEB87BA00BF9811EB80DB0050568 (FF100012_ID, FF100012_GROUPID, FF100012_LEVEL, FF100012_FULLPARENTID) SELECT TOP 100000 FF100012_ID, FF100012_GROUPID, FF100012_LEVEL, FF100012_FULLPARENTID FROM (SELECT FID ff100012_id, FGROUPID ff100012_groupid, FLEVEL ff100012_level, FFULLPARENTID ff100012_fullparentid FROM (SELECT FID, FID, FFORBIDSTATUS, FNUMBER, 0 fgroupid, 1 flevel, ' ' ffullparentid FROM THDZ_t_Cust100001 WHERE F_THDZ_GROUP = 0 UNION SELECT T0.FID, T0.FID, T0.FFORBIDSTATUS, T0.FNUMBER, BTGLL0.FID fgroupid, BTGLL0.FLEVEL, FFULLPARENTID FROM THDZ_t_Cust100001 T0 INNER JOIN THDZ_HTBH_FZLEVEL BTGLL0 ON BTGLL0.FID = T0.F_THDZ_GROUP UNION SELECT T0.FID, T0.FID, T0.FFORBIDSTATUS, T0.FNUMBER, 0 fgroupid, (BTGLL0.FLEVEL + 1) flevel, ((BTGLL0.FFULLPARENTID + '.') + CONVERT(VARCHAR(8000), T0.FID)) ffullparentid FROM THDZ_t_Cust100001 T0 INNER JOIN THDZ_HTBH_FZLEVEL BTGLL0 ON (BTGLL0.FID = T0.F_THDZ_GROUP AND (BTGLL0.FLEVEL < 1)) UNION SELECT T0.FID, T0.FID, T0.FFORBIDSTATUS, T0.FNUMBER, 0 fgroupid, 2 flevel, BTGLL0.FFULLPARENTID FROM THDZ_t_Cust100001 T0 INNER JOIN THDZ_HTBH_FZLEVEL BTGLL0 ON (BTGLL0.FID = T0.F_THDZ_GROUP AND BTGLL0.FLEVEL = 1)) bt0 WHERE ((1 = 1 AND BT0.FFORBIDSTATUS = 'A') AND EXISTS (SELECT 1 FROM THDZ_t_Cust100001 T0 WHERE T0.FID = BT0.FID)) UNION ALL SELECT 0 ff100012_id, 0 ff100012_groupid, 0 ff100012_level, ' ' ff100012_fullparentid) a

Server stack trace:

在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)

在 Kingdee.K3.FIN.GL.App.Core.FlexDetailReportService.GetFlexTempTable(Context ctx, List`1 lstFlexItemTableObject, FlexDetailFilterObject filterObject, List`1 lstAcctIds, Int32 intAcctSystemId, Int32 intAccountOrgId, Boolean bIsCheckCount, Boolean& blIsGroup)

在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFlexDetailInfo()

在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.SetFilterObject(DynamicObject objCustomFilter)

在 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.GetList(IRptParams rptParams)

在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)

在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)

在 Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)

产品问题核算维度明细账查询报错：查询出现异常。多次为 'bt0' 指定了列 'FID'。

产品问题 核算维度明细账查询报错：查询出现异常。多次为 'bt0' 指定了列 'FID'。

恭喜您！

产品问题
核算维度明细账查询报错：查询出现异常。多次为 'bt0' 指定了列 'FID'。

产品问题核算维度明细账查询报错：查询出现异常。多次为 'bt0' 指定了列 'FID'。