核算单据查询中修改成本,提示报错
金蝶云社区-云社区用户29KU1234
云社区用户29KU1234
0人赞赏了该文章 1,173次浏览 未经作者许可,禁止转载编辑于2014年09月24日 17:32:50

核算单据查询中修改成本,提示报错:
发生时间: 2014-09-24 05:29:21
错误编号: BOS_ExecuteReader
错误信息: Invalid object name 'temp'.
Sql语句: SELECT dime.FMASTERID, dime.FLOTNumber, dime.FStockId, dime.FStockLocId, dime.FBOMId, dime.FPROJECTNO, dime.FMtoNo, dime.FAuxPropId, dime.FAcctgRangeId, dime.FVALUATIONMETHOD, process.FEntryId, process.FDimeEntryId, m.FNumber fmaterialnumber, ISNULL(ml.FName, ' ') fmaterialname, process.FMustSameLevel fseq FROM T_HS_AcctgProcess process INNER JOIN T_HS_STOCKDIMENSION dime ON process.FDimeEntryId = dime.FEntryId INNER JOIN t_bd_Material m ON m.FMaterialId = dime.FMASTERID LEFT OUTER JOIN t_bd_Material_l ml ON (m.FMaterialId = ml.FMaterialId AND ml.flocaleid = 2052) INNER JOIN "temp" ON process.FDimeEntryId = "TEMP".FDimeEntryId WHERE process.FID = @FAcctgId
===================================================
调用堆栈:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.Abstr