Notifications
Announcements
No record found.
Are custom triggers allowed to be written on the Dynamics and Company databases of GP?
*This post is locked for comments
Depends what you mean by allowed!. Yes, its possible. What kind of triggers, and on what tables etc? You need to be careful. I have lots of examples of customers messing up the standard buiness logic in GP depending on when their custom triggers run - especially in SOP.
Best regards,
SOP was where I was wanting to place a trigger. To trigger when a specific batch is hit (our credit review batch). So you think this could cause issues? If so, I can just run a query in very short intervals (90 secs or something) to check for new orders in that batch. I would prefer a trigger so that it is real time, but I would also perfer not to bork our GP install.
I believe that as long as you are only adding a new trigger and not changing existing triggers and are not trying to change the behavior of the system, you should be fine. You're testing this, of course, in a test company database.
Thanks for the input guys. I am not looking to modify any existing triggers at all. Only add new ones. So then there should be any issues with this regarding the business logic? What about performance issues (which I know is an fairly vast question)?
Triggers on batches should be OK. Are you hoping to get data every time a transaction is added to certain batch? This will be straighforward.
Mariano is right. Triggers are fine and we've also written literally hundreds. The only issues I have seen was with triggers written by customers on the SOP entry window. I've seen cases where genuine GP triggers didn't fire because a custom trigger was firing first etc. Test in a test company with a trace running. Generally performance is not an issue.
Great...thanks guys. I would think this trigger would be after the fact of SOP entry. We actually do not use GP's interface for SOP entry, so I would think that once an order is saved and processed through eConnenct, all the business logic should have fired correct? After that, I am just wanting to trigger an event if the order lands in the "CREDIT REVIEW" batch.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
