MRP选择任何的销售订单都报下面的错误
source:SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA1 a INNER JOIN @FID_udt2 t ON a.FCOMPUTEID = t.FID UNION ALL SELECT FMATERIALID, FMATERIALNUMBER, FCOMPUTEID FROM T_MRP_MATERIALDATA2 a INNER JOIN @FID_udt2 t ON a.FCOMPUTEID = t.FID
message:对象名 'T_MRP_MATERIALDATA1' 无效。
stacktrace: 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
在 Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.GetMaterialScopeLogicUnit.GetMrpMaterialInfo(List`1 lstTableName, List`1 lstComputerId)
在 Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.GetMaterialScopeLogicUnit.CheckMaterialConflictInfo()
在 Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.GetMaterialScopeLogicUnit.AfterExecuteLogicUnit()
在 Kingdee.K3.MFG.PLN.App.MrpModel.AbstractMrpLogicUnit.Execute()
在 Kingdee.K3.MFG.PLN.App.Core.MrpComputeService.RunMrp(Context ctx, DynamicObject mrpDataObject, OperateOption option)
inner exception:
source:.Net SqlClient Data Provider
message:对象名 'T_MRP_MATERIALDATA1' 无效。
stacktrace: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Bool
推荐阅读