Dear expert can any one help me to write the procedure under which we want that once we print the sales order users can not be update or edit the sales order except the Remark(comment) column.
Below store procedure i can do but i want to left remark column .
if @object_type = '17' and @transaction_type = 'U'
BEGIN
if exists(Select T0.DocNum from [ORDR] T0
Where T0.printed='Y'
AND T0.DocEntry=@list_of_cols_val_tab_del)
begin
SELECT @error = -5001, @error_message =
'Sales order not updated once print'
end
please help me
thanks