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, 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 >