Prevent user from changing open sales order

[Former Member]

Hi

Is it possible to prevent users from editing their own sales orders. We have sales orders that are used for production orders. Users are changing quantities and delivery dates etc, after the production dept has started processing the order...

thanks

[Former Member · Accepted solution]

Hi!

We can achive this by simple Store Procedure.

Add this code in SP_Transaction Notification

Test it in Test DB first.

if @object_type = '17' and @transaction_type='U'
BEGIN
select @error = 17, 
@error_message = 'You cannot Update the Sales Order'
end

[Former Member]

Thanks,

this would mean that every sales order new or changed will need to be authorised. Company has quie a bit of sales orders per day - this could hamper the supervisors other work...

any other suggestions

[Former Member]

Hi!

Then use SP which i posted in my first reply.

[Former Member]

Hi Naeem .

Use SAP default feature :

Go to Administration >System initilisation >Document setting

Select Sales Order

Untick the box - Allow changes to existing order .

Hope this helps

Bishal

[Former Member]

Hi Naim,

Better way use SAP std practice.

1. Put Approval on SO

2. If it get approved u can not change its QTY as well as due date OR else.

Regards,

Mahesh.

[Former Member]

Hi!

Yes, Approval Procedure is a good way than SP. Try that !

[Former Member]

Hi Naeem..........

It can be possible through Approval Procedure. Once Sales order approved then again user will not be allowed to change or edit the document. Please try it.

Regards,