查询物料收发汇总表报错

CLOUD6.0，最新补丁 联系QQ：625768457

MERGE INTO TMPFDD62F6FF62011E580C06C92BF2 IT USING (
SELECT TP.FGUID,TORG.FNUMBER AS FSTOCKORGNUMBER,TORGL.FNAME AS FSTOCKORGNAME,TMS.FSTOREURNUM AS FSTOREURNUM,TMS.FSTOREURNOM AS FSTOREURNOM,TM.FNUMBER AS FMATERIALNO,
ISNULL(TUB.FPRECISION,0) AS FBASEUNITPRE, ISNULL(TUS.FPRECISION,0) AS FSTOCKUNITPRE, ISNULL(TUA.FPRECISION,0) AS FSECUNITPRE,
TM.FNUMBER AS FMATERIALNUMBER,TML.FNAME AS FMATERIALNAME,TML.FSPECIFICATION AS FMATERIALMODEL,
TMB.FERPCLSID AS FERPCLSID,TMGL.FNAME AS FMATERIALGROUP, ISNULL(TMTL.FNAME,'') AS FMATERIALTYPENAME,
ISNULL(TMT.FCATEGORYID,0) AS FMATERIALTYPEID,TBS.FNUMBER AS FSTOCKNUMBER,TBSL.FNAME AS FSTOCKNAME,
CONVERT(NVARCHAR(1500), '') AS FSTOCKLOC,
CONVERT(NVARCHAR(1500), '') AS FSTOCKPOSNUMBER,
TBSS.FNUMBER AS FSTOCKSTATUSNUMBER,TBSSL.FNAME AS FSTOCKSTATUSNAME,
CASE TP.FOWNERTYPEID WHEN 'BD_Supplier' THEN '供应商' WHEN 'BD_Customer' THEN '客户' ELSE '业务组织' END AS FOWNERTYPENAME,
TKW.FNumber AS FOWNERNumber,TKWL.FNAME AS FOWNERNAME,
CASE TP.FKEEPERTYPEID WHEN 'BD_Supplier' THEN '供应商' WHEN 'BD_Customer' THEN '客户' ELSE '业务组织' END AS FKEEPERTYPENAME,
TKP.FNumber AS FKEEPERNumber,TKPL.FNAME AS FKEEPERNAME,
TBM.FNUMBER AS FBOMNO,TP.FMTONO,TMB.FBASEUNITID AS FBASEUNITID,TULB.FNAME AS FBASEUNITNAME,
TMS.FSTOREUNITID AS FSTOCKUNITID,TULS.FNAME AS FSTOCKUNITNAME, TMS.FAUXUNITID AS FSECUNITID,TULA.FNAME AS FSECUNITNAME
FROM TMPFDD62F6FF62011E580C06C92BF2 TP INNER JOIN T_BD_MATERIAL TM ON TP.FMATERIALID=TM.FMATERIALID
LEFT JOIN T_BD_STOCK TBS ON TP.FSTOCKID=TBS.FSTOCKID
INNER JOIN T_BD_MATERIALBASE TMB ON TP.FMATERIALID=TMB.FMATERIALID
LEFT JOIN T_ORG_ORGANIZATIONS TORG ON TP.FSTOCKORGID=TORG.FORGID
LEFT JOIN T_ORG_ORGANIZATIONS_L TORGL ON TORG.FORGID=TORGL.FORGID AND TORGL.FLOCALEID=@LocaleId
LEFT JOIN T_BD_MATERIAL_L TML ON TP.FMATERIALID=TML.FMATERIALID AND TML.FLOCALEID= @LocaleId
LEFT JOIN T_BD_MATERIALGROUP TMG ON TM.FMATERIALGROUP=TMG.FID
LEFT JOIN T_BD_MATERIALGROUP_L TMGL ON TMG.FID=TMGL.FID AND TMGL.FLOCALEID= @LocaleId
INNER JOIN T_BD_MATERIALSTOCK TMS ON TP.FMATERIALID=TMS.FMATERIALID
LEFT JOIN T_BD_MATERIALCATEGORY TMT ON TMB.FCATEGORYID=TMT.FCATEGORYID
LEFT JOIN T_BD_MATERIALCATEGORY_L TMTL ON TMT.FCATEGORYID=TMTL.FCATEGORYID AND TMTL.FLOCALEID= @LocaleId
LEFT JOIN V_ITEMCLASS_KEEPER TKP ON TP.FKEEPERID=TKP.FITEMID
LEFT JOIN V_ITEMCLASS_KEEPER_L TKPL ON TP.FKEEPERID=TKPL.FITEMID AND TKPL.FLOCALEID= @LocaleId
LEFT JOIN V_ITEMCLASS_OWNER TKW ON TP.FOWNERID=TKW.FITEMID
LEFT JOIN V_ITEMCLASS_OWNER_L TKWL ON TP.FOWNERID=TKWL.FITEMID AND TKWL.FLOCALEID= @LocaleId
LEFT JOIN T_BD_STOCK_L TBSL ON TP.FSTOCKID=TBSL.FSTOCKID AND TBSL.FLOCALEID= @LocaleId
LEFT JOIN T_BD_STOCKSTATUS TBSS ON TP.FSTOCKSTATUSID=TBSS.FSTOCKSTATUSID
LEFT JOIN T_BD_STOCKSTATUS_L TBSSL ON TBSS.FSTOCKSTATUSID=TBSSL.FSTOCKSTATUSID AND TBSSL.FLOCALEID= @LocaleId
INNER JOIN T_BD_UNIT TUB ON TMB.FBASEUNITID=TUB.FUNITID
INNER JOIN T_BD_UNIT TUS ON TMS.FSTOREUNITID=TUS.FUNITID
LEFT JOIN T_BD_UNIT TUA ON TMS.FAUXUNITID=TUA.FUNITID
LEFT JOIN T_BD_UNIT_L TULB ON TMB.FBASEUNITID=TULB.FUNITID AND TULB.FLOCALEID= @LocaleId
LEFT JOIN T_BD_UNIT_L TULS ON TMS.FSTOREUNITID=TULS.FUNITID AND TULS.FLOCALEID= @LocaleId
LEFT JOIN T_BD_UNIT_L TULA ON TMS.FAUXUNITID=TULA.FUNITID AND TULA.FLOCALEID= @LocaleId
LEFT JOIN T_ENG_BOM TBM ON TP.FBOMID=TBM.FID
LEFT JOIN T_BAS_FLEXVALUESDETAIL FVD ON TP.FSTOCKLOCID = FVD.FID


) IT2
ON (IT.FGUID = IT2.FGUID)
WHEN MATCHED THEN UPDATE
SET IT.FSTOREURNUM = IT2.FSTOREURNUM,IT.FSTOREURNOM = IT2.FSTOREURNOM,
IT.FMATERIALNO = IT2.FMATERIALNO,IT.FBASEUNITPRE = IT2.FBASEUNITPRE,
IT.FSTOCKORGNUMBER = IT2.FSTOCKORGNUMBER,IT.FSTOCKORGNAME = IT2.FSTOCKORGNAME,
IT.FSTOCKUNITPRE = IT2.FSTOCKUNITPRE,IT.FSECUNITPRE = IT2.FSECUNITPRE,
IT.FMATERIALNUMBER = IT2.FMATERIALNUMBER,IT.FMATERIALNAME = IT2.FMATERIALNAME,
IT.FMATERIALMODEL = IT2.FMATERIALMODEL,IT.FERPCLSID = IT2.FERPCLSID,
IT.FMATERIALGROUP = IT2.FMATERIALGROUP,IT.FMATERIALTYPENAME = IT2.FMATERIALTYPENAME,
IT.FMATERIALTYPEID = IT2.FMATERIALTYPEID,IT.FSTOCKNUMBER = IT2.FSTOCKNUMBER,
IT.FSTOCKNAME = IT2.FSTOCKNAME,IT.FSTOCKLOC = IT2.FSTOCKLOC,IT.FSTOCKPOSNUMBER = IT2.FSTOCKPOSNUMBER,
IT.FSTOCKSTATUSNUMBER = IT2.FSTOCKSTATUSNUMBER,IT.FSTOCKSTATUSNAME = IT2.FSTOCKSTATUSNAME,
IT.FOWNERTYPENAME = IT2.FOWNERTYPENAME,IT.FOWNERNUMBER = IT2.FOWNERNUMBER,IT.FOWNERNAME = IT2.FOWNERNAME,
IT.FKEEPERTYPENAME = IT2.FKEEPERTYPENAME,IT.FKEEPERNUMBER = IT2.FKEEPERNUMBER,IT.FKEEPERNAME = IT2.FKEEPERNAME,
IT.FBOMNO = IT2.FBOMNO,IT.FMTONO = IT2.FMTONO,IT.FBASEUNITID = IT2.FBASEUNITID,
IT.FBASEUNITNAME = IT2.FBASEUNITNAME,IT.FSTOCKUNITID = IT2.FSTOCKUNITID,
IT.FSTOCKUNITNAME = IT2.FSTOCKUNITNAME,IT.FSECUNITID = IT2.FSECUNITID,
IT.FSECUNITNAME = IT2.FSECUNITNAME ;
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, IEnumerable`1 paramList)
在 Kingdee.K3.SCM.App.Stock.Report.StockSummaryRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
在 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)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
在 Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.b__49()