webERP4.05在输入工作单时点击物料查找,出现
消息 提示信息 : 没有物料符合指定的条件
消息 提示信息 : 使用的SQL是:
SELECT stockmaster.stockid, stockmaster.description, stockmaster.units FROM stockmaster, stockcategory WHERE stockmaster.categoryid=stockcategory.categoryid AND (stockcategory.stocktype='F' OR stockcategory.stocktype='D') AND stockmaster.discontinued=0 AND mbflag='M' ORDER BY stockmaster.stockid LIMIT 50