on 03-31-2011 10:57 AM
Hi Expert,
Hope you can help on this...
I have to restrict specific user to modify the Sales Order where Series='SO-BOM', they can only modify this Sales Order with authorization from manager or from specific user....
Can i do this on TransactionNotification from StoredProcedure?
Thanks,
Richard
Hi,
Check this first:
IF @transaction_type = 'U' AND @object_type = '17'
BEGIN
If exists
(Select T0.DocEntry
ORDR T0
INNER JOIN NNM1 T1 ON T0.Series=T1.Series
Where T1.SeriesName='SO-BOM' AND T0.DocEntry = @list_of_cols_val_tab_del)
Begin
Select @error = 17, @error_message = N'Sales Order can not be modified!'
End
END
If it works, you can add user codes into it.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.