SAP B1 Stored Procedure trigger when user logging in.

[owaisk]

Hello Community,

I have created a stored procedure that i want to trigger when a user logged in to SAP B1. How i can iachieve it ?

BR,

[felipeprevente]

Hi Owais,

The editable Store Procedures you will find within the system (TransactionNotification / PostTransactionNotice) are triggered by adding or updating an object. Assuming that the act of merely logging into the system doesn't add or update an object, you won't be able to trigger your logic in a standard way.

Maybe with the help of a market Add-On or via bespoken SDK solution, you might achieve it.

Cheers,

Felipe

[Johan_Hakkesteegt]

Hi,

Is the Access Log report (Tools > Access Log) not enough? It already tells you everything you may need to know about users logging in.

Regards,

Johan

[azizelmir]

Hi Khalid,

SBO has a Stored Procedure called SBO_SP_TransactionNotification. This will fire each time a transaction is affected in SBO. You can use this to "trigger" your own SP.

Thank you,

Aziz

[owaisk]

Hello azizelmir

Thanks for the reply, i know SBO_SP_TransactionNotification triggers on obect type of ducument.

but i want to execute sp when a users login to sap, when a user press ok after entering username & password.

Regards,