Lock UDF Update for Posted Document

[Former Member]

Hello everyone!

Is there a setting or any workaround in SAP B1 where we can prevent users from updating header UDF for posted marketing documents?

Thanks,

Jaren

Edited by: Jaren Loyola on Nov 3, 2009 4:33 AM

[former_member206437 · Accepted solution]

Hi

This can be achieved By Stored Procedure or by SDK only as per My knowledge, no work around in normal SBO.

Giri

[former_member583013]

Jaren,

The is no straight way to achieve this unless you so it through the 2 options suggested by the other memebers.

Stored Procedure is a quick way as you do not need to do the whole SDK coding but writing the logic is not going to be easy.

There might be several UDF's and tracking if it changed when the Update event fires is quite complex

Regards

Suda

[Former Member]

Using the Transaction_Notification stored procedure would not be very difficult. Monitoring for closed documents and not allowing them to be updated would only be a few lines of SQL code. No different than adding any other validation logic.

That's the approach I would suggest if your needs are as simple as stated in the original post.

[Former Member]

Thank you all for the response.

I have created simple transaction_notification stored procedure before, like making fields mandary. I have no idea how to start to create a stored procedure for blocking updates of fields. Do you mind sharing sample queries?

Thanks again!

[Former Member]

Hi,

Stored Procedure would be effective to pull values or data. In order to stop updation of UDF after a transaction is complete and the document is saved. Use SDK and create an add-on to enable this functionality, which is actually very easy.

Regards

Sudatta