SBO_SP_TransactionNotification: Internal Reconciliation

[Former Member]

Hi Folks,

Does anyone know if Internal Reconcialiation also called the SBO_SP_TransactionNotification store procedure? If yes, What is the @object_type code?

Thanks very much

Harianto

[Gianluigi]

Short answer:

yes, they will get notified.

Longer version:

Let's consider a scenario where users A, B and C registered all a listener to get notified on all events of every kind of objects. And user Z will create a new BP, either from SDK or from B1 Desktop. Then DI Event Server will callback all the listeners registered by users A, B and C.

Let's suppose instead that user A registered a listener to get notified on Delete event from BP. And user B registered a listener to get notified on all events related to Items objects. And user C registered a listener to get notified on all events of every kind of objects. In this case when user Z creates a new BP, only user C listener will be called back.

[Gianluigi]

Harianto hi. If you register for events you will receive all the events you asked for, regardless the user that made this event raise.

BTW DI Event Server offers you a quite complete interface. You can decide which kind of event to be notified (Create, Delete, Update, etc) and filter also with regards to the kind of objects that raised the event.

For instance you can ask to be notified when a Delete event is raised,or when a Delete event is raised for a BusinessPartner, or when any kind of event is raised for a BusinessPartner, or when any kind of event is raised for any kind of object, and so on.

Have a look at the doc that comes with the package.

[Former Member]

Thanks Bagnoli,

Just re-confirm with you,

If user A create a Business Partner, will user B, or user C be notified as well? Assuming all user has listerner in the add-on.

Regards,

Harianto

[Gianluigi]

SBO_SP_TransactionNotification is a SP that is called everytime a B1 object is created / deleted or updated. The object_type parameter is the type of the object being modified, as specified in the BoObjectTypes enum.

You can use SBO_SP_TransactionNotification to intercept data events. Anyway, I strongly advise you to use the DI Event Server published here in SDN under the section Business One SDK Tools. It is based on SBO_SP_ but offers you a cleaner and safer interface to data event handling.

[Former Member]

Hi folks,

Thanks for the post. I found the ObjectCode already. It is 26 for Internal Recon. Anyway, the third & fourth parameter i get is in tab-delimited format, as following:

EXECUTE SBO_SP_TransactionNotification N'26',N'A',3,<i><b>N'MthAcctCod IsInternal MatchNum',N'CAA0001 I 1'

</b></i>

Do you guys know how i can split the delimited parameter in SQL Server? I need to get the Value "CAA0001", "I", and "1". Really hope someone can help me with this.

Hi Bagnoli,

I am looking into the DI Event Server, too. One question. If let say, I have add-on installed in multi user environment and the add-on is incorporated with the listener, if a user add a transaction (eg: Invoice), does it mean that ALL the user running the add-on will receive the notification? Or only the user that create that particular Invoice?

Your helps will be very helpful, guys.

Thanks,

Harianto

[Former Member]

Hi Harianto.

You Can make a trace with SQL Profiler to look the SBO_Transaction call when process ends.

Best regards.