Skip to Content
author's profile photo Former Member
Former Member

SBO_SP_TransactionNotification: Internal Reconciliation

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jun 05, 2006 at 02:56 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2006 at 02:27 PM

    Hi Harianto.

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

    Best regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 05, 2006 at 04:36 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 08, 2006 at 07:42 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.