Share
ReportAre custom triggers allowed to be written on the Dynamics and Company databases of GP?
*This post is locked for comments
You’re offline. This is a read only version of the page.
6,010
Are custom triggers allowed to be written on the Dynamics and Company databases of GP?
*This post is locked for comments
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.
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.
Best regards,
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)?
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.
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (