How to create display method on table extension in D365

Description:-

This posts helps you to understand and create a "display" method for the table extension.

Let’s say, the requirement is to add a method in the standard table, it can be achieved either by creating a table extension.

So in this scenario we had a requirement to add a display method in the standard table "CustTrans".

In Dynamics 365 we won’t be able to add the new method or modify the existing method to the standard table or to an extension table.

It can be achieved by using the extension class.

Step 1: Create a new class and name it as <Classname>_<Extension>.

<Class-name> - can be any name, but it is preferred to give the table name for which the extension is being created. 

Postfix <_Extension> is must.

Public static class CustTrans_Extension
{ 

}

Step 2: Now add the display methods in the class which is required to be shown.

public static class CustTrans_Extension
{
   [SysClientCacheDataMethodAttribute(true)]
   public static display AgreementId agreementId(CustTrans _this)
   {
      LedgerJournalTrans ledgerJournalTrans;
      
      select ledgerJournalTrans
       where ledgerJournalTrans.TransactionType == LedgerTransType::Payment &&
             LedgerJournalTrans.CustTransId == _this.RecId;

      return ledgerJournalTrans.AgreementId;
   }
}

Step 3: To use this display method in the form.

Create a string control in the form design and set the following properties
Data source: CustTrans
DataMethod: CustTrans_Extension::agreementId
CacheDataMethod: Yes

Step 4: Build/Rebuild the project/solution and check the output in the URL.

Related Posts

Previous
Next Post »

Thanks for comments.....