pjohns
25th April 2002, 15:36
I have been asked if it is possible to control data entry access by field level. e.g. We want to restrict some people from changing the system generated price on sales order lines (tdsls041.pric)

Is this possible?

Thanks

PJ

Darren Phillips
25th April 2002, 16:02
Perhaps table field authorizations would work

Jan Park
25th April 2002, 16:08
I was thinking the same thing...either table field data authorisations ttaad4135m000 or table field authorisations ttaad4133m000. The only thing is, without testing this I'm not sure whether the authorisations are ignored by update sesions i.e where data is auto updated such as the price field you mentioned.

Jan

Ravenscross
25th April 2002, 16:14
I think that you are right Jan.

This does sound like a problem that has been asked at a tech sig many years ago and I think it was found that it could not be done on update sessions.

pjohns
25th April 2002, 16:21
Thanks for your replies.

I will do some testing!

Jan Park
25th April 2002, 16:26
What about looking at it another way. Perhaps margin control against the sales price could be used to solve your problem. Margin control parameters are set at the user level so you could be very prescriptive as to who it would affect. Also the options are refuse, signal, log or block so you could effectively set the margins so that the price could not be altered.

Jan