问题现象: | 存货档案启用了自定义项2,并进行了数据的维护,在库存中的现存量和库存台帐查询时,查询窗体中的“存货编码”条件参照存货档案时只有自定义项2=第一个值的品种,但出入库流水帐中又可以参照,经跟踪,过滤不出其他类品种的代码如下: EXEC sp_executesql N'SELECT TOP 100 cast(0 as bit) as bRefSelectColumn,'''' as SelCol,[InventoryEntity_Inventory].[cInvCode] as cInvCode,[InventoryEntity_Inventory].[cInvName] as cInvName,[InventoryEntity_Inventory].[cInvStd] as cInvStd,[InventoryEntity_Inventory].[cInvDefine1] as cInvDefine1,[InventoryEntity_Inventory].[cInvDefine2] as cInvDefine2,[InventoryEntity_Inventory].[cInvDefine5] as cInvDefine5,[InventoryEntity_Inventory].[cInvDefine6] as cInvDefine6,[InventoryEntity_ComputationUnit].[cComUnitName] as cComUnitName FROM [Inventory] AS [InventoryEntity_Inventory] LEFT JOIN [ComputationUnit] AS [InventoryEntity_ComputationUnit] ON [InventoryEntity_ComputationUnit].[cComunitCode] = [InventoryEntity_Inventory].[cComUnitCode] WHERE 1=1 and ([InventoryEntity_Inventory].[cInvDefine2]=N''??'') and ([InventoryEntity_Inventory].[cInvCode] like @RefFilterParam0 or [InventoryEntity_Inventory].[cInvName] like @RefFilterParam1 or [InventoryEntity_Inventory].[cInvAddCode] like @RefFilterParam2 or [InventoryEntity_Inventory].[cInvMnemCode] like @RefFilterParam3) Order by cInvCode ASC ',N'@reffilterparam2 nvarchar(4000),@daesyslogintime nvarchar(4000),@reffilterparam3 nvarchar(4000),@reffilterparam1 nvarchar(4000),@daesysloginlanguage nvarchar(4000),@daesysloginer nvarchar(4000),@reffilterparam0 nvarchar(4000)',@reffilterparam2=N'%040010101%',@daesyslogintime=N'2011-08-08',@reffilterparam3=N'%040010101%',@reffilterparam1=N'%040010101%',@daesysloginlanguage=N'zh-CN',@daesysloginer=N'demo',@reffilterparam0=N'%040010101%' |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 存货自定义项是指该存货唯一的属性 只有一个值 若多个值应该启用自由项, 例如 衣服有红 蓝 黄 三种颜色,应该启用自由项; |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 库存管理 |
产品: | 供应链 |
问题名称: | 存货自定义项 |
最后更新: | 2011-09-16 23:24:41 |