pRODUCTION ORDER NOTIFICATION

[Former Member]

DEAR EXPERTS,

I WANT TO WRITE A TRANSACTION NOTIFICATION TO BLOCK USERS FROM MODIFYING THE PRODUCTION ORDER ONCE A RECEIPT HAS BEEN DONE. THAT IS DELETING THE COMPONENTS LINES.

REGARDS,

ANTONY

[Former Member]

Dear Antony,

You may check this thread first:

BTW, all caps in sentence means shout.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thanks for the link and sorry for that, it didnt mean shout from me but will stop using caps in a sentence.

Thanks

[Former Member]

Hi Gordon,

I checked the threads and they all realate to quanties. I have a scenario whereby i have a production with 10 components. Now i do a receipt, then i come back to the production order and delete an item. Now i have 9 components. What i want to prevent is users modifying the production order after doing my receipt i.e. deleting or adding an item on the proction order.

Regards,

Antony

[Former Member]

Try this one:

IF (@object_type = '202' AND @transaction_type= 'U')

BEGIN

If exists

(Select DocEntry

From OWOR T0

Where T0.DocEntry = @list_of_cols_val_tab_del

and T0.Status = 'R'

Begin

set @error =1

set @error_message = 'You can not update/delete from released order!'

End

END

[Former Member]

Hi Gordon,

This actually blocks receipts from production when i try to add receipt from production.

Regards

Antony