Hello all u geniuses out there!
I am using SAP B1 2007 PL42 and SQL Server 2005. I want to write a SQL query in the
SBO_SP_TransacitonNotification procedure to update Price Lists based on the exchange rate. I have got the query working to update the prices but I cant seem to trigger this query to run if the Exchange Rates Table is updated.
As far as a can see - there is no ObjectID for the Exchange rates table. All I can find out is that when an exchange rate is updated in the Exchange Rates form (Form Id 866) it writes to the ORTT table. Does anyone have any idea how I can catch the event of the exchange rate being updated in my SBO_SP_Transaciton Notification stored procedure?