› Dynamics 365, Enterprise › Add custom Table method on Form in D3FOE

Add custom Table method on Form in D3FOE

Sohagani Shah
ERP Developer
Published on December 31, 2017
Category: Dynamics 365, Enterprise

Background:

As we know, we can only work with Extension code in D365 Finance and Operations. In this blog article, we will see how we can add a custom display method to a Table and display it on form using Extension.

Steps:

  1. Create a new Class
  2. Add Display method
  3. Display the method on form

1. Create a new Class:

  • Go to Solution Explorer -> Project
  • Right Click -> Select ‘Add new Item’
  • Select Class -> Enter Name. Class name can be anything ending with ‘_Extension’. Eg. <ClassName>_Extension
  • Click Ok

2. Add Display method:

Public Static class CFLoyaltyaddphone_Extension // Class must be static 

{ 

    [SysClientCacheDataMethodAttribute (true)]  //This statement will cache display method 

    public static display LogisticsElectronicAddressLocator CFS_GetPhoneno (RetailLoyaltyCard _this) //Pass Tablename as Parameter 

    { 

        DirpartyTable dirPartyTable; 

        Dirpartylocation dirpartylocation; 

        LogisticsElectronicAddress logisticsElectronicAddress; 

        select * from dirpartylocation 

            where  dirpartylocation.Party == _this.Party 

            join logisticsElectronicAddress  

            where logisticsElectronicAddress.Location == dirpartylocation.Location  

            && logisticsElectronicAddress.IsPrimary == NoYes::Yes  

            && logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone ; 

         return logisticsElectronicAddress.locator; //Return Field value                  

    }  

}

3. Display the method on Form:

  • Add the field type on form Design.
  • Change the below property
  • change property

 



Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Looking for a demo?

We will get back to you very soon!
We promise.

  • This field is for validation purposes and should be left unchanged.