Stored Procedure is not working in update mode of object id 7 in SAP 8.82

[former_member591057]

Hi All,

Recently I am facing a problem regarding Stored Procedure in period and volume discount. I have written a stored procedure using object id 7 which is the object id of period and volume discount. The stored procedure is working fine in add mode but in update mode it is not working or I can say it is not firing. This issue is appearing only in SAP 8.82 from PL 05 to PL 07. In other SAP version it is working fine. Please suggest what to do.

Thanks and Regards

Utpal

[pedro_magueija]

Hi Utpal,

Have you checked if there are differences in between the B1 versions on the tables you are using on your SP? One good tool to do this is the Sap Business One DbBrowser included in B1 Development Environment. It will show you the differences on tables between versions.

Good luck.

Best regards,

Pedro Magueija

[former_member591057]

Hi Pedro,

Thanks for your reply. But the problem is that in update mode it is not even entering in the SAP provided SP_Transaction Notification stored procedure but in add mode it is entering.

Thanks

Utpal

[pedro_magueija]

Hi Utpal,

Hmm.. this is rather strange. Are you sure it is not entering the SP? Can you try to cancel all operations by changing your SP (make a backup first) to:

-- Return values
declare @error  int    -- Result (0 for no error)
declare @error_message nvarchar (200)   -- Error string to be displayed
select @error = 9999
select @error_message = N'My test error'
--------------------------------------------------------------------------------------------------------------------------------
-- ADD YOUR CODE HERE
--------------------------------------------------------------------------------------------------------------------------------
-- Select the return values
select @error, @error_message

Then try to update your document. It should stop you if it is entering. If not then I'd recommend going to SAP support.

Also, if possible, post the code you are using in your SP.

Best regards,

Pedro Magueija

[former_member591057]

Hi Pedro,

I have tried the same way as you have tried but as I mentioned before it is not entering or as you have tell don't stopped in the error message section.

Thanks and Regards

utpal