This step is only necessary if you intend to use the SB1 Notification Listener.

After the Notification Listener configuration is done, you need to enable the stored procedures in the stored procedure of SAP named “PMX_TransactionNotification”.

1. Open the SQL Server Management Studio and connect to your database server.

2. Expand the Databases folder and locate the company database to which you want to apply the Produmex Add-on.

3. Open this database directory and open the Programmability / Stored Procedures subdirectory.

4. Locate the dbo.PMX_SP_TransactionNotificationQueue stored procedure, right-click it and select Modify.

5. Locate the Produmex SboNotification Queue Code at the end of this stored procedure (see illustration below)

6. Copy the Produmex SboNotification Queue Code.

This code should now be pasted in the “dbo.PMX_SP_TransactionNotification” stored procedure, in the Company database.

7. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select Modify.

8. Paste the “Produmex SboNotification Queue Code” at the end of it, right after the code you have copied for the Produmex Addon stored procedure (see 3.3.1. Enable the standard PMX stored procedure).

9. Uncomment the SP by clicking the Uncomment button in SQL management studio.
The end result should look like this:

10. Execute the PMX_SP_TransactionNotification stored procedure.