Skip to main content

MSDYN365BC - Futuristic CAL Development - Customize Base Code 1.

Hi Readers,

As discussed in the Last article, in this post we will continue with our Customer Requirements.

If you are new to this series then Please Refer Table of Index.

In this article, we will discuss about adding custom code in base objects and what is the Futuristic way of adding code.  In your customer are Pre-2018 then you can use Hooks for those instances.



Let's add the actions in Page Chart of Accounts as shown below.


And similar action in G/L Account Card as shown below.


Now the Next part of customer requirements is to populate Expense Code in Purchase order Page when a G/L Account is selected. For that let's add the field Expense code in Purchase Line Table and Purchase order Subform, as shown below.


Or so last part of customer requirements that we will discuss in this article to have written that custom code which will pull "Expense Code" from G/L Account Card and populate it in Purchase Line.

As all we are C/AL Experts, let's see in Table 39 what happens when user key in the number Field.

  • OnValidate Trigger on No. field has a case Statement which calls different functions based on Type. We are only concerned about CopyFromGLAccount.
  • If we move that function CopyFromGLAccount we will see the last line in Function which says "OnAfterAssignGLAccountValues(Rec,GLAcc)"
  • If we navigate to that function, its a diffrent which which have no code and Function starts with the word [IntegrationEvent]


What we see in Line No. - 4793 above is an Integration Event that we will subscribe for our custom code.

What we would have done in Old C/AL Way?
We would have added one single line of code in CopyFromGLAccount function, which will look something like - "Expense Code" := GLAcc."Expense Code";

How to Do that in Future?

  1. Create a New Codeunit. I am creating codeunit 50000.
  2. Next, I will create a function in Codeunit called "TransferExpenseCodeToPurchLineFromGL"
  3. Next is we will set the following properties - 
    1. Event - Subscriber.
    2. EventPublisherObject - Table 39.
    3. & EventFunction.

If you lookup EventFunction - You will same Integration Event available that we see in the last step.



Click ok to Next message and We will see that few parameters are added in function and Subscriber is added in the function Name.


If we look function closely - Purchase Line variable is passed as Reference so we will be able to plug our code easily as above.

To understand How Execution will occur is like this - 

When System Executes Code in Purchase Line and Code will reach to line No. 2652 and then execution will move to custom Codeunit and then will come back in Table 39.

  • Purchase Line    - Line No. 2652.
  • Codeunit 50000 - Line No. 2653. (actual line No. 6)
  • Codeunit 50000 - Line No. 2654. (actual line No. 7)
  • Codeunit 50000 - Line No. 2655. (actual line No. 8)


In Next article, we will discuss - 
  • What we did in this article? 
  • what is Integration Event? 
  • Who can write it and how it executes?
Hope it makes sense, Stay Tuned for More!. Add your views as the comment to this article.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

  1. Hi Saurabh,If we have more then one Subscriber functions for the same EventFunction then what is the execution priority? I mean sequence of Subscriber functions.

    ReplyDelete
    Replies
    1. @Madhu, As per Microsoft there is no defined execution priority. If you test it then its based on Codeunit ID and then the Function position in the codeunit.

      Delete
  2. Dear Dhyani,Thanks for the information.

    ReplyDelete

Post a Comment

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    ---------------------------

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...

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.