新建物料在做工程物料清单的时候层级物料没有带出物料属性，修改物料时系统提示：业务对象“物料:BD_MATERIAL”超过软件授权1000条记录的控制，则不能打开该业务对象所在子系统下的所有加密单据！

于是在社区找到相应的执行脚本“select * from T_HR_EMPINFO DELETE FROM T_HR_EMPINFO WHERE FID NOT IN (SELECT t1.FID FROM (SELECT top 100 FID FROM T_HR_EMPINFO ORDER BY FID ) AS t1); select * from T_BD_MATERIAL DELETE FROM T_BD_MATERIAL WHERE FMATERIALID NOT IN (SELECT t1.FMATERIALID FROM (SELECT top 100 FMATERIALID FROM T_BD_MATERIAL ORDER BY FMATERIALID ) AS t1); select * from t_BD_Supplier DELETE FROM t_BD_Supplier WHERE FSUPPLIERID NOT IN (SELECT t1.FSUPPLIERID FROM (SELECT top 100 FSUPPLIERID FROM t_BD_Supplier ORDER BY FSUPPLIERID ) AS t1); select * from T_BD_CUSTOMER DELETE FROM T_BD_CUSTOMER WHERE FCUSTID NOT IN (SELECT t1.FCUSTID FROM (SELECT top 100 FCUSTID FROM T_BD_CUSTOMER ORDER BY FCUSTID ) AS t1); select * from T_ENG_BOM DELETE FROM T_ENG_BOM WHERE FID NOT IN (SELECT t1.FID FROM (SELECT top 100 FID FROM T_ENG_BOM ORDER BY FID ) AS t1);”

在数据库执行脚本成功之后，再去做工程物料清单新增时找不到任何父项物料，于是去做物料的取消分配系统提示：，去查各组织下分配过去的物料一个都没有，但是系统提示已经分配过了，目前无解！

产品问题做了物料脚本执行后选不到物料清单父项物料

产品问题 做了物料脚本执行后选不到物料清单父项物料

恭喜您！

产品问题
做了物料脚本执行后选不到物料清单父项物料

产品问题做了物料脚本执行后选不到物料清单父项物料