restricted inquiry option for P4310

ozanjde

Member
Hi,

We are facing a problem where it is required to setup the PO Inquiry program
in a way that each user can only view his/her requisitions, orders etc (or
by other means of restriction - approval route, buyer, ship to etc). Before
we dig into the security setup options to perform such a result
(originator), I appreciate any ideas/experiences to develop a workaround.

Thanks,

Ozan Basegmez

OneWorld Xe B7333
Update 3, SP 20
W2K, SQL 2000
Citrix Metaframe XPs 1.0

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca
 
Try row security. Select the table your concerned with (F4310) and the data item USERID. In this example the USERID is JDEUSER. The From Value will be AAAAAAAA, Through Value will be JDEUSEQ, N for Add, Change, Delete and View. Create another row security on the same table and data item. From Value will be JDEUSES, Through Value will be ZZZZZZZZZ, N for Add, Change, Delete and View, thus restricting JDEUSER from seeing any entries they didn't create. Repeat this procedure for any other table where you want the restriction to apply.
 
Back
Top