How to Know User ID in SBO_SP_TransactionNotification?
It is too easy for users who should be able to close production orders to forget to report completion first. If these steps are done in the wrong order, you cannot simply re-open the production order to fix it.
I want to update SBO_SP_TransactionNotification to make it disallow non-superusers from closing incomplete production orders. But the logged-in user's ID isn't passed as a parameter.
Is there any way to learn the logged-in user's UserCode or UserID during execution of SBO_SP_TransactionNotification?
Through UserSign field you can create the validation.
You can use the below query
IF EXISTS (SELECT T1.DocEntry FROM OITM T0 JOIN PDN1 T1 On T0.ItemCode =T1.ItemCode JOIN OPDN T2 ON T1.DocEntry= T2.DocEntry WHERE T0.QryGroup7 ='Y' AND T2.usersign <>1 AND T1.DocEntry = @list_of_cols_val_tab_del)