Skip to main content

Microsoft Dynamics NAV 2016 - How to Use Trigger Events - Part 2

Hi All,

Let's start it from where we left in Last Post.

Recap - "We Created A Custom Table & Page, Linked that to Standard Item Page. Then we Created a Custom Codeunit, Created a Function in Codeunit which Subscribe the OnBeforeDelete Event of Item Table and Called Custom Code in the Subscriber Function."

If you are missing the Story, Refer Table of Index.

In this article we will try to bring the Value of Last Revision for Item When Item Get Selected in Sales Line Using Trigger Event Subscription.

JUST TO CLARIFY - "Some people are getting confused on the new approach of customization using Events. They Feel that everything will be 100% out of standard Code. It's not True. Field Addition and Event Definition are still need to be done on Base Objects."

So let's Continue. Create a Field "Latest Revision No." in Sales Line Table and in Sales Order Subform Page.

Now We Need to Fill Revision No., Whenever there is a New Sales Line of Type Item is Added or Modified. Let's see how we used to do this till date.

Let's See how we Should We Do it Now - 

1. Create a New Function (CustomerAfterItemValidate) in Custom Codeunit 60000 Say MyCustomer Event Subscribers.
 > Navigate to Properties of Function and set as below -
   > Event - Subscriber
   > EventPublisherObject - Table 37
   > EventFunction - OnAfterValidateEvent (Say Yes to Confirmation Window).
   > EventPublisherElement - No.

2. Let's Add Same Code but as its a Different Object we need to Add some more conditions on the Event Subscriber as shown Below -

3. So That's it, we can test the Process with a Simple Example as shown below the Demo Steps -

Select a Item in Sales Order having Revisions Filled In Like 1000 & Latest Revision No. Should be Filled in Automatically as shown Below.

So With This Demo I hope we understand How to Use Trigger Based Events.

I Know a Common Question that most of you will have is  "Hey Saurav, What about the Code that I Write in the Mid of The Say OnValidate Trigger of the Field in any table. I am sure we cannot right it on Before or After. How we handle those?"

Hey Readers We will cover that also in the series, so stay connected and Provide your Feedback..

If you have any question / Suggestion / Feedback feel free to put as a comment to article or send me a Email using Contact Form.

If required you can download the Related Objects from SKYDRIVE.

File Name - Microsoft Dynamics NAV 2016 - Event Demo (Part 2 Objects).rar

Stay Connected, More is about to be Published. In Next Article we will see the Business & Integration Events.

Saurav Dhyani


Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.