Miles Hart Posted September 10 Share Posted September 10 Hi, I'm putting together a proof of concept and investigating duplicate some of the data locally. I have implemented a trigger on the SODOCUMENT object to duplicate data, which POSTs our useful data into our onsite database. I want to also do this for the SalesOrderLines (as we internally call them or - SODOCUMENTENTRY) However there is not a regular trigger to do this? Would SmartEvents be better suited for this? Thank you Miles Link to comment Share on other sites More sharing options...
Members Sterio, Louis Posted September 17 Members Share Posted September 17 If your goal is to retrieve any changes to line items, to me it would make sense to trigger on updates to the SODOCUMENT header and then query all related lines externally that being said there are trigger capabilities on the SODOCUMENTENTRY and smart events. 1 Link to comment Share on other sites More sharing options...
Miles Hart Posted September 19 Author Share Posted September 19 Thank Louis, good idea. I did find the object in the Sage UI object browser, and add a trigger there. We will probably look to doing periodic compare and update if there are any inconsistencies. However I think your suggestion we will investigate further. Our integration with out operation system is quiet involved with a handful of finance users logging directly into Sage, This is required in the rare case where the finance team do make changes in the Sage UI, they are reflected in near real time as possible. So far the triggers are working great. Thanks again Miles 1 Link to comment Share on other sites More sharing options...
Recommended Posts