cancel
Showing results for 
Search instead for 
Did you mean: 

difference between posttransnotificaion and transnotification procedure

Former Member
0 Kudos

Hi,

I want to know the difference between these two as they look same.

Accepted Solutions (1)

Accepted Solutions (1)

KennedyT21
Active Contributor
0 Kudos

Hi Khagesh Gupta

Transaction Notification

The SP_TransactionNotification is the only legal way in SAP Business One to receive notification of data-driven events - in order words to do some validation in SAP Business One and prevent the user from doing an action if the validation condition fails. This stored procedure(SP) is created automatically with each database.

check with the Links for help

http://scn.sap.com/people/janos.nagy/blog/2009/12/12/how-to-execute-custom-code-via-sptransactionnot...

http://scn.sap.com/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-proce...

SBO_SP_PostTransactionNotice and SBO_SP_TransactionNotification can by edited by the user to add sql code as part of a notification process. The functionalities of both  are the same, the only differences being when they are triggered and the ability to use the @error functionality of SBO_SP_TransactionNotification to rollback transactions. SBO_SP_PostTransactionNotice can only be triggered at the end of an action (transaction committed). It is preferable to use SBO_SP_PostTransactionNotice - although as this occurs after the transaction, the @error rollback functionality can not be used.

Further Documentation

The following documenatation is available on the SDN:                                                                               
    o  Using the SBO_SP_TransactionNotification Stored Procedure:              
                                                                               
       http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uu       
       id/e991e2b9-0901-0010-0395-ef5268b00aaf                                                
                                                                                                  
                                                                               
    o  SAP Business One Add-On Solution Certification                          
                                                                               
       http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/libra       
       ry/uuid/81a22ee1-0701-0010-45aa-ec852e882de3               

Hope helpful

Regards

Kennedy

Answers (5)

Answers (5)

In August 2019 we created a Support Incident (495806 / 2019) with B1 to clarify the differences between SBO_SP_TransactionNotification and SBO_SP_PostTransactionNotice stored procedures. SAP Note 1320484 said they are the same but our testing showed they are not. We asked for clarification and a definitive statement and if true a correction to SAP Note 132048 Here is what we got in response to the Incident

"Our development team informed the note provided wrong information regarding the designed behavior. This is the correct behavior:

SBO_SP_TransactionNotification = When @error is different from 0, rollback the transaction and show @error_message in Business One Client.

SBO_SP_PostTransactionNotice = When @error is different from 0, register @error and @error_message in Business One log files. No alerts are showed in Business One Client.

We changed the note 1320484 and it's under review to be released to the customers. I will let you know as soon as it's released."

So it is confirmed, SBO_SP_PostTransactionNotice will not display the @error and @error_message in Business One Client, so it behavior is different than SBO_SP_TransactionNotification

Abdul
Active Contributor
0 Kudos

In simple terms Transaction Notification runs at the time of posting transaction and Post transaction notifications runs even after posting the transactions.

Former Member
0 Kudos

Hi abdul.mannan6 ,

can you please elaborate it more with example so it will be better for me to understand

Regards

Brij

Abdul
Active Contributor
0 Kudos

For example you are posting a Purchase order, transaction notification will run before saving values in database tables and of there is some UDF update used in transaction notification then it will update before saving and then results will be saved. Similarly post transaction notification first post values in tables then execute the stored procedures and update vaues saved in tables

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

The difference is post transaction notification gives alert after adding  the documents and transaction notification alert before adding the documents.

Hope helpful.

Former Member
0 Kudos

Hi,

In short: the key difference is the first one only execute after the transaction posted while the later execute before posting. Most users only use the later because it can be used to verify data to block unwanted posting.

Thanks,

Gordon

VamcParimisetti
Contributor
0 Kudos

Hi Khagesh,

Check this :

What the other SBO Stored Procedures do.

In the 2007 version there are 4 stored procedures:
- SBO_SP_PostTransactionSupport and SBO_SP_TransactionSupport (since SAP Business One 2007)
- SBO_SP_PostTransactionNotice (since SAP Business One 2007)
- SBO_SP_TransactionNotification

The stored procedures SBO_SP_TransactionSupport and SBO_SP_PostTransactionSupport are encoded and cannot be edited by the user. They are database notification stored procedures which can be used by SAP support to add diagnostic code so they are of no use for customer's daily work. Since they are of no use it is planned to remove them in SAP Business One Version 8.8.

SBO_SP_PostTransactionNotice and SBO_SP_TransactionNotification can by edited by the user to add sql code as part of a notification process. The functionalities of both  are the same, the only differences being when they are triggered and the ability to use the @error functionality of SBO_SP_TransactionNotification to rollback transactions. SBO_SP_PostTransactionNotice can only be triggered at the end of an action (transaction committed). It is preferable to use SBO_SP_PostTransactionNotice - although as this occurs after the transaction, the @error rollback functionality can not be used.

Further Documentation

The following documenatation is available on the SDN:                                                                               
    o  Using the SBO_SP_TransactionNotification Stored Procedure:              
                                                                               
       http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uu       
       id/e991e2b9-0901-0010-0395-ef5268b00aaf                                                

http://scn.sap.com/thread/941719

http://scn.sap.com/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-proce...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e991e2b9-0901-0010-0395-ef5268b00...