关于871版本库存管理设置存货字段级权限控制但是参照仍可以看见其他无权字段问题分析1.首先是设置字段级权限控制无效之前的设置，下面是库存选项中已经勾选“检查存货权限”2.下面一张图是设置存货档案字段级权限的界面3.新增单据选择仓库之后参照的时候界面，此时就控制不住了，如下图：4.经数据跟踪发现下面检查权限语句没有任何记录。selectbauthcontrol,b.cBusObIdfromAA_BusObjectaleftjoinAA_ColumnAuthMappingbona.cBusObId=b.cBusObIdwhereiAuthType=1anda.cBusObId=N'inventorykcref'selectdistinctcFldfromaa_columnauthcacheWhereckey=N'inventorykcref'And((cUserId=N'1'AndisUserGroup=0)or(cUserIdin(N'OAAddrAdmin',N'OAArchiveAdmin',N'OAArchiveDepotAdmin',N'OAArchiveHandler',N'OABBSHostAdmin',N'OACalendarAdmin',N'OAChatAdmin',N'OAContractAdmin',N'OAContractDepotAdmin',N'OADeviceAdmin',N'OADevTypeAdmin',N'OAEducationAdmin',N'OAEmailAdmin',N'OAEventsAdmin',N'OAFileTransAdmin',N'OAHappyBirthdayAdmin',N'OAInfoAdmin',N'OAKmAdmin',N'1')andcfldnotin(selectdistinctcFldfromaa_columnauthcacheWhereckey=N'inventorykcref'And((cUserIdin(N'OAAddrAdmin',N'OAArchiveAdmin',N'OAArchiveDepotAdmin',N'OAArchiveHandler',N'OABBSHostAdmin',N'OACalendarAdmin',N'OAChatAdmin',N'OAContractAdmin',N'OAContractDepotAdmin',N'OADeviceAdmin',N'OADevTypeAdmin',N'OAEducationAdmin',N'OAEmailAdmin',N'OAEventsAdmin',N'OAFileTransAdmin',N'OAHappyBirthdayAdmin',N'OAInfoAdmin',N'OAKmAdmin',N'1')AndcfuncidlikeN'%R%')))))AndcFuncIdlikeN'%N'解决方案：1.首先在查询分析器中执行下面脚本插入一条记录INSERTINTO[UFDATA_888_2008].[dbo].[AA_BusObject_base]([cBusObId],[cBusObName],[iAuthType],[bAuthControl],[cSub_Id],[cMark],[iFuncType],[langid],[iOrder],[bLocked],[cLockedBy])VALUES('inventorykcref','库存管理存货参照',1,1,’ST’,null,2,'zh-cn',2,null,null)2.返回数据权限控制设置界面查看3.数据权限设置界面选择相应的“库存管理存货参照”字段设置相应的权限，先仅设置一个存货编码字段能够查询和录入的权限，其他字段均是无权4.然后再返回库存单据界面，选择仓库选择存货参照（如下图所示）这个时候就可以控制住权限了。
