on 03-15-2013 9:45 AM
Hi,
I want to know the difference between these two as they look same.
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/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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In simple terms Transaction Notification runs at the time of posting transaction and Post transaction notifications runs even after posting the transactions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
The difference is post transaction notification gives alert after adding the documents and transaction notification alert before adding the documents.
Hope helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Khagesh,
Check this :
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.