Open Forum

Expand all | Collapse all

How do I create a trigger in business central?

  • 1.  How do I create a trigger in business central?

    Posted 7 days ago
    I need to keep the chart of accounts in business central sync'd to some other systems

    I'd like to do this by adding a trigger (don't know if this is called an extension) so that when a new chart of account is created, I get a notification message.  I have many companies in our business central instance, so would i need one trigger/extension per company or can I do this once across all companies?

    Would appreciate any pointers on how to do this

    Thanks

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: How do I create a trigger in business central?

    Posted 6 days ago
    Power Automate might be the way to go with this.

    ------------------------------
    Marcus Haug
    Stoneridge Software
    MN
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: How do I create a trigger in business central?

    Posted 6 days ago
    would be interested to talk with someone who has done this before!

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: How do I create a trigger in business central?

    TOP CONTRIBUTOR
    Posted 6 days ago
    You can create triggers on most objects in AL: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/triggers/devenv-triggers

    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: How do I create a trigger in business central?

    Posted 6 days ago

    advice on training for a developer to get a trigger created?


    Thanks



    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: How do I create a trigger in business central?

    SILVER CONTRIBUTOR
    Posted 4 days ago
    Hi Benji, do you use Jet Report?

    I believe with a bit of creativity you can achieve the same goal (when a new GL account is created, you get an email notification) using Jet Report schedule. No trigger required.


    ------------------------------
    Leo Chen
    Systems Analyst
    Summit Fertilizers
    ------------------------------

    Conference-BCNAVUG_200x200


  • 7.  RE: How do I create a trigger in business central?

    Posted 4 days ago
    We are not using jet reports but have a chart of accounts table in a sql server database, and could follow the pattern of having  a report surface new accounts, but that's not the approach I want to take, I would Iike it to be more real time

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Conference-BCNAVUG_200x200


  • 8.  RE: How do I create a trigger in business central?

    TOP CONTRIBUTOR
    Posted 3 days ago
    If you know sql you could just create an after insert trigger and use DBmail to send message

    Other alternative is to use a data driven subscription in SSRS, but (IIRC) you need and enterprise edition of SQL.


    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------

    Conference-BCNAVUG_200x200


  • 9.  RE: How do I create a trigger in business central?

    Posted 3 days ago
    I know SQL and Java. I need a video or tutorial on how to push a trigger and what a sample one looks like.   


    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------

    Conference-BCNAVUG_200x200


  • 10.  RE: How do I create a trigger in business central?

    TOP CONTRIBUTOR
    Posted 2 days ago
    Plenty of info here:

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/triggers/devenv-page-and-action-triggers


    Regards

    mark

    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role