Usersign2 in UDO-SAP Business One

[sudhirtamilvanan]

Dear Experts,

is there any way to get update user details for a UDO similar to marketing documents?

I checked the change log, but the history table for UDO is also not showing update user details just showing usersign and creator.

is there any way to capture the current user through Transaction Notification and update as update user in a udf.

Regards,

Sudhir Tamilvanan

[Johan_H]

Hi,

Please try this query with a formatted search in your udf:

SELECT T0.[U_NAME] FROM [OUSR] T0 WHERE T0.[internal_K] = $[USER]

Regards,

Johan

[sudhirtamilvanan]

Dear Johan,

I have tried above query, but it work for FMS not for transaction notification. Am trying with transaction notification.

Regards,

[Johan_H]

Hi,

You cannot delete, update or insert directly from transaction notification. If you want to register the user in a UDF, you will have to use a formatted search.

You can also try to create a stored procedure to perform the update, and call that stored procedure in the transaction notification. However, I do not know for sure that this will work.

Regards,

Johan