Hi Mary Ann,
Thanks for your help, do you mind to send me the manual? it would be great if u could. Thanks & regards, Mairi On Thu, May 1, 2008 at 6:19 PM, handmaryann <[EMAIL PROTECTED]> wrote: > This would need to be done with a customization because the on-hand > form actually must aggregate data for the display. You may be able to > use the command "<table>.RecordLevelSecurity(true)" for version 4.0 > and higher. See Dev IV manual - chapter 2. However, this would be > done within the code that does the selection of data for aggregation. > This solution would use security - but it is still a customization. > > Mary Ann > > --- In > Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > Mairi > <[EMAIL PROTECTED]> wrote: > > > > Dear All, > > > > How to put query based on user & warehouse in Invent On Hand form? > > example : > > - user "A" only can see for warehouse "W1" > > - user "B" only can see for warehouse "W1" & warehouse "W2" > > > > I already tried using Record Level Security to put query for > specific user & > > warehouse, > > but doesn't work. Is there any other way, is it possible using > security > > setting or i have to customized for this one ? > > > > > > Thanks for your advance, > > > > Regards, > > Mairi > > > Recent Activity > > - 15 > New > Members<http://groups.yahoo.com/group/Axapta-Knowledge-Village/members;_ylc=X3oDMTJnOHQ5amFpBF9TAzk3MzU5NzE0BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxMjA5NjQwNzg4> > > Visit Your Group > <http://groups.yahoo.com/group/Axapta-Knowledge-Village;_ylc=X3oDMTJmNnRwb21wBF9TAzk3MzU5NzE0BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEyMDk2NDA3ODg-> > Yahoo! Finance > > It's Now > Personal<http://us.ard.yahoo.com/SIG=13omj87ci/M=493064.12016257.12445664.8674578/D=groups/S=1705001380:NC/Y=YAHOO/EXP=1209647988/L=/B=ziDWAkJe5tM-/J=1209640788345464/A=4507179/R=0/SIG=12de4rskk/*http://us.rd.yahoo.com/evt=50284/*http://finance.yahoo.com/personal-finance> > > Guides, news, > > advice & more. > Search Ads > > Get new > customers.<http://us.ard.yahoo.com/SIG=13oq17ekk/M=493064.12016308.12445700.8674578/D=groups/S=1705001380:NC/Y=YAHOO/EXP=1209647988/L=/B=zyDWAkJe5tM-/J=1209640788345464/A=3848641/R=0/SIG=1312g85fq/*http://searchmarketing.yahoo.com/arp/srchv2.php?o=US2003&cmp=Yahoo&ctv=Groups2&s=Y&s2=&s3=&b=50> > > List your web site > > in Yahoo! Search. > Yahoo! Groups > > Balance your > life<http://us.ard.yahoo.com/SIG=13o05l31q/M=493064.12016238.12823558.8674578/D=groups/S=1705001380:NC/Y=YAHOO/EXP=1209647988/L=/B=0CDWAkJe5tM-/J=1209640788345464/A=5286667/R=0/SIG=11in3uvr5/*http://new.groups.yahoo.com/planforabalancedlife> > > by learning how to > > make smart choices. > . > > >