Can anyone enlighten me on the above? Basically I will like to control who can create or update a marketing document (Super User can, but Normal User can't).
I could query the user type of the user whom is creating the marketing document. But how can I query the user type of the user whom is "Updating" the marketing document?
Actually my intention is to control selling price in AR Sales Order. And I do the control by modifying the SP_Notification stored procedure. My problem now is that, whenever a SUPERUSER tries to "Update" an order that was created by a Normal User, the selling price control will be validated(instead, it should skip the validation), basically because Im checkin for the UserSign column in the ORDR table.
Is there any way I can check the account type of the user whom is "Updating" the document?
Correct me if Im wrong. The usersign column is only updated during insertion, during update, the usersign will not change. So you mention during updation, check for usersign and OUSR.usertype will not work as usersign will still reflect the user that "created" this document.
I wish to capture the user "updating" this document.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.