Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Adding triggers in GP ...
Microsoft Dynamics GP (Archived)

Adding triggers in GP Database

(0) ShareShare
ReportReport
Posted on by Reem Jacob 800

Hi

We want to add a trigger in the GP database for Item creation. The trigger will insert item number and name into another database.

Can anyone tell me if there are any know issues with adding triggers into GP database?

Regards

Reem

*This post is locked for comments

  • Reem Jacob Profile Picture
    Reem Jacob 800 on at
    Re: Re: Adding triggers in GP Database

    Thanks Ron for another reason to stay away from triggers, but is there an other way to track table changes real-time.

    Regards

    Reem

  • Ron Draganowski Profile Picture
    Ron Draganowski 1,575 on at
    Re: Adding triggers in GP Database

    Adding triggers to a GP database against a GP table (GP Tables always have the DEX_ROW_ID column) is very dangerous!  If your trigger fails, it will fail the GP action which is working with the table.  For instance, a posting process could just fail.  No rollback.  No error message.

     This used to be a much worse problem, but some posting processes now have rollback built in.  However, record saves and so forth do not.  So, when adding triggers, but sure that you handle any possible failure points perfectly!

     

    Ron Draganowski
    Solution Services Practice Manager
    Olsen Thielen Technologies, Inc.
    St Paul, Minnesota


    rdrag@ottechnologies.com
    http://www.ottechnologies.com


     

    Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski

     

  • Reem Jacob Profile Picture
    Reem Jacob 800 on at
    Re: Re: Adding triggers in GP Database

    Thanks for the information. Is there any other way to look for changes in the database?

  • GoFast Profile Picture
    GoFast 200 on at
    Re: Adding triggers in GP Database
    There is always a risk of a performance hit when you add triggers in the db. However, if you are only writing those 2 fields on inserts, this should not be an issue. You also might want to disable any triggers during upgrades. They can slow the upgrade and create several false positives in your audit.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,375 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans