一、问题描述

KIS专业版，做单输入物料代码提示代码在数据库不存在或者被禁用。

二、原因分析

客户新建账套在做销售订单是按F7可以看到13.001这个物料，双击选择以后出来下图提示：

数据库跟踪出来一下语句：

SELECT t2.FFullName  ,t_ICItem.*,t_ICItem.FSaleUnitID as FCUUnit_ID,t1.FName as FUnitName,t3.FName as FCUUnitName,t4.FName as FSecUnitName, t1.FNumber as FUnitNumber,t3.FNumber as FCUUnitNumber  FROM t_ICItem Left Join t_MeasureUnit t1 on t_ICItem.FUnitID=t1.FItemID  Inner join t_Item t2 on t_ICItem.FItemID=t2.FItemID    Left Join t_MeasureUnit t3 on t_ICItem.FSaleUnitID=t3.FItemID  Left Join t_MeasureUnit t4 on t_ICItem.FSecUnitID=t4.FItemID  Where t2.FDetail=1 AND t_ICItem.FDeleted=0  AND (t_ICItem.FNumber='13.001' OR t_ICItem.FShortNumber='13.001') and t_ICItem.FErpClsID NOT IN (6,8)